Query Metrics
67
Database Queries
22
Different statements
2555.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1628.92 ms (63.73%) |
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:
[ 348860 "2025-02-14 19:12:46" ] |
|
876.84 ms (34.31%) |
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:
[ 6339337 6340289 6340314 6340446 6336271 6340791 6340964 6341192 6337417 6343286 6343614 6343800 6338334 6335509 6342460 6345342 6345585 6346162 6346335 6346516 6347791 6347865 6348530 6348948 6349036 6349295 6349368 6349370 6349468 6349530 6349539 6349592 6349625 6349810 6349813 6349976 6350176 6350583 6350587 6346094 6351067 6351597 6351711 6352821 6353179 6354949 6337344 6355537 6355827 6359250 6361936 6362836 6360934 6359626 6363807 6364598 6364711 6337868 6367070 6368744 6369371 6369549 6370393 6370410 6371230 6371371 6372014 6372072 6372151 6372558 6372757 6373004 6373019 6373700 6373769 6374355 6365015 6365179 6375256 6375308 6377533 6377146 6377850 6378290 6375086 6378339 6379074 6378150 6379335 6379905 6375300 6380227 6380618 6380740 6381204 6381360 6381532 6381713 6381763 6382401 6382566 6382383 6382804 6383268 6381419 6383467 6383863 6384228 6384757 6385216 6385338 6385283 6385500 6385705 6384057 6378180 6386664 6385142 6386732 6386908 6386784 6387171 6387211 6386975 6387350 6387365 6386706 6386917 6387891 6388120 6388128 6388163 6388369 6388480 6388490 6388513 6388519 6388656 6388732 6388939 6388962 6375698 6389065 6389129 6387016 6387517 6388950 6389699 6390325 6390338 6385855 6390472 6390524 6390736 6360849 6385519 6391060 6390101 6390363 6389031 6391101 6368032 6391376 6391474 6390106 6391379 6391830 6391913 6391952 6392114 6385359 6392140 6392153 6392157 6392179 6392189 6392248 6392260 6392268 6392341 6392349 6392365 6392317 6392373 6392392 6392395 6392440 6392161 6392489 6392492 6392745 6392501 6365569 6368826 6375511 6378240 6378946 6379682 6380653 6393008 6392148 6393146 6384049 6384174 6393405 6393429 6393484 6393544 6393631 6393672 6393775 6393790 6393809 6393810 6393903 6393906 6393912 6393929 6393942 6394096 6394183 6394196 6393601 6394256 6394258 6394259 6394260 6394327 6394348 6394447 6394465 6394507 6392420 6394656 6394662 6394731 6394768 6389471 6394899 6395401 6395409 6395410 6395690 6395740 6395754 6395857 6397191 6397202 6397232 6398076 6398182 6398227 6398333 6398466 6398621 6398622 6398660 6398664 6398743 6398847 6399245 6399334 6399744 6400159 6400222 6400225 6400237 6400359 6400449 6400466 6400472 6400514 6400516 6400595 6401026 6401487 6401513 6401942 6402041 6402076 6402616 6402625 6402820 6403759 6404586 6404608 6404697 6405041 6405091 6405415 6405570 6405630 6405639 6405661 6405684 6405716 6406013 6406069 6406509 6407379 6408098 6408198 6408409 6408529 6408909 6409025 6409195 6410718 6410740 6411369 6411736 6411868 6412178 6412385 6412669 6412832 6413594 6413610 6413643 6413745 6413754 6414207 6414425 6414606 6414616 6414967 6415071 6415083 6415200 6415412 6415843 6415866 6415886 6415967 6415977 6415987 6416013 6416024 6416036 6416037 6416039 6416072 6416197 6416325 6416390 6416397 6416436 6416476 6416762 6416778 6416784 6416804 6416831 6416855 6416987 6417020 6417103 6417110 6417284 6417444 6417468 6417518 6417579 6417580 6417608 6417628 6417662 6417972 6418002 6418024 6418161 6418171 6418265 6418528 6418536 6418838 6418843 6418893 6418998 6418999 6419151 6419152 6419157 6419170 6419205 6419211 6419215 6419216 6419236 6419239 6419240 6419249 6419272 6419279 6419294 6419300 6419319 6419342 6419343 6419353 6419354 6419362 6419387 6419393 6419403 6419414 6419485 6419540 6419544 6419696 6419890 6419892 6419893 6419894 6419895 6419896 6419992 6420215 6420228 6420529 6420628 6420633 6420634 6420676 6420714 6420715 6420735 6420835 6420990 6421666 6421744 6421980 6422044 6422229 6422236 6422495 6422651 6422661 6423164 6423687 6423942 6423954 6424114 6424773 6425263 6426477 6426492 6426808 6426914 6426925 6427053 6427315 6427608 6427857 6427919 6428824 6429041 6429794 6429928 6430292 6430400 6431185 6431494 6431497 6431586 6432163 6432208 6432274 6434121 6434335 6434498 6434626 6434655 6434805 6434859 6434852 6435013 6435283 6435525 6435634 6435691 6435697 6436023 6436256 6437058 6437075 6437148 6437791 6438835 6439448 6439566 6439639 6439964 6440012 6440063 6440932 6440998 6441061 6441265 6441493 6442584 6443124 6443204 6443258 6443274 6443373 6443493 6444333 6444356 6444653 6445261 6445295 6445777 6446244 6446366 6446861 6446931 6446982 6447121 6447299 6447386 6447490 6447692 6447697 6448208 6448285 6448776 6448847 6448252 6449116 6449432 6449499 6449642 6449643 6449703 6450035 6450104 6450153 6450166 6450247 6450294 6450374 6450624 6450697 6450832 6450856 6451068 6451083 6451093 6451129 6451186 6451311 6451326 6451331 6451374 6451434 6451440 6451496 6451577 6451600 6451604 6451703 6451824 6452004 6452037 6452073 6452220 6452247 6452263 6452313 6452323 6452364 6452465 6452532 6453224 6453477 6453498 6453524 6454525 6454544 6454582 6454591 6454626 6454665 6454842 6454844 6454848 6454862 6454949 6454976 6455180 6455257 6455267 6455337 6455345 6455381 6455420 6455547 6455620 6455636 6455650 6455682 6455701 6455708 6455717 6455750 6455762 6455777 6455802 6455833 6455842 6455884 6456026 6456294 6456295 6457009 6457046 6457209 6457248 6457259 6457280 6457507 6457761 6458510 6458839 6459237 6459638 6459877 6459930 6460000 6460036 6460504 6460955 6460958 6461103 6461334 6461463 6461654 6461866 6462350 6462500 6462637 6462814 6463598 6463768 6463926 6464017 6464229 6464578 6464770 6465606 6466050 6466585 6466612 6466627 6466750 6467374 6468112 6469887 6469983 6470113 6470682 6470714 6471127 6471304 6471954 6471992 6390645 1000000920 1000000994 6394586 6392544 1000000905 1000001335 1000001358 1000001985 1000002060 1000001957 1000002182 6394898 6387845 1000002549 1000002558 1000002584 1000002712 1000000976 6394212 1000001987 1000003856 1000003193 6392374 1000001024 6391971 1000004448 1000004490 1000004779 1000004800 1000002804 1000004554 6388815 6391616 1000006276 1000006533 1000006564 1000006953 1000007010 1000003437 1000007604 1000007641 1000008211 1000008333 1000008195 1000008277 1000008934 1000008965 1000009046 1000009114 6388565 1000009811 1000009865 1000009593 1000007869 1000009808 1000009641 1000010289 1000010501 1000010494 1000010547 1000010563 1000009631 1000010691 1000010705 1000009449 1000010811 1000009248 1000010823 1000009110 1000006779 1000010524 1000011009 1000011801 1000011970 1000012006 1000012011 1000010520 1000012108 1000012168 1000006955 1000012361 1000012410 1000012401 1000012463 6392545 1000012524 1000012636 1000012679 1000012770 1000006069 1000002237 1000010987 1000013558 1000010502 1000013792 1000012989 1000013338 1000013510 1000014413 1000006265 1000015046 1000014223 1000015539 1000015647 1000015411 1000015742 1000015833 1000010519 1000012713 1000016116 1000016117 1000016251 1000016501 1000016530 1000016175 1000014584 1000009659 1000017647 1000017968 1000018067 1000018069 1000018070 1000018084 1000018271 1000018274 1000018317 1000018332 1000018333 1000013165 1000018341 1000018360 1000006098 1000018818 1000018845 1000018846 1000018864 1000019222 1000019294 1000019373 1000019487 1000019511 1000019514 1000019520 1000019521 1000019523 1000019608 1000019550 1000020043 1000020068 1000020219 1000015773 1000012830 1000014848 1000020240 1000019306 1000021359 1000014070 1000021693 1000021856 1000021858 1000019095 1000021984 1000021985 1000012427 1000010604 1000017181 1000022743 1000022945 1000022951 1000022952 1000022953 1000022955 1000022963 1000022967 1000022969 1000022976 1000022978 1000022979 1000022980 1000022981 1000023919 1000023920 1000023921 1000023922 1000023923 1000023931 1000023933 1000023935 1000023947 1000023987 1000023996 1000024002 1000024029 1000024401 1000024406 1000024407 1000024424 1000024425 1000024427 1000024431 1000024433 1000024436 1000024437 1000024444 1000024446 1000024449 1000024450 1000024459 1000024471 1000024474 1000024475 1000024767 1000024771 1000024794 1000024795 1000024796 1000024799 1000024804 1000025163 1000025166 1000025171 1000025315 1000021695 1000026202 1000026216 1000019352 1000023405 1000026902 1000016699 1000027345 1000027553 1000027592 1000011043 1000027856 1000027857 1000027858 1000027864 1000027865 1000027885 1000027894 1000028492 1000028592 1000028597 1000028628 1000028646 1000028647 1000028649 1000028650 1000028658 1000028706 1000028707 1000028709 1000020109 1000027595 1000017132 1000015969 1000020603 1000029926 1000030055 1000030066 1000027188 1000030656 1000030658 1000030660 1000030672 1000030685 1000030687 1000030688 1000012292 1000031681 1000002606 1000031718 1000031722 1000031748 1000031844 1000031845 1000031848 1000031852 1000031928 1000031929 1000031940 1000031949 1000031950 1000031964 1000031991 1000032434 1000015750 1000032999 1000033002 1000033004 1000032674 1000024477 1000033043 1000032072 1000033217 1000033220 1000017152 1000033762 1000033763 1000033764 1000033766 1000033768 1000033769 1000033771 1000033773 1000033774 1000033775 1000033776 1000033777 1000033778 1000033779 1000033780 1000033782 1000033783 1000033784 1000033785 1000033786 1000033787 1000033788 1000033789 1000033790 1000033791 1000033797 1000033801 1000019906 1000032441 1000032348 1000014697 1000017966 1000034757 1000034758 1000034759 1000009857 1000035844 1000036299 1000035153 1000028710 1000031784 1000036774 1000037653 1000037715 1000037750 1000037774 1000027876 1000020081 1000040193 1000040195 1000040196 1000040199 1000040206 1000012594 1000009770 1000041285 1000041325 1000039206 1000041480 1000041488 1000041907 1000042035 1000042038 1000042039 1000042040 1000039265 1000042046 1000042052 1000042053 1000042054 1000042059 1000042060 1000042063 1000042064 1000042068 1000042074 1000042342 1000042541 1000042546 1000034456 1000042548 1000042550 1000042551 1000042555 1000042616 1000042629 1000042630 1000042633 1000042634 1000042683 1000042706 1000042737 1000042777 1000042924 1000043073 1000043077 1000041637 1000044451 1000044452 1000044454 1000044681 1000016447 1000044753 1000045295 1000020256 1000045681 1000045722 1000045723 1000045726 1000046036 1000046498 1000042565 1000041412 1000046813 1000046841 1000047024 1000047424 1000047422 1000047720 1000047918 1000047958 1000048080 1000020270 1000039381 1000048320 1000048323 1000048356 1000047951 1000048491 1000034785 1000048770 1000048245 1000048834 1000048867 1000048951 1000048077 1000049204 1000049202 1000049310 1000049445 1000049453 1000049173 1000049524 1000049621 1000049662 1000049819 1000049851 1000049635 1000048082 1000050055 1000050081 1000050239 1000050241 1000041807 1000050358 1000050360 1000016534 1000050619 1000050665 1000050816 1000047596 1000051007 1000051075 1000051168 1000051257 1000049381 1000050498 1000051321 1000049562 1000051338 1000048650 1000051399 1000051511 1000050334 1000051628 1000038011 1000051747 1000051751 1000051401 1000049292 1000052028 1000052042 1000052045 1000047926 1000049860 1000052183 1000051693 1000050594 1000048311 1000049144 1000052317 1000052329 1000052408 1000052461 1000052467 1000022359 1000052500 1000052537 1000052543 1000052591 1000049690 1000017969 1000052682 1000052714 1000052801 1000039993 1000052837 1000052838 1000052605 1000052908 1000052959 1000051753 1000052562 1000052187 1000053117 1000053122 1000053138 1000053139 1000053365 1000053423 1000048612 1000048976 1000052799 1000008070 1000053653 1000052584 1000053859 1000004477 1000052670 1000053998 1000054000 1000054001 1000054011 1000054012 1000054020 1000054022 1000054072 1000053510 1000054288 1000054298 1000054313 1000053882 1000052593 1000054319 1000051058 1000052928 1000051265 1000054549 1000054624 1000054628 1000050486 348860 ] |
|
33.34 ms (1.30%) |
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:
[
"13126-papier-dessin-couleur-n-c-19100614"
]
|
|
2.99 ms (0.12%) |
19 |
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:
[
391
]
|
|
1.62 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.62 ms (0.06%) |
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:
[ 348860 1 ] |
|
1.46 ms (0.06%) |
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:
[ 348576 7 ] |
|
1.21 ms (0.05%) |
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" 348576 ] |
|
0.85 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.81 ms (0.03%) |
5 |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
|
0.75 ms (0.03%) |
4 |
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:
[
198232
]
|
|
0.68 ms (0.03%) |
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:
[ 83 388 389 390 391 392 393 394 395 391 348860 ] |
|
0.59 ms (0.02%) |
2 |
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:
[
348576
]
|
|
0.57 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:
[ 348576 0 ] |
|
0.56 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 FROM product t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"13126-papier-dessin-couleur-n-c-19100614"
]
|
|
0.52 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:
[ 348576 "C" ] |
|
0.51 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-07-14 19:12:49" "%2%" 348576 ] |
|
0.48 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:
[
348576
]
|
|
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.38 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:
[
"13126-papier-dessin-couleur-n-c-19100614"
]
|
|
0.38 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:
[
348576
]
|
|
0.29 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:
[
348860
]
|
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.