Query Metrics
90
Database Queries
21
Different statements
1728.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
920.39 ms (53.26%) |
1 |
SELECT c0_.id AS id_0, c0_.temporary_cart_number AS temporary_cart_number_1, c0_.type AS type_2, c0_.number AS number_3, c0_.slip AS slip_4, c0_.status AS status_5, c0_.order_picker AS order_picker_6, c0_.created_at AS created_at_7, c0_.delivery_date AS delivery_date_8, c0_.login AS login_9, c0_.user_reference AS user_reference_10, c0_.tracking_number AS tracking_number_11, c0_.deposit AS deposit_12, c0_.sector AS sector_13, c0_.sub_sector AS sub_sector_14, c0_.customer_name AS customer_name_15, c0_.address1 AS address1_16, c0_.address2 AS address2_17, c0_.address3 AS address3_18, c0_.zip_code AS zip_code_19, c0_.city AS city_20, c0_.country AS country_21, c0_.phone AS phone_22, c0_.fax AS fax_23, c0_.email AS email_24, c0_.customer_name_delivery AS customer_name_delivery_25, c0_.address1_delivery AS address1_delivery_26, c0_.address2_delivery AS address2_delivery_27, c0_.address3_delivery AS address3_delivery_28, c0_.zip_code_delivery AS zip_code_delivery_29, c0_.delivery_city AS delivery_city_30, c0_.country_delivery AS country_delivery_31, c0_.delivery_phone AS delivery_phone_32, c0_.fax_delivery AS fax_delivery_33, c0_.email_delivery AS email_delivery_34, c0_.reglement AS reglement_35, c0_.updated_at AS updated_at_36, c0_.price_ht AS price_ht_37, c0_.price_tva AS price_tva_38, c0_.price_ttc AS price_ttc_39, c0_.price_cost_ht AS price_cost_ht_40, c0_.display_ttc AS display_ttc_41, c0_.package_number AS package_number_42, c0_.weight AS weight_43, c0_.volume AS volume_44, c0_.discount AS discount_45, c0_.feedback AS feedback_46, c0_.global_discount AS global_discount_47, c0_.commitment_number AS commitment_number_48, c0_.promotional_code AS promotional_code_49, c0_.multiplier_coefficient AS multiplier_coefficient_50, c0_.is_out_of_budget AS is_out_of_budget_51, c0_.lead_word AS lead_word_52, c0_.facturation AS facturation_53, c0_.complete_delivery AS complete_delivery_54, c0_.urgent_delivery AS urgent_delivery_55, c0_.complete_facturation AS complete_facturation_56, c0_.paypal AS paypal_57, c0_.regroupement AS regroupement_58, c0_.transaction AS transaction_59, c0_.plate_number AS plate_number_60, c0_.is_hidden AS is_hidden_61, c0_.budget_id AS budget_id_62, c0_.customer_id AS customer_id_63, c0_.billing_customer_id AS billing_customer_id_64, c0_.user_id AS user_id_65, c0_.delivery_id AS delivery_id_66, c0_.market_id AS market_id_67, c0_.price_id AS price_id_68, c0_.society_id AS society_id_69, c0_.commercial_id AS commercial_id_70, c0_.delivery_cost_id AS delivery_cost_id_71 FROM customer_order c0_ INNER JOIN customer_order_lines c1_ ON c0_.id = c1_.customer_order_id INNER JOIN product p2_ ON c1_.product_id = p2_.id WHERE p2_.id = ? AND c0_.created_at >= ?
Parameters:
[ 2000 "2025-02-13 05:27:08" ] |
|
671.00 ms (38.83%) |
1 |
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25 FROM product p0_ INNER JOIN customer_order_lines c1_ ON (c1_.product_id = p0_.id) INNER JOIN customer_order c2_ ON c1_.customer_order_id = c2_.id WHERE c2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.id <> ? AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 GROUP BY p0_.id, p0_.reference, p0_.manufacturer, p0_.short_label, p0_.long_label, p0_.weight, p0_.sold_by, p0_.ppht, p0_.ppttc, p0_.paht, p0_.pattc, p0_.legal_discount_library, p0_.fidelity_bonus, p0_.brand, p0_.time_limit, p0_.coef, p0_.is_discountable, p0_.is_btob, p0_.is_btoc, p0_.is_customizable, p0_.is_library, p0_.is_nathan, p0_.is_green, p0_.is_orapi_grand_frais, p0_.is_active, p0_.slug ORDER BY COUNT(p0_.id) DESC LIMIT 10
Parameters:
[ 6343227 6345610 6345822 6348054 6348170 6348432 6349280 6349524 6350338 6351855 6351241 6353381 6358495 6359834 6351707 6360574 6362968 6363990 6364455 6364491 6365213 6366242 6366320 6369281 6370217 6370777 6370789 6372084 6372153 6372355 6372775 6375735 6376469 6377625 6378614 6378968 6381397 6383002 6383995 6385604 6384258 6387242 6388968 6389025 6390456 6389070 6387330 6391227 6391257 6391432 6391683 6391865 6392099 6392862 6393773 6393982 6394411 6395876 6396651 6398036 6398167 6399287 6399885 6400695 6401001 6404703 6405630 6405948 6405988 6406012 6406289 6406565 6406603 6406832 6408843 6408908 6410036 6410379 6410702 6410993 6411784 6412049 6412065 6412635 6412710 6412907 6412973 6413024 6413735 6414258 6414260 6414303 6414974 6415154 6415384 6415639 6415967 6416110 6416184 6416216 6416832 6416840 6416860 6416955 6416974 6417091 6417139 6417373 6418171 6418844 6418942 6419184 6419243 6419293 6419344 6419404 6419559 6419585 6420267 6420594 6420705 6420736 6421373 6422230 6422312 6422380 6422536 6422591 6422618 6422798 6422848 6422928 6423188 6423684 6424050 6424147 6424306 6424661 6424714 6424788 6424790 6424893 6424902 6424909 6424967 6425068 6425305 6425694 6426112 6426195 6426199 6426745 6426824 6426960 6426962 6426982 6427012 6427614 6427649 6427693 6427826 6428183 6428581 6429259 6429343 6429583 6429646 6429797 6429856 6430112 6430491 6430860 6430882 6431541 6431579 6431688 6431856 6431864 6432152 6432213 6432345 6434371 6434449 6434891 6435179 6435181 6435202 6435208 6435351 6435362 6435404 6435936 6436064 6437222 6437815 6437825 6438011 6438089 6438103 6439128 6439566 6439623 6440211 6440289 6440544 6441486 6442806 6443018 6443241 6443277 6443487 6443886 6444084 6444180 6444333 6444335 6444345 6444747 6444967 6444986 6445055 6445318 6445327 6445413 6445630 6445640 6445846 6446051 6446128 6446793 6446935 6446959 6447279 6447321 6447340 6447477 6449398 6449500 6449673 6449842 6449843 6449879 6449891 6450113 6450174 6450186 6450195 6450222 6450253 6450281 6450441 6450635 6450831 6450832 6450833 6450993 6451011 6451023 6451088 6451100 6451129 6451214 6451221 6451233 6451236 6451240 6451252 6451338 6451383 6451388 6451394 6451398 6451421 6451439 6451512 6451545 6451616 6451619 6451707 6451771 6451773 6451792 6452019 6452026 6452039 6452179 6452241 6452425 6452965 6453206 6453556 6453560 6454207 6454450 6454451 6454463 6454542 6454560 6454582 6454622 6454682 6454788 6454855 6454861 6454926 6454935 6455130 6455142 6455220 6455267 6455317 6455318 6455320 6455390 6455487 6455489 6455520 6455544 6455586 6455617 6455621 6455625 6455660 6455827 6456070 6456072 6456256 6456523 6456561 6457209 6457720 6457825 6458255 6458359 6458461 6458497 6459180 6459423 6459468 6459522 6460156 6460277 6460315 6460411 6460542 6460944 6461154 6461305 6461315 6461527 6461649 6461655 6461670 6461848 6462336 6462654 6463016 6463077 6463643 6464266 6464770 6465378 6465610 6466886 6468752 6468895 1000002090 1000002584 1000002591 1000002614 1000002639 1000002707 1000002731 1000002848 6376751 1000002280 1000001847 1000004736 1000005547 1000005972 6389079 1000006484 1000006566 1000002476 1000006200 1000005695 1000005937 1000007849 1000007030 1000004320 1000008582 1000008848 1000007296 1000006984 1000002230 1000006610 1000009420 1000009540 1000009689 1000009858 1000010371 1000010509 1000010214 1000010181 1000010486 1000009134 1000010400 1000010917 1000011839 1000004058 1000012323 1000009837 1000012676 1000013004 1000013074 1000012806 1000011083 1000012348 1000013135 1000012432 1000012104 1000011994 1000011911 1000007983 1000008505 1000009125 1000005361 1000005460 1000013798 1000013589 1000014481 1000014681 1000014882 1000014102 1000010588 1000014971 1000012592 1000012248 1000012236 1000015218 1000005550 1000015277 1000001135 1000013264 1000015476 1000009264 1000016031 1000015797 1000016203 1000016283 1000016437 1000016507 1000012465 1000017148 1000017173 1000016514 1000018370 1000018452 1000018473 1000016084 1000018835 1000018882 1000018883 1000019109 1000019110 1000019164 1000019168 1000016914 1000019300 1000019326 1000019332 1000012578 1000019467 1000019937 1000020028 1000020041 1000020043 1000020051 1000020056 1000020060 1000020063 1000020065 1000020066 1000020071 1000020074 1000020076 1000020078 1000020088 1000020092 1000020094 1000020101 1000020280 1000020372 1000018529 1000020410 1000019410 1000020471 6378747 1000012396 1000019469 1000016421 1000021090 1000016113 1000021209 1000021210 1000016529 1000021244 1000021247 1000021250 1000021262 1000021264 1000021347 1000021356 1000021357 1000021360 1000021366 1000021450 1000021452 1000021510 1000021565 1000021568 1000021571 1000021670 1000021674 1000021679 1000021682 1000021684 1000021687 1000021688 1000021690 1000021701 1000021702 1000021703 1000021711 1000021713 1000021715 1000021716 1000021728 1000021730 1000021731 1000021734 1000021736 1000021737 1000021786 1000021789 1000021793 1000021794 1000021795 1000021800 1000021801 1000021913 1000021914 1000021720 1000021169 1000019091 1000013935 1000022595 1000022602 1000014717 1000012677 1000016655 1000024511 1000024512 1000024624 1000024626 1000012892 1000025170 1000026011 1000026012 1000026013 1000026018 1000026020 1000026024 1000026054 1000026178 1000016926 1000026475 1000026485 1000026487 1000026488 1000026489 1000026491 1000026492 1000026493 1000026496 1000021921 1000026608 1000026659 1000009675 1000026685 1000017174 1000026895 1000026899 1000026695 1000027421 1000006827 1000028290 1000015090 1000028939 1000028941 1000020632 1000029559 1000029567 1000022906 1000024630 1000030138 1000014410 1000030447 1000030701 1000030752 1000030903 1000030911 1000019337 1000032052 1000032085 1000032237 1000032239 1000032248 1000032249 1000032250 1000032356 1000032399 1000032403 1000032410 1000032413 1000032420 1000032432 1000032437 1000033361 1000033363 1000033430 1000033432 1000033465 1000033471 1000029293 1000034207 1000034583 1000034724 1000034827 1000034828 1000034829 1000034984 1000034990 1000035000 1000035420 1000032297 1000035743 1000035007 1000030451 1000036191 1000036202 1000036207 1000036449 1000036467 1000036478 1000036480 1000036483 1000036507 1000036515 1000036518 1000036525 1000036526 1000036528 1000036533 1000036534 1000036535 1000036536 1000036538 1000036539 1000036541 1000036551 1000036484 1000035153 1000036703 1000037549 1000037551 1000037557 1000037778 1000038935 1000039124 1000039150 1000039179 1000039189 1000039210 1000039212 1000040182 1000040183 1000040184 1000040193 1000040195 1000040196 1000040199 1000040206 1000040283 1000040284 1000040309 1000040428 1000040795 1000040796 1000026310 1000014206 1000040928 1000040932 1000041002 1000041005 1000041026 1000041049 1000041065 1000041535 1000041562 1000041566 1000041567 1000041576 1000041577 1000041858 1000041859 1000041860 1000041861 1000041862 1000041863 1000041865 1000041866 1000041869 1000041876 1000041877 1000041878 1000041880 1000041881 1000041882 1000041883 1000041885 1000041894 1000041895 1000041896 1000041941 1000041945 1000042188 1000042189 1000042224 1000042233 1000042259 1000042263 1000042285 1000042286 1000042289 1000041721 1000042882 1000042896 1000043026 1000022679 1000043458 1000041523 1000040197 1000043875 1000043970 1000044192 1000044205 1000044215 1000044296 1000044308 1000044609 1000044767 1000044825 1000044839 1000044865 1000044876 1000044882 1000044884 1000043809 1000045341 1000045391 1000045396 1000045399 1000045614 1000045655 1000045665 1000045666 1000045668 1000045683 1000045684 1000045713 1000021815 1000046114 1000046115 1000046148 1000046194 1000046197 1000046201 1000046208 1000046219 1000046284 1000046378 1000046380 1000046381 1000046385 1000046449 1000046512 1000046258 1000047251 1000047264 1000047528 1000047660 1000047730 1000047736 1000047737 1000047746 1000047798 1000047738 1000047819 1000047169 1000047742 1000046419 1000026055 1000042922 1000047941 1000045054 1000048089 1000012406 1000048175 1000048187 1000048152 1000048242 1000048306 1000048383 1000048384 1000041387 1000048545 1000042944 1000048556 1000048558 1000048581 1000048710 1000048722 1000048727 1000048841 1000048856 1000048513 1000048970 1000041536 1000049105 1000049110 1000049217 1000049525 1000049739 1000049740 1000049755 1000049497 1000049979 1000050033 1000050039 1000027416 1000050087 1000050130 1000050183 1000050223 1000050311 1000050313 1000050314 1000050315 1000050317 1000050683 1000050392 1000050898 1000050997 1000048088 1000051160 1000044898 1000051322 1000051335 1000050685 1000051840 1000051983 1000051994 1000052093 1000051861 1000052248 1000051461 1000028942 1000043879 1000051886 1000052774 1000052792 1000052796 1000052044 1000052838 1000049484 1000052966 1000052913 1000053210 1000051365 1000053146 1000052756 1000050346 1000017165 1000053180 2000 ] |
|
100.61 ms (5.82%) |
1 |
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25, p1_.id AS id_26, p1_.price_ht AS price_ht_27, p1_.price_ttc AS price_ttc_28, p2_.id AS id_29, c3_.id AS id_30, c3_.name AS name_31, c3_.displayed_order AS displayed_order_32, c3_.is_in_footer AS is_in_footer_33, c3_.slug AS slug_34, p4_.id AS id_35, p4_.price_ht AS price_ht_36, p4_.price_ttc AS price_ttc_37, p4_.discount AS discount_38, p5_.id AS id_39, p5_.min AS min_40, p5_.max AS max_41, p5_.codelot AS codelot_42, c6_.id AS id_43, c6_.name AS name_44, c6_.name_display AS name_display_45, c6_.is_visible_btob AS is_visible_btob_46, c6_.is_referencement AS is_referencement_47, p1_.price_id AS price_id_48, p1_.product_id AS product_id_49, c3_.category_parent_id AS category_parent_id_50, p4_.product_id AS product_id_51, p5_.customer_catalog_id AS customer_catalog_id_52, p5_.product_id AS product_id_53 FROM product p0_ LEFT JOIN product_price p1_ ON p0_.id = p1_.product_id LEFT JOIN price p2_ ON p1_.price_id = p2_.id LEFT JOIN product_category p7_ ON p0_.id = p7_.product_id LEFT JOIN category c3_ ON c3_.id = p7_.category_id LEFT JOIN promotion p4_ ON p0_.id = p4_.product_id LEFT JOIN product_catalog p5_ ON p0_.id = p5_.product_id LEFT JOIN customer_catalog c6_ ON p5_.customer_catalog_id = c6_.id WHERE p0_.slug = ? AND p0_.is_active = 1
Parameters:
[
"15010-marqueurs-effacables-bleu-bic-328106"
]
|
|
6.19 ms (0.36%) |
4 |
SELECT d0_.quantity AS quantity_0, d0_.price_ht AS price_ht_1, d0_.price_ttc AS price_ttc_2 FROM decreasing_price d0_ WHERE d0_.product_id = ? AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC
Parameters:
[
2000
]
|
|
5.05 ms (0.29%) |
4 |
SELECT d0_.id AS id_0, d0_.quantity AS quantity_1, d0_.price_ht AS price_ht_2, d0_.price_ttc AS price_ttc_3, d0_.product_id AS product_id_4, d0_.product_price_id AS product_price_id_5, d0_.promotion_id AS promotion_id_6, d0_.market_id AS market_id_7 FROM decreasing_price d0_ WHERE d0_.product_id = ? AND d0_.quantity <= ? AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC LIMIT 1
Parameters:
[ 2000 0 ] |
|
4.76 ms (0.28%) |
14 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value1 AS value1_3, t0.value2 AS value2_4, t0.value3 AS value3_5 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"ourClientsAlsoBoughtMonths"
]
|
|
3.58 ms (0.21%) |
18 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
1
]
|
|
3.03 ms (0.18%) |
8 |
SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.price_id = ? AND t0.product_id = ? LIMIT 1
Parameters:
[ "CAISSE2011" 2000 ] |
|
2.04 ms (0.12%) |
8 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.affiliated_society AS affiliated_society_3, t0.address1 AS address1_4, t0.address2 AS address2_5, t0.address3 AS address3_6, t0.zip_code AS zip_code_7, t0.city AS city_8, t0.email AS email_9, t0.phone_number AS phone_number_10, t0.fax AS fax_11, t0.id_deposit AS id_deposit_12, t0.gen_code AS gen_code_13, t0.newspaper AS newspaper_14, t0.siren AS siren_15, t0.ape AS ape_16, t0.trading_registry AS trading_registry_17, t0.internal_tva AS internal_tva_18, t0.rib AS rib_19, t0.general_account AS general_account_20, t0.capital AS capital_21 FROM society t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"MOZ"
]
|
|
1.97 ms (0.11%) |
1 |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.manufacturer AS manufacturer_3, t0.short_label AS short_label_4, t0.long_label AS long_label_5, t0.weight AS weight_6, t0.sold_by AS sold_by_7, t0.ppht AS ppht_8, t0.ppttc AS ppttc_9, t0.paht AS paht_10, t0.pattc AS pattc_11, t0.legal_discount_library AS legal_discount_library_12, t0.fidelity_bonus AS fidelity_bonus_13, t0.brand AS brand_14, t0.time_limit AS time_limit_15, t0.coef AS coef_16, t0.is_discountable AS is_discountable_17, t0.is_btob AS is_btob_18, t0.is_btoc AS is_btoc_19, t0.is_customizable AS is_customizable_20, t0.is_library AS is_library_21, t0.is_nathan AS is_nathan_22, t0.is_green AS is_green_23, t0.is_orapi_grand_frais AS is_orapi_grand_frais_24, t0.is_active AS is_active_25, t0.slug AS slug_26 FROM product t0 WHERE t0.reference IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "01270" "01271" "01272" "01273" "01280" "01281" "01282" "01283" "15029" "15030" "15031" "15021" "15022" "15023" "15024" "15004" "15011" "15012" "15013" "15019" "15020" "15021" "15022" "15023" "15024" "15029" "15030" "15031" ] |
|
1.66 ms (0.10%) |
9 |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
|
1.56 ms (0.09%) |
4 |
SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.product_id = ? AND t0.price_id = ? LIMIT 1
Parameters:
[ 2000 "C" ] |
|
1.49 ms (0.09%) |
4 |
SELECT d0_.quantity AS quantity_0, MIN(d0_.price_ht) AS sclr_1, MIN(d0_.price_ttc) AS sclr_2 FROM decreasing_price d0_ LEFT JOIN product p1_ ON d0_.product_id = p1_.id LEFT JOIN product_price p2_ ON d0_.product_price_id = p2_.id WHERE p1_.id = ? AND p2_.id = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC
Parameters:
[ 2000 9957411 ] |
|
1.33 ms (0.08%) |
4 |
SELECT p0_.id AS id_0, p0_.label_reduction AS label_reduction_1, p0_.description_reduction AS description_reduction_2, p0_.product_id AS product_id_3, p0_.operation_id AS operation_id_4 FROM product_reduction_label p0_ INNER JOIN operation o1_ ON p0_.operation_id = o1_.id WHERE o1_.is_active = 1 AND o1_.end_date >= ? AND o1_.is_active = 1 AND o1_.view_by LIKE ? AND p0_.product_id = ?
Parameters:
[ "2025-07-13 05:27:10" "%2%" 2000 ] |
|
0.67 ms (0.04%) |
3 |
SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.discount AS discount_4, t0.product_id AS product_id_5 FROM promotion t0 WHERE t0.product_id = ?
Parameters:
[
2001
]
|
|
0.61 ms (0.04%) |
1 |
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25 FROM product p0_ LEFT JOIN product_category p2_ ON p0_.id = p2_.product_id LEFT JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id IN (?, ?, ?, ?, ?, ?) AND p0_.is_active = 1 AND p0_.id <> ? AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 LIMIT 10
Parameters:
[ 58 275 276 277 278 275 2000 ] |
|
0.48 ms (0.03%) |
1 |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.manufacturer AS manufacturer_3, t0.short_label AS short_label_4, t0.long_label AS long_label_5, t0.weight AS weight_6, t0.sold_by AS sold_by_7, t0.ppht AS ppht_8, t0.ppttc AS ppttc_9, t0.paht AS paht_10, t0.pattc AS pattc_11, t0.legal_discount_library AS legal_discount_library_12, t0.fidelity_bonus AS fidelity_bonus_13, t0.brand AS brand_14, t0.time_limit AS time_limit_15, t0.coef AS coef_16, t0.is_discountable AS is_discountable_17, t0.is_btob AS is_btob_18, t0.is_btoc AS is_btoc_19, t0.is_customizable AS is_customizable_20, t0.is_library AS is_library_21, t0.is_nathan AS is_nathan_22, t0.is_green AS is_green_23, t0.is_orapi_grand_frais AS is_orapi_grand_frais_24, t0.is_active AS is_active_25, t0.slug AS slug_26 FROM product t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"15010-marqueurs-effacables-bleu-bic-328106"
]
|
|
0.44 ms (0.03%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
|
0.41 ms (0.02%) |
1 |
SELECT c0_.id AS id_0, c0_.value AS value_1, c1_.id AS id_2, c1_.list_order AS list_order_3, c1_.is_display_site AS is_display_site_4, c1_.is_search_site AS is_search_site_5, c1_.label AS label_6, c0_.product_id AS product_id_7, c0_.characteristic_label_id AS characteristic_label_id_8 FROM characteristic c0_ INNER JOIN characteristic_label c1_ ON c0_.characteristic_label_id = c1_.id WHERE c0_.product_id = ? AND c1_.is_display_site = ?
Parameters:
[ 2000 1 ] |
|
0.40 ms (0.02%) |
1 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_id AS product_id_3, t0.characteristic_label_id AS characteristic_label_id_4 FROM characteristic t0 WHERE t0.product_id = ?
Parameters:
[
2000
]
|
|
0.36 ms (0.02%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.displayed_order AS displayed_order_2, c0_.is_in_footer AS is_in_footer_3, c0_.slug AS slug_4, c1_.id AS id_5, c1_.name AS name_6, c1_.displayed_order AS displayed_order_7, c1_.is_in_footer AS is_in_footer_8, c1_.slug AS slug_9, c2_.id AS id_10, c2_.name AS name_11, c2_.displayed_order AS displayed_order_12, c2_.is_in_footer AS is_in_footer_13, c2_.slug AS slug_14, c0_.category_parent_id AS category_parent_id_15, c1_.category_parent_id AS category_parent_id_16, c2_.category_parent_id AS category_parent_id_17 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.category_parent_id LEFT JOIN category c2_ ON c1_.id = c2_.category_parent_id WHERE c0_.slug = ?
Parameters:
[
"15010-marqueurs-effacables-bleu-bic-328106"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.