Query Metrics
67
Database Queries
22
Different statements
1774.10 ms
Query time
0
Invalid entities
1714
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1528.75 ms (86.17%) |
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:
[ 59250 "2025-04-12 12:04:32" ] |
|
190.05 ms (10.71%) |
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:
[ 6384705 6384910 6384988 6383688 6385230 6385624 6385640 6385796 6386011 6386070 6386388 6387260 6387440 6387484 6387559 6387751 6388343 6388417 6388464 6388646 6388688 6388698 6388746 6388799 6388867 6388878 6385811 6389533 6389976 6390343 6389985 6390533 6390825 6391053 6391253 6391255 6391402 6391435 6391461 6391472 6391498 6387341 6391678 6391807 6391810 6391818 6391851 6392703 6393133 6393172 6393203 6393255 6393419 6393425 6393427 6393475 6393552 6393704 6393891 6393952 6393968 6394071 6394315 6394326 6394329 6394356 6394675 6395030 6396089 6396823 6397118 6397501 6397600 6397706 6397769 6397771 6397776 6397777 6397779 6397783 6397785 6397786 6397789 6397791 6397797 6397799 6397800 6397801 6397804 6397805 6397806 6397809 6397811 6397829 6398209 6398273 6398793 6398816 6399111 6399129 6399194 6399406 6399613 6399837 6399895 6400223 6400415 6401662 6401718 6401987 6402010 6402184 6403151 6403383 6403713 6403726 6403732 6403842 6403874 6404138 6404411 6404447 6404473 6404823 6404827 6404989 6405449 6405480 6406219 6406537 6406915 6407107 6407119 6407433 6407438 6407521 6407701 6407723 6407844 6407846 6408405 6409100 6409112 6409142 6409159 6409168 6409460 6409699 6410760 6410767 6410917 6411258 6411428 6411746 6412268 6412379 6412872 6413312 6413510 6413730 6414585 6415641 6415655 6415816 6415953 6417172 6417341 6417930 6418115 6418364 6418501 6418559 6418561 6418562 6418565 6418566 6418567 6418569 6418570 6418571 6418574 6418577 6418582 6418583 6418584 6418585 6418586 6418591 6418592 6418594 6418597 6418599 6418600 6418601 6418603 6418605 6418606 6418609 6418612 6418700 6418756 6419228 6419437 6419440 6419452 6419804 6419809 6419853 6419902 6419932 6420038 6420369 6420724 6421197 6421240 6422541 6424293 6425253 6425892 6426122 6427969 6428040 6428138 6428707 6429162 6429530 6429667 6429691 6430091 6430492 6430649 6430975 6431136 6431232 6431622 6433410 6434327 6434644 6434698 6434937 6435614 6436279 6438062 6438830 6438917 6438963 6439075 6440974 6441048 6441104 6441699 6441869 6442178 6442184 6442772 6442812 6442853 6443290 6443932 6444081 6444152 6446422 6448861 6448929 6448947 6449653 6451402 6451831 6452098 6452627 6452628 6453378 6453855 6454219 6454221 6454224 6454225 6454226 6454227 6454228 6454230 6454233 6454234 6454235 6454236 6454237 6454238 6454248 6454251 6454255 6454257 6454258 6454259 6454261 6454263 6454264 6454268 6454271 6454273 6454274 6454302 6454347 6454736 6454916 6454952 6455110 6455541 6455942 6456429 6456518 6456633 6456650 6456726 6456743 6457177 6458180 6459233 6459449 6459635 6459665 6460132 6460481 6461257 6461922 6462616 6463758 6464036 6464852 6465622 6465660 6467831 6468119 6468145 6469213 6469406 6469960 6470276 6471139 6473088 6474765 6475490 6475534 6475571 6476253 6476606 6476638 6476659 6477762 6477896 6478387 6481666 6482386 6482888 6483464 6483998 6484004 6484469 6485298 6485459 6485790 6485926 6485976 6486339 6486780 6486814 6486860 6488300 6488575 6488576 6488577 6488578 6488993 6488995 6490448 6490779 6490988 6491060 6492414 6493097 6493208 6494873 6495469 6496665 6496730 6498872 6500087 6500341 6500781 6500884 6501094 6501097 6501098 6501103 6501105 6501106 6501107 6501108 6501112 6501114 6501118 6501120 6501121 6501123 6501124 6501125 6501126 6501129 6501134 6501135 6501137 6501139 6501141 6501145 6501146 6501148 6501153 6501155 6501157 6501158 6501164 6501192 6501219 6501220 6501262 6501779 6502724 6502866 6503101 6503206 6503254 6503276 6503312 6503320 6503398 6503407 6503429 6503548 6503619 6503921 6503990 6504056 6504760 6504817 6505926 6506768 6506882 6507015 6507525 6508605 6508668 6508876 6509180 6509365 6509384 6510280 6510305 6512073 6512308 6512461 6512995 6513049 6517038 6517512 6518393 6519996 6521266 6521916 6523923 6527044 6527684 6527731 6527807 6527809 6527811 6527812 6527819 6527820 6527821 6527822 6527824 6527825 6527833 6527836 6527837 6527843 6527864 6527881 6527919 6530438 6530875 6530970 6531169 6531176 6533779 6534651 6534664 6534999 6535460 6535569 6535708 6536188 6537219 6537235 6537592 6537609 6537757 6537979 6538135 6539468 6539469 6539537 6539799 6539835 6540468 6540657 6541256 6541338 6541755 6542058 1000001207 1000001801 1000002349 1000002466 1000002504 1000002893 1000003039 1000003548 1000003762 1000003943 1000004218 1000004261 1000004454 1000004456 1000004476 1000004483 1000004740 1000004767 1000004880 1000004852 1000005092 1000005189 1000005202 1000005389 1000004857 1000005480 1000005496 1000005499 1000005571 1000005572 1000005914 1000006309 1000006494 1000006999 1000007069 1000007116 1000007120 1000007125 1000007563 1000008174 1000008213 1000008214 1000008286 1000008481 1000008716 1000009056 1000009390 1000009453 1000009494 1000010032 1000010033 1000010034 1000003420 1000010089 1000010632 1000011845 1000011963 1000012161 1000012589 1000013042 1000013189 1000013692 1000013954 1000013957 1000015988 1000009099 1000013751 1000018790 1000019162 1000020456 1000020614 1000020638 1000020714 1000020750 1000020769 1000020989 1000021129 1000021141 1000021533 1000022052 1000022130 1000022241 1000015083 1000024447 1000027877 1000027878 1000027879 1000027880 1000027898 1000015633 1000029208 1000029209 1000029232 1000029241 1000030123 1000030124 1000031728 1000031792 1000031853 1000034012 1000034015 1000034832 1000034834 1000034970 1000034971 1000034972 1000035744 1000035794 1000036702 1000040245 1000040298 1000040391 1000040479 1000040480 1000040517 1000041035 1000041036 1000041037 1000041044 1000041101 1000041107 1000005186 1000041984 1000042108 1000043081 1000043550 1000043556 1000043558 1000043561 1000043570 1000043571 1000043572 1000043738 1000043739 1000043740 1000044431 1000044461 1000046930 1000046931 1000048429 1000048460 1000048467 1000048470 1000048472 1000046853 1000048750 1000049206 1000049327 1000049350 1000044910 1000049742 1000049825 1000050101 1000050139 1000050441 1000050633 1000050836 1000051658 1000050141 1000052166 1000052963 1000052969 1000053042 1000053174 1000053176 1000053178 1000053540 1000054379 1000054413 1000054563 1000054564 1000054565 1000054566 1000055010 1000055440 1000055470 1000055509 1000054243 1000055664 1000055948 1000056030 1000056033 1000026925 1000056101 1000056305 1000056469 1000054929 1000055967 1000056881 1000056971 1000056942 1000057113 1000057114 1000057159 1000057195 1000057196 1000057197 1000057259 1000057419 1000057435 1000057498 1000057500 1000057501 1000057546 1000057753 1000057946 1000057958 1000058033 1000058042 1000058035 1000058539 1000058636 1000058635 1000058801 1000058874 1000058976 1000059032 1000057791 1000059617 1000059786 1000059876 1000059996 1000059997 1000060116 1000060150 1000060164 1000060252 1000060257 1000060258 1000060308 1000060391 1000060408 1000060538 1000060604 1000060610 1000060656 1000060658 1000060785 1000060879 1000058688 1000059907 1000061521 1000062163 1000062141 1000062421 1000062423 1000063060 1000063530 1000063531 1000063532 1000063533 1000063603 1000063751 1000063782 1000063784 1000063848 1000062704 1000063850 1000064125 1000064176 1000064178 1000064180 1000064183 1000064216 1000064329 1000064466 1000064500 1000064514 1000064807 1000064833 1000064908 1000064912 1000064913 1000064914 1000064915 1000064916 1000064917 1000064918 1000064930 1000064931 1000065038 1000065075 1000065395 1000065598 1000065778 1000065811 1000065831 1000065894 1000066029 1000066341 59250 ] |
|
40.50 ms (2.28%) |
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:
[
"55624-produits-d'hygiene-couleur-tork-12217"
]
|
|
3.89 ms (0.22%) |
21 |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
59250
]
|
|
2.93 ms (0.17%) |
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
]
|
|
1.20 ms (0.07%) |
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.72 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:
[ 66 314 315 316 317 317 59250 ] |
|
0.65 ms (0.04%) |
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" 59425 ] |
|
0.63 ms (0.04%) |
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:
[ 59425 7 ] |
|
0.61 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, t27.id AS id_28, t27.min_qty AS min_qty_29, t27.max_qty AS max_qty_30, t27.step_qty AS step_qty_31, t27.product_id AS product_id_32 FROM product t0 LEFT JOIN product_rule t27 ON t27.product_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
"55624-produits-d'hygiene-couleur-tork-12217"
]
|
|
0.45 ms (0.03%) |
3 |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
|
0.45 ms (0.03%) |
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.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:
[ 59250 1 ] |
|
0.39 ms (0.02%) |
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 = ? AND p2_.id = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC
Parameters:
[ 59425 9961945 ] |
|
0.38 ms (0.02%) |
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.37 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:
[
"55624-produits-d'hygiene-couleur-tork-12217"
]
|
|
0.34 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.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:
[ 59425 "C" ] |
|
0.33 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:
[
59250
]
|
|
0.32 ms (0.02%) |
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:
[ 59425 0 ] |
|
0.26 ms (0.01%) |
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:
[
59425
]
|
|
0.26 ms (0.01%) |
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-09-12 12:04:34" "%2%" 59425 ] |
|
0.19 ms (0.01%) |
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:
[
59425
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Order\CustomerOrder | 809 |
| App\Entity\Delivery\Delivery | 184 |
| App\Entity\Customer\Customer | 179 |
| App\Entity\User\User | 171 |
| App\Entity\Catalog\ProductCatalog | 80 |
| App\Entity\Catalog\CustomerCatalog | 80 |
| App\Entity\Product\ProductPrice | 37 |
| App\Entity\Pricing\Price | 35 |
| App\Entity\Product\Market | 31 |
| App\Entity\Internal\Commercial | 27 |
| App\Entity\Product\Product | 21 |
| App\Entity\Product\Category | 21 |
| App\Entity\Product\Characteristic | 14 |
| App\Entity\Product\CharacteristicLabel | 13 |
| App\Entity\Internal\Society | 5 |
| App\Entity\Internal\Parameter | 3 |
| App\Entity\Delivery\DeliveryCost | 3 |
| App\Infrastructure\Doctrine\Entity\ProductRule | 1 |