Query Metrics
48
Database Queries
22
Different statements
999.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
478.84 ms (47.93%) |
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:
[ 759 "2025-02-12 08:16:52" ] |
|
460.48 ms (46.09%) |
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:
[ 6335678 6322917 6338699 6339119 6339596 6339686 6340707 6333903 6343676 6332620 6346321 6346762 6349391 6349398 6349772 6350187 6354424 6354788 6355091 6369151 6370673 6371637 6373707 6379950 6382693 6384359 6384666 6385216 6385439 6385695 6383123 6387343 6387365 6387715 6388366 6387733 6388513 6389020 6389130 6388386 6387517 6389409 6390215 6390558 6390568 6391101 6392090 6392092 6387952 6392260 6392349 6392094 6392745 6393401 6393413 6393915 6394343 6394360 6394448 6396243 6398622 6399546 6400270 6400446 6400735 6401513 6401802 6401872 6402683 6403608 6404864 6404878 6404879 6404927 6405128 6405401 6406917 6407572 6407783 6410080 6410127 6410667 6411870 6411921 6411934 6412259 6412385 6412796 6412823 6413485 6413639 6413784 6413878 6414297 6414553 6414940 6415662 6416006 6416013 6416037 6416119 6416300 6416390 6416397 6416406 6416725 6416758 6416778 6416829 6416941 6416942 6416949 6417316 6417552 6418008 6418172 6418191 6418251 6418819 6418851 6418878 6419146 6419159 6419273 6419296 6419414 6419444 6419518 6419533 6420398 6420668 6420880 6421673 6421692 6421749 6422309 6422489 6422661 6423676 6423701 6424005 6424128 6424173 6425044 6425118 6426483 6427989 6428428 6428649 6429708 6429844 6430564 6431148 6431239 6431732 6431775 6432241 6432288 6433944 6434518 6434603 6434694 6434910 6434933 6435081 6435567 6435644 6436012 6437098 6437791 6438075 6438823 6439092 6439656 6439669 6439692 6439736 6441257 6441553 6441915 6441947 6442129 6442254 6442296 6442786 6443464 6443547 6444322 6444324 6444401 6444653 6444768 6444853 6444861 6445234 6446274 6446667 6446861 6447233 6447268 6447363 6447457 6447561 6447755 6448208 6449322 6449642 6449867 6450173 6450182 6450186 6450296 6450500 6450556 6450565 6450583 6450764 6450765 6450791 6450986 6451172 6451176 6451184 6451188 6451192 6451214 6451240 6451274 6451275 6451288 6451315 6451413 6451434 6451563 6451826 6452034 6452214 6452409 6452433 6452722 6453713 6454094 6454561 6454621 6454622 6454626 6454657 6454661 6454714 6454778 6454782 6454901 6454989 6455000 6455234 6455345 6455557 6455571 6455646 6455683 6456789 6456952 6457009 6457046 6457205 6457290 6457535 6457647 6458411 6458433 6458570 6458990 6459081 6459267 6459425 6459607 6459614 6459930 6459992 6460293 6460399 6460411 6460946 6461010 6461298 6462586 6462804 6463018 6463021 6463716 6463731 6463782 6463861 6464099 6464266 6464321 6466602 6467760 6388022 1000000994 6394262 1000002039 1000002173 6394198 1000002675 1000002677 1000002185 1000000937 1000004818 1000005037 6390109 1000005369 1000005962 1000006990 1000007903 1000002180 1000007904 1000008150 1000008277 1000005034 1000009128 1000006952 1000004822 1000008852 1000006153 1000009572 1000009609 1000009762 1000005988 1000010566 1000009449 1000010970 1000011049 1000007860 1000009863 6391043 1000012434 1000008219 1000010597 1000012141 1000010987 1000007042 1000013898 1000008349 1000001633 1000014694 1000002657 1000012704 1000010731 1000015675 1000014922 1000012371 1000016676 1000016678 1000016680 1000016860 1000016947 1000017492 1000018171 1000018354 1000015137 1000018677 1000019026 1000019588 1000020221 1000017137 1000020546 1000018133 1000018350 1000014752 1000021633 1000021751 1000021773 1000019604 1000002241 1000010727 1000022827 1000023161 1000024463 1000024465 1000024469 1000024473 1000024479 1000024480 1000024496 1000016439 1000025026 1000025060 1000025276 1000025310 1000025373 1000014211 1000025575 1000025585 1000025681 1000025702 1000025921 1000025925 1000025927 1000025954 1000025964 1000025989 1000026011 1000026012 1000026013 1000026018 1000026020 1000026024 1000026054 1000026330 1000026357 1000026463 1000012507 1000026589 1000026626 1000026628 1000010233 1000026961 1000027350 1000027353 1000027354 1000027356 1000027357 1000023910 1000027438 1000027512 1000027515 1000027516 1000027517 1000027518 1000027519 1000027521 1000027524 1000014767 1000029248 1000029249 1000029253 1000029258 1000030065 1000030069 1000031369 1000031789 1000031801 1000031844 1000031845 1000031848 1000031852 1000031879 1000031884 1000017146 1000016992 1000032070 1000032073 1000032288 1000032290 1000032291 1000032292 1000032293 1000032295 1000032299 1000032484 1000032575 1000032580 1000032614 1000032617 1000032618 1000032619 1000032620 1000032621 1000032628 1000032629 1000032630 1000032631 1000032632 1000025999 1000031805 1000020299 1000032635 1000033619 1000033623 1000033624 1000033632 1000033633 1000009305 1000034146 1000034154 1000034178 1000034188 1000034189 1000034364 1000012304 1000012842 1000017505 1000034689 1000034771 1000034772 1000034773 1000034782 1000034993 1000035001 1000035004 1000035216 1000012637 1000035728 1000032212 1000009485 1000036271 1000036273 1000005828 1000036450 1000036472 1000036475 1000037111 1000037112 1000037113 1000037114 1000037115 1000037122 1000037123 1000037124 1000037125 1000037126 1000037138 1000037167 1000037186 1000037214 1000037215 1000037229 1000037239 1000037240 1000037241 1000037242 1000037266 1000037277 1000031889 1000038393 1000038405 1000038410 1000038427 1000038429 1000038438 1000038528 1000038530 1000038548 1000039081 1000039082 1000039661 1000039667 1000039668 1000039669 1000039671 1000039672 1000039673 1000039678 1000039679 1000039680 1000039682 1000039683 1000039684 1000039685 1000039777 1000040037 1000009770 1000041465 1000041775 1000041776 1000041788 1000041820 1000041822 1000041824 1000042040 1000042046 1000042052 1000042053 1000042054 1000042059 1000042060 1000042063 1000042064 1000042068 1000042074 1000042087 1000042282 1000042298 1000041531 1000044242 1000025621 1000045083 1000030128 1000045422 1000045423 1000045425 1000045426 1000045507 1000045852 1000045853 1000046048 1000046049 1000046092 1000046341 1000046356 1000046357 1000046359 1000041412 1000046660 1000046674 1000046756 1000046759 1000042048 1000042261 1000046863 1000046864 1000042384 1000047226 1000047227 1000047228 1000047231 1000047233 1000047235 1000047236 1000047249 1000047261 1000047263 1000047367 1000047372 1000047432 1000047433 1000047437 1000047447 1000047456 1000047457 1000047461 1000047462 1000047463 1000047464 1000047465 1000047467 1000047469 1000047470 1000047472 1000047483 1000047485 1000047491 1000047493 1000047495 1000014647 1000047516 1000047517 1000047518 1000025431 1000039083 1000026055 1000044019 1000047998 1000048001 1000016279 1000048187 1000047526 1000048304 1000048315 1000048316 1000048305 1000048327 1000048353 1000048775 1000048508 1000047027 1000048876 1000048981 1000048982 1000048986 1000040038 1000048827 1000038556 1000048162 1000049348 1000049591 1000050288 1000050336 1000050349 1000049151 1000050732 1000050191 1000049293 1000048839 1000051067 1000051568 1000050609 1000051302 1000045884 1000051688 1000051691 1000051711 1000051715 1000038011 1000051790 1000051820 1000051844 1000048886 1000051065 1000050064 1000052146 1000052149 1000051025 1000050350 1000049479 1000041510 1000051677 1000052621 1000052728 1000052729 1000052741 1000052820 1000052022 1000053000 1000052971 1000052818 1000053150 1000053220 1000053223 1000050181 1000053328 6379979 1000053452 1000052810 1000017165 759 ] |
|
46.83 ms (4.69%) |
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:
[
"10643-cahiers-speciaux-couleur-clairefontaine-108503-violet"
]
|
|
2.97 ms (0.30%) |
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
]
|
|
2.02 ms (0.20%) |
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:
[ 759 1 ] |
|
1.03 ms (0.10%) |
5 |
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"
]
|
|
0.92 ms (0.09%) |
2 |
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" 760 ] |
|
0.73 ms (0.07%) |
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:
[ 41 189 190 191 192 193 194 195 192 759 ] |
|
0.72 ms (0.07%) |
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 = ? AND t0.characteristic_label_id = ? LIMIT 1
Parameters:
[ 760 7 ] |
|
0.59 ms (0.06%) |
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:
[
"10643-cahiers-speciaux-couleur-clairefontaine-108503-violet"
]
|
|
0.45 ms (0.04%) |
3 |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
|
0.43 ms (0.04%) |
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.43 ms (0.04%) |
2 |
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"
]
|
|
0.36 ms (0.04%) |
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:
[
"10643-cahiers-speciaux-couleur-clairefontaine-108503-violet"
]
|
|
0.35 ms (0.03%) |
2 |
SELECT t0.id AS id_1, t0.promotion_id AS promotion_id_2, t0.society_id AS society_id_3 FROM society_promotion t0 WHERE t0.promotion_id = ?
Parameters:
[
197657
]
|
|
0.31 ms (0.03%) |
1 |
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:
[ 760 0 ] |
|
0.30 ms (0.03%) |
1 |
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 = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC
Parameters:
[
760
]
|
|
0.28 ms (0.03%) |
1 |
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:
[
760
]
|
|
0.27 ms (0.03%) |
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:
[
759
]
|
|
0.26 ms (0.03%) |
1 |
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-12 08:16:53" "%2%" 760 ] |
|
0.26 ms (0.03%) |
1 |
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:
[ 760 "C" ] |
|
0.19 ms (0.02%) |
1 |
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:
[
760
]
|
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.