Query Metrics
83
Database Queries
23
Different statements
3381.92 ms
Query time
0
Invalid entities
2710
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2180.47 ms (64.47%) |
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:
[ 4597 "2025-04-12 22:02:41" ] |
|
815.01 ms (24.10%) |
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:
[ 6376602 6383896 6384206 6384214 6360863 6384479 6384737 6385052 6385132 6385329 6386700 6387296 6387491 6387690 6385649 6388185 6388318 6388475 6389161 6389217 6389228 6389826 6389928 6390987 6390647 6391289 6391344 6391597 6391584 6391904 6392258 6392369 6393058 6393482 6393532 6393635 6393874 6394148 6351818 6395108 6395265 6395288 6395300 6395513 6395594 6395647 6395729 6395922 6395971 6395994 6396129 6396427 6396449 6396473 6396560 6396631 6396702 6396779 6396809 6396816 6396821 6396864 6396865 6396869 6396871 6396878 6396901 6396912 6396915 6396926 6396930 6396948 6396961 6396995 6397020 6397071 6397123 6397130 6397134 6397135 6397171 6397249 6397363 6397369 6397382 6397404 6397405 6397406 6397479 6397489 6397522 6397542 6397676 6397683 6397709 6397712 6398012 6398538 6398778 6398789 6398795 6398827 6398828 6398875 6399020 6399040 6399093 6399148 6399157 6399365 6399371 6399396 6399399 6399441 6399447 6399462 6399464 6399473 6399512 6399542 6399543 6399568 6399573 6399601 6399937 6400147 6401698 6402094 6402178 6402247 6402421 6402546 6402794 6402874 6402953 6403129 6403180 6404002 6404518 6404577 6404991 6404992 6405408 6406507 6406829 6407051 6407392 6407500 6407858 6407996 6408526 1000001832 6409194 6409568 6409574 6411061 6411220 6411822 6412112 6412347 6412632 6412715 6412807 6413351 6415658 6415953 6416274 6416364 6416409 6416415 6416739 6417089 6417116 6417227 6417659 6417694 6417704 6417851 6418225 6418288 6418452 6418489 6419600 6419687 6419951 6419994 6420099 6420541 6421565 6421568 6421680 6422100 6422269 6422563 6422659 6423142 6423179 6423659 6424125 6425994 6426201 6426252 6426652 6427117 6427122 6427270 6427304 6427314 6427390 6427658 6427740 6427876 6427906 6427964 6427980 6428262 6428340 6428433 6428440 6428593 6428711 6428722 6428744 6428793 6429402 6429639 6429830 6429836 6429872 6429931 6430041 6430081 6430273 6430322 6430344 6430345 6430381 6430385 6430452 6430482 6430509 6430531 6430833 6430894 6430944 6431140 6431162 6431293 6431796 6432130 6432149 6432171 6432225 6432360 6433438 6433951 6434400 6434424 6434508 6434670 6434712 6435213 6435220 6435426 6435581 6435582 6435641 6435643 6436441 6437244 6438086 6438106 6438421 6439256 6439594 6440056 6440058 6440520 6440525 6440836 6442016 6442546 6443718 6444098 6444224 6444875 6445220 6445307 6445630 6445647 6446192 6446244 6446873 6449653 6449748 6450456 6450682 6450896 6451016 6451502 6451747 6451751 6452138 6452247 6452258 6452684 6452799 6452814 6452865 6452869 6452893 6452917 6452942 6452983 6452984 6452985 6452989 6452990 6453012 6453024 6453033 6453036 6453042 6453044 6453045 6453047 6453055 6453058 6453060 6453069 6453070 6453072 6453084 6453091 6453112 6453162 6453211 6453257 6453391 6453392 6453396 6453445 6453450 6453612 6453618 6453661 6453705 6453737 6453793 6453802 6453806 6453808 6453922 6453946 6453973 6454057 6454086 6454117 6454279 6454302 6454435 6454618 6455806 6455939 6456017 6456042 6456048 6456206 6456221 6456339 6456361 6456427 6456487 6456506 6456564 6456595 6456603 6456665 6456669 6456769 6456783 6456797 6456814 6456815 6456816 6456821 6457134 6457497 6457645 6458319 6461247 6461689 6462345 6463678 6463789 6463819 6464644 6465254 1000034591 6466510 6466606 6466910 6467274 6469102 6469147 6469856 6470586 6470794 6470944 6471134 6471286 6471373 6471481 6471522 6472296 6473020 6473090 6474422 6475632 6475681 6476799 6477651 6481900 6483508 6483848 6484086 6485354 6490083 6491351 6491846 6492119 6492169 6492314 6492662 6492866 6492997 6493061 6494157 6494243 6494287 6494293 6494462 6494619 6495373 6495429 6495446 6495591 6495634 6495637 6495664 6495679 6495765 6495797 6495805 6495944 6495992 6496281 6496360 6496561 6496586 6496598 6496607 6496640 6496730 6497285 6497378 6497419 6498582 6498648 6498732 6499202 6499655 6499714 6499861 6499952 6499986 6500006 6500088 6500124 6500373 6500375 6500405 6500652 6500768 6500769 6501021 6501450 6501501 6502006 6503069 6503232 6503238 6503394 6503423 6504228 6504229 6504435 6504522 6504523 6504560 6504584 6504622 6504624 6504703 6504845 6504851 6504890 6504928 6504944 6505020 6505036 6505412 6505481 6506144 6506433 6507885 6509046 6510509 6510512 6510575 6510761 6512175 6516087 6517087 6518075 6519154 6519157 6519635 6520148 6520215 6520287 6521220 6521931 6522025 6522058 6522447 6522669 6522936 6523184 6523325 6523712 6524322 6524363 6524825 6525055 6525076 6525137 6525584 6526060 6526250 6526778 6526779 6526809 6526818 6526830 6526845 6526857 6526863 6526911 6527063 6527064 6527068 6527269 6527273 6527423 6527465 6527466 6527467 6527482 6527488 6527539 6527544 6527559 6527581 6527690 6527742 6527857 6527908 6528010 6528022 6528116 6529286 6530526 6530588 6530593 6530828 6530890 6530902 6530920 6530925 6530988 6531010 6531012 6531040 6531085 6531098 6531141 6532774 6532964 6534226 6535577 6535943 6535945 6537094 6537306 6537573 6537775 6538061 6538383 6538994 6539428 6539438 6540205 6541245 6541979 6383674 1000001574 6394179 1000001785 1000001787 1000003608 1000004030 1000004685 1000004735 1000004754 1000004844 1000004871 1000004996 1000005086 1000005375 1000005376 1000005390 1000004882 1000005401 1000006801 1000007128 1000007284 1000007285 1000007286 1000007408 1000007447 1000007570 1000008232 1000009070 1000009373 1000005242 1000010156 1000010209 1000012129 1000012523 1000012887 1000007360 6391132 1000013133 1000013199 1000013345 1000013375 1000013203 1000013619 1000013643 1000013322 1000013938 1000013970 1000014214 1000014409 1000013492 1000014665 1000014985 1000015267 1000015268 1000015269 1000015273 1000015274 1000015276 1000013932 1000015693 1000016028 1000016029 1000016030 1000016793 1000017268 1000017280 1000017283 1000016690 1000017330 1000015275 1000017312 1000017479 1000010998 1000010949 1000017332 1000017374 1000018513 1000018461 1000018605 1000018662 1000017947 1000018558 1000018259 1000019248 1000019252 1000019353 1000017281 1000019511 1000019514 1000019520 1000019521 1000019523 1000019032 1000017331 1000020501 1000020502 1000020508 1000020511 1000020513 1000020515 1000020523 1000020527 1000020551 1000017629 1000018222 1000018372 1000020492 1000017342 1000020589 1000020713 1000020822 1000020894 1000020897 1000020629 1000020962 1000020971 1000020879 1000020560 1000020986 1000021171 1000018527 1000021538 1000021693 1000021615 1000021787 1000022146 1000021451 1000017400 1000022325 1000020941 1000021550 1000022344 1000022332 1000022394 1000010327 1000022485 1000017425 1000017641 1000020847 1000021521 1000022611 1000021279 1000017299 1000020883 1000016763 1000016688 1000021543 1000022354 1000017293 1000021695 1000022183 1000015255 1000023743 1000026837 1000017644 1000027004 1000027428 1000017581 1000023692 1000021276 1000027551 1000027778 1000027809 6376174 1000028997 1000029149 1000029507 1000029509 1000029514 1000029568 1000029779 1000014398 1000029918 1000029919 1000029921 1000029954 1000026930 1000031329 1000029840 1000031668 1000032097 1000032099 1000032102 1000032103 1000032104 1000016760 1000032237 1000032239 1000032248 1000032249 1000032250 1000016821 1000033667 1000033668 1000033669 1000033670 1000033671 1000033749 1000033750 1000033751 1000033865 1000033867 1000033895 1000034084 1000034087 1000034155 1000034169 1000034500 1000034501 1000034502 1000015040 1000034641 1000032297 1000036193 1000040251 1000040882 1000040972 1000034823 1000042360 1000026597 1000042881 1000044550 1000042407 1000048561 1000048627 1000049186 1000049945 1000050300 1000047743 1000051634 1000052873 1000052954 1000053184 1000053209 1000053522 1000053745 1000053914 1000053915 1000053916 1000053556 1000050429 1000054705 1000054797 1000054813 1000054796 1000054818 1000054794 1000054954 1000054957 1000054965 1000055028 1000052295 1000055240 1000054477 1000055601 1000055602 1000055603 1000055851 1000056400 1000056401 1000054989 1000057169 1000057475 1000057568 1000057569 1000057757 1000057761 1000057837 1000057993 1000058218 1000058228 1000058231 1000058233 1000058237 1000058243 1000058244 1000058250 1000058279 1000058296 1000058297 1000058302 1000058301 1000058303 1000058322 1000058327 1000058341 1000058335 1000058342 1000058357 1000058274 1000058372 1000058370 1000058256 1000058389 1000058399 1000058393 1000058409 1000058424 1000058351 1000058307 1000058431 1000058439 1000058450 1000058219 1000058457 1000058534 1000058564 1000058581 1000058623 1000058644 1000058663 1000058660 1000058234 1000058687 1000058708 1000058744 1000058746 1000058761 1000058217 1000058367 1000058556 1000058734 1000058557 1000058723 1000058496 1000058281 1000058760 1000058751 1000058508 1000058543 1000057449 1000059028 1000058473 1000059025 1000058447 1000059104 1000059102 1000059107 1000059117 1000059110 1000058985 1000058590 1000059128 1000059230 1000059016 1000059145 1000059132 1000059173 1000059316 1000059329 1000059325 1000058514 1000059369 1000059382 1000058247 1000059983 1000060007 1000060525 1000060655 1000060959 1000062153 1000062154 1000062215 1000062424 1000062538 1000062816 1000063016 1000063798 1000055821 1000064189 1000060049 1000063810 1000064353 1000064613 1000064642 1000064938 1000064940 1000064944 1000063583 1000065455 1000065650 1000065784 1000065029 1000066200 1000066310 1000066362 1000066381 1000065487 4597 ] |
|
358.90 ms (10.61%) |
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:
[
"32064-cahiers-couleur-hamelin-001201"
]
|
|
4.58 ms (0.14%) |
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:
[ 4597 1 ] |
|
4.03 ms (0.12%) |
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.71 ms (0.11%) |
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:
[
4597
]
|
|
2.68 ms (0.08%) |
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.price_id = ? AND t0.product_id = ? LIMIT 1
Parameters:
[ "CAISSE2011" 65657 ] |
|
2.16 ms (0.06%) |
8 |
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"
]
|
|
1.79 ms (0.05%) |
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
]
|
|
1.30 ms (0.04%) |
2 |
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:
[ 65657 7 ] |
|
0.96 ms (0.03%) |
4 |
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.80 ms (0.02%) |
5 |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
|
0.76 ms (0.02%) |
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 189 4597 ] |
|
0.68 ms (0.02%) |
2 |
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:
[ 65657 0 ] |
|
0.59 ms (0.02%) |
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.product_id = ? AND t0.price_id = ? LIMIT 1
Parameters:
[ 65657 "C" ] |
|
0.57 ms (0.02%) |
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:
[
"32064-cahiers-couleur-hamelin-001201"
]
|
|
0.54 ms (0.02%) |
2 |
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:
[
65657
]
|
|
0.53 ms (0.02%) |
2 |
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 22:02:44" "%2%" 65657 ] |
|
0.45 ms (0.01%) |
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:
[ 65657 9962453 ] |
|
0.41 ms (0.01%) |
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:
[
"32064-cahiers-couleur-hamelin-001201"
]
|
|
0.37 ms (0.01%) |
2 |
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:
[
65657
]
|
|
0.33 ms (0.01%) |
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:
[
187385
]
|
|
0.31 ms (0.01%) |
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:
[
4597
]
|
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 | 1004 |
| App\Entity\Delivery\Delivery | 327 |
| App\Entity\Customer\Customer | 326 |
| App\Entity\User\User | 251 |
| App\Entity\Catalog\ProductCatalog | 229 |
| App\Entity\Catalog\CustomerCatalog | 229 |
| App\Entity\Product\Market | 98 |
| App\Entity\Internal\Commercial | 57 |
| App\Entity\Product\ProductPrice | 52 |
| App\Entity\Pricing\Price | 49 |
| App\Entity\Product\Product | 21 |
| App\Entity\Product\Category | 21 |
| App\Entity\Product\Characteristic | 15 |
| App\Entity\Product\CharacteristicLabel | 15 |
| App\Entity\Internal\Society | 6 |
| App\Entity\Delivery\DeliveryCost | 5 |
| App\Entity\Internal\Parameter | 3 |
| App\Entity\Pricing\Promotion | 2 |