Query Metrics
187
Database Queries
23
Different statements
2113.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1419.18 ms (67.13%) |
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:
[ 170349 "2025-02-12 11:20:51" ] |
|
508.50 ms (24.05%) |
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:
[ 6337433 6337709 6338304 6338430 6338447 6338806 6338905 6338892 6339070 6339168 6339201 6339397 6339496 6339682 6339725 6339748 6340205 6341019 6340836 6341259 6341871 6342083 6342118 6342540 6342727 6342745 6342894 6343148 6343501 6343844 6344153 6344239 6344501 6344599 6344968 6345025 6345212 6341051 6345286 6345545 6346089 6346251 6346443 6346625 6346704 6346749 6346757 6346881 6347040 6347041 6347241 6347515 6347673 6347686 6347779 6347867 6347883 6347923 6347934 6348063 6348080 6348109 6348176 6348304 6348328 6348444 6348454 6348842 6348843 6348852 6349054 6349196 6349366 6349429 6349434 6349574 6349645 6349675 6349981 6350018 6350762 6350786 6350835 6350858 6350915 6351252 6351305 6351326 6351345 6351964 6352456 6352678 6352765 6353012 6353044 6353409 6353421 6353486 6353571 6353606 6353761 6318390 6353994 6354278 6354338 6354564 6354099 6352503 6355965 6356278 6356849 6357463 6343042 6359492 6359802 6359870 6359919 6360015 6360068 6360163 6360174 6360450 6360592 6360799 6360890 6361097 6361142 6360903 6362423 6362631 6362742 6363200 6363442 6363489 6362521 6334636 6364643 6364800 6363988 6365657 6365664 6365784 6366305 6366588 6367622 6367716 6367771 6364227 6367859 6368377 6369037 6369143 6369224 6369269 6369384 6369461 6369622 6369787 6370180 6370283 6370288 6370331 6370332 6370339 6370420 6370498 6370589 6370594 6370650 6370860 6370878 6370953 6370967 6370989 6371361 6371473 6372314 6372426 6372690 6372747 6372777 6372856 6372904 6373214 6374045 6374387 6374713 6375317 6375309 6375351 6375704 6375712 6375733 6375974 6376534 6377725 6377760 6377944 6378162 6378798 6379599 6379830 6380306 6380951 6380995 6381145 6381417 6381632 6381673 6381936 6382046 6382263 6382486 6382825 6382910 6383049 6383184 6383513 6383876 6361090 6384516 6384692 6384432 6385106 6385145 6385229 6385524 6385988 6386107 6380719 6385609 6386515 6386658 6386704 6386715 6386741 6386774 6386789 6386897 6387198 6387353 6386141 6387783 6387868 6387899 6388143 6388314 6382852 6388446 6363583 6388748 6388871 6389670 6344583 6390314 6390679 6390958 6391133 6391310 6391349 6334912 6391608 6392181 6392286 6392372 6392565 6392595 6392838 6393231 6393616 6394004 6394403 6394666 6395036 6395070 6395074 6395169 6395215 6395249 6395300 6395594 6395664 6395813 6395999 6396064 6396094 6396198 6396280 6396356 6396390 6396424 6396426 6396428 6396562 6396683 6396721 6396736 6396949 6397061 6397073 6397149 6397197 6397308 6397315 6397452 6398764 6398837 6398910 6399240 6399462 6399813 6399815 6399879 6399941 6402142 6402322 6402357 6402538 6402639 6402954 6403138 6403674 6403693 1000002801 6404205 6404380 6404387 6404863 6404902 6404975 6405105 6405119 6405131 6405189 6405327 6405472 6406054 6406222 6406353 6407532 6407742 6407755 6407860 6408013 6408758 6408812 6408843 6408917 6409351 6409568 6409627 6410140 6410349 6410440 6410865 6410902 6411110 6411124 6411133 6411247 6411297 6411795 6411868 6411960 6412067 6412078 6412304 6412675 6412676 6412741 6412823 6412830 6412966 6413004 6413371 6413485 6413844 6414139 6414534 6414778 6415362 6415651 6415671 6415696 6415762 6415996 6416276 6416409 6416453 6416487 6416811 6417012 6417189 6417225 6417245 6417339 6417410 6417565 6417567 6417612 6417672 6417707 6417723 6417866 6417968 6418067 6418123 6418169 6418206 6418332 6418363 6418432 6418620 6418761 6418942 6419168 6419353 6419552 6419799 6419814 6420091 6420096 6420252 6420331 6420384 6420424 6420595 6420725 6421749 6421956 6422161 6422358 6422664 6422738 6422792 6422796 6423832 6424144 1000009579 6424661 6424794 6424918 6425047 6425169 6425357 6425432 6425553 6425778 6425875 6426365 6426568 6426695 6427092 6427675 6427766 6427777 6428178 6428219 6428323 6428408 6428836 6429044 6429648 6429814 6429961 6430330 6430870 6430922 6430945 6431094 6431164 6431192 6431302 6431529 6431846 6431902 6431976 6432007 6432041 6432192 6432197 6432241 6433418 6433451 6434932 6434991 6435038 6435210 6435459 6435496 6435777 6435928 6436354 6436779 6437023 6437277 6437439 6437582 6437739 6437893 6438078 6438094 6438149 6438595 6438899 6439117 6439196 6439637 6439997 6440166 6440211 6440287 6440370 6440485 6440558 6440606 6440826 6440944 6441064 6441061 6441145 6441195 6442452 6442942 6443197 6443334 6443384 6443650 6444114 6444501 6444641 6444760 6445231 6445254 6445299 6445306 6445767 6445910 6445906 6446048 6446337 6446344 6446483 6446619 6446694 6446956 6447013 6447582 6447642 6447662 6447689 6448217 6448568 6449116 6449341 6449558 6449618 6449739 6449807 6449928 6449930 6449949 6450118 6450126 6450191 6450314 6450455 6450599 6450652 6450975 6451042 6451163 6451252 6451275 6451288 6451386 6451442 6451478 6451483 6451487 6451488 6451616 6451664 6451759 6451794 6451807 6451872 6452040 6452057 6452058 6452059 6452089 6452123 6452149 6452214 6452218 6452282 6452407 6452446 6452449 6452591 6452611 6452619 6452702 6452743 6452895 6452913 6452962 6453014 6453231 6453253 6453731 6454181 6454188 6454216 6454361 6454505 6454614 6454622 6454657 6454737 6454921 6454949 6454970 6455082 6455216 6455288 6455423 6455531 6455660 6455687 6455694 6455696 6455949 6455984 6456036 6456070 6456118 6456792 6456829 6456950 6457040 6457088 6457126 6457143 6457232 6457284 6457404 6457423 6457425 6457650 6457651 6457755 6458003 6458251 6458366 6458475 6459209 6448232 6460043 6460200 6460225 6460257 6460293 6461103 6461269 6461319 6461324 6461677 6462240 6462364 6462471 6462609 6462653 6463558 6464010 6464303 6464416 6464664 6465194 6465683 6465822 6465871 6466132 6466425 6466622 6466633 6466695 6466705 6467429 6468672 1000000900 1000001162 1000001216 1000001218 1000001356 1000001578 6385464 1000001782 1000001854 1000002630 1000002634 1000002675 1000002677 1000003607 1000003920 1000003979 6314823 1000004829 6393453 1000005298 6389079 1000006852 1000007017 1000007290 1000007408 1000007447 1000007472 1000007581 1000007762 1000007907 1000002530 1000008186 1000008211 1000008251 1000008254 1000008291 1000008419 1000008425 1000008431 1000008432 1000008433 1000008472 1000008454 1000006417 1000007070 1000008558 1000004822 1000008852 1000008496 1000004570 1000010051 1000010248 1000010406 1000010830 1000009425 1000002066 1000009173 1000011978 1000010960 6383658 6391043 1000012525 1000012714 1000012824 6388587 1000012548 1000009802 1000008225 1000012800 1000011979 1000013839 1000013753 1000014494 1000014509 1000014802 1000014102 1000013732 1000015004 1000015113 1000015463 1000015621 1000015622 1000002600 1000016593 1000014577 1000014668 1000018201 1000018246 1000018295 1000010608 1000018375 1000012790 1000018773 1000018777 1000015624 1000018800 1000019429 1000019495 1000019762 1000019763 1000019764 1000019765 1000019766 1000019767 1000019769 1000019770 1000019771 1000019772 1000019773 1000019774 1000019775 1000019776 1000019777 1000019778 1000019780 1000019781 1000019782 1000019783 1000019784 1000019785 1000019786 1000019787 1000019788 1000019789 1000019790 1000019791 1000019792 1000019793 1000012630 1000020972 1000020973 1000020974 1000020975 1000020976 1000014167 1000021329 1000012146 1000005551 1000018109 1000009713 1000022452 1000002241 1000002448 1000022625 1000022270 1000022870 1000022871 1000022872 1000022935 1000024432 1000024434 1000024467 1000024502 1000024503 1000025944 1000026387 1000026388 1000026389 1000026390 1000026391 1000026392 1000026393 1000026394 1000026395 1000026396 1000026397 1000025958 1000021539 1000021047 1000022875 1000026761 1000010252 1000021567 1000027185 1000027187 1000025656 1000012775 1000028524 1000028528 1000016055 1000028290 1000029098 1000028977 1000029878 1000029902 1000016123 1000028296 1000031951 1000019526 1000032300 1000032350 1000032355 1000032374 1000016318 1000017246 1000021951 1000014806 1000034489 1000034494 1000034508 1000032483 1000034959 1000035519 1000014560 1000033070 1000032212 1000036254 1000036400 1000036404 1000036420 1000036421 1000036436 1000021485 1000037329 1000037362 1000037363 1000037450 1000037452 1000037471 1000037472 1000037489 1000037490 1000037491 1000037496 1000037497 1000037519 1000037662 1000018418 1000038689 1000038713 1000038725 1000038762 1000038789 1000038860 1000038862 1000038876 1000038877 1000038880 1000038882 1000038885 1000038886 1000038887 1000038889 1000038891 1000038892 1000038903 1000036216 1000039118 1000039285 1000039329 1000039340 1000039451 1000039452 1000037511 1000039855 1000034830 1000040205 1000040234 1000040241 1000039662 1000041102 1000041119 1000035533 1000041246 1000037531 1000039206 1000033890 1000041341 1000042675 1000042677 1000042924 1000043803 1000043979 1000043985 1000040973 1000043991 1000043992 1000043993 1000044355 1000044616 1000044637 1000044655 1000044681 1000044718 1000044737 1000044770 1000044771 1000044773 1000044776 1000044777 1000044848 1000026490 1000039739 1000045641 1000045642 1000045643 1000045644 1000045645 1000045646 1000045647 1000045648 1000045649 1000045650 1000045651 1000045652 1000045653 1000045907 1000045911 1000045961 1000046036 1000046047 1000046048 1000037514 1000037448 1000046357 1000046358 1000046359 1000046756 1000046759 1000046764 1000046813 1000046863 1000046864 1000047569 1000047572 1000038791 1000048001 1000048010 1000048168 1000048178 1000048296 1000048301 1000048371 1000035864 1000048520 1000042481 1000048590 1000048655 1000048658 1000048490 1000048042 1000048870 1000049073 1000049296 1000049347 1000049349 1000049473 1000045636 1000048802 1000048969 1000049404 1000049805 1000049917 1000049977 1000050015 1000050016 1000044949 1000050202 1000042943 1000050366 1000049322 1000029598 1000047122 1000047146 1000050692 1000050996 1000050363 1000051090 1000051096 1000051154 1000050374 1000051270 1000051361 1000049648 1000050334 1000051555 1000051054 1000051807 1000048949 1000051958 1000051806 1000051560 1000052190 1000051334 1000052365 1000050159 1000052554 1000052556 1000052615 1000050975 1000052681 1000052817 1000052902 1000052908 1000049273 1000053002 1000053003 1000053009 1000053097 1000053081 1000053122 1000053139 1000049026 1000048580 1000053333 1000053354 170349 ] |
|
125.37 ms (5.93%) |
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:
[
"22971-pochettes-perforees-transparent-n-c-100740954"
]
|
|
8.00 ms (0.38%) |
9 |
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:
[ 990 0 ] |
|
7.62 ms (0.36%) |
9 |
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:
[
990
]
|
|
6.30 ms (0.30%) |
18 |
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" 990 ] |
|
6.29 ms (0.30%) |
8 |
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:
[ 990 7 ] |
|
5.64 ms (0.27%) |
29 |
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"
]
|
|
4.01 ms (0.19%) |
18 |
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"
]
|
|
2.94 ms (0.14%) |
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.90 ms (0.14%) |
19 |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
|
2.53 ms (0.12%) |
14 |
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:
[
197829
]
|
|
2.52 ms (0.12%) |
9 |
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:
[ 990 "C" ] |
|
2.45 ms (0.12%) |
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:
[ 50 238 239 240 241 238 241 170349 ] |
|
2.23 ms (0.11%) |
9 |
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 11:20:53" "%2%" 990 ] |
|
1.69 ms (0.08%) |
9 |
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:
[
990
]
|
|
1.64 ms (0.08%) |
6 |
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:
[ 1032 9957104 ] |
|
1.50 ms (0.07%) |
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:
[ 170349 1 ] |
|
0.83 ms (0.04%) |
3 |
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:
[
990
]
|
|
0.71 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:
[
"22971-pochettes-perforees-transparent-n-c-100740954"
]
|
|
0.44 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:
[
"22971-pochettes-perforees-transparent-n-c-100740954"
]
|
|
0.42 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.28 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:
[
170349
]
|
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.