Query Metrics
80
Database Queries
23
Different statements
2254.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1475.95 ms (65.46%) |
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:
[ 11024 "2025-02-15 12:37:43" ] |
|
754.83 ms (33.48%) |
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:
[ 6336729 6339450 6339700 6339734 6339740 6339714 6340152 6340424 6340445 6340502 6340507 6340778 6341113 6341257 6340786 6341946 6341952 6341973 6342033 6339806 6342337 6342250 6342691 6342808 6342852 6342968 6343009 6337452 6343024 6343409 6343453 6343704 6343902 6344040 6344057 6344103 6344141 6344169 6344475 6344605 6344919 6344960 6344963 6345101 6345108 6345177 6345179 6321089 6345788 6345957 6346093 6346591 6346776 6346928 6347320 6347326 6347576 6347629 6347687 6347688 6347879 6348002 6348115 6348135 6348136 6348137 6348180 6348230 6348290 6348338 6348552 6348597 6348705 6348786 6348866 6348973 6348977 6349212 6349523 6349838 6349935 6350138 6350187 6350302 6350400 6350401 6350437 6350470 6350794 6350858 6351231 6351252 6351661 6352116 6352291 6351736 6353256 6353447 6353965 6354259 6354486 6355071 6355148 6355306 6355700 6355887 6356495 6356549 6356800 6356885 6357361 6354700 6358077 6358167 6358170 6358400 6358432 6357656 6358532 6358908 6358934 6353564 6359680 6345024 6359809 6359821 6359885 6360009 6360114 6360694 6360765 6360835 6361156 6361413 6361584 6361619 6361881 6362099 6362376 6362408 6362564 6336595 6363017 6363431 6362521 6360934 6363807 6340715 6364417 6363960 6365112 6363490 6363362 6365784 6366391 6366397 6366476 6367272 6367632 6367647 6367830 6368092 6368483 6368604 6368736 6369026 6369313 6369346 6370187 6370197 6370258 6370397 6370410 6370413 6370420 6370549 6370878 6370879 6370889 6370890 6370929 6370980 6370989 6371010 6371059 6371060 6371095 6371237 6371382 6371798 6371895 6372413 6372426 6372697 6372776 6372817 6372915 6372993 6373063 6374033 6374051 6374182 6374190 6374596 6374884 6375140 6374061 6375347 6375194 6376282 6376312 6376589 6376133 6376788 6377014 6377542 6377757 6376663 6378140 6367669 6378909 6379033 6374767 6379882 6380190 6380344 6380833 6380933 6380988 6381272 6381286 6381650 6381856 6382384 6382594 6382598 6382717 6382836 6382999 6383198 6383238 6383239 6383324 6383391 6383434 6383511 6383695 6382393 6384048 6384275 6384397 6384450 6384734 6385020 6385186 6379676 6385507 6385427 6380378 6384416 6386149 6386395 6386415 6385609 6386592 6386651 6386753 6386839 6386897 6386838 6387462 6387669 6387676 6388071 6385649 6386600 6388180 6388279 6388349 6388479 6388514 6388546 6388721 6388889 6387809 6389051 6389197 6389228 6389651 6389661 6389936 6390145 6389983 6390320 6390393 6390337 6390579 6390617 6390745 6391002 6386905 6389858 6391258 6391453 6391567 6391670 6391679 6391898 6391907 6391924 6391990 6392037 6392098 6353316 6392489 6392561 6387947 6392706 6392785 6392966 6393017 6393482 6393674 6393974 6394118 6394182 6392535 6394634 6395018 6395036 6395087 6395259 6395390 6395425 6395613 6395797 6395893 6396043 6396057 6396280 6396429 6396539 6396670 6396695 6396710 6396730 6396741 6396751 6396752 6397005 6397009 6397061 6397139 6397333 6397524 6397566 6397596 6397727 6398275 6398538 6398542 6398611 6398746 6398969 6399061 6399074 6399076 6399079 6399095 6399142 6399173 6399174 6399218 6399219 6399220 6399285 6399292 6399339 6399513 6399597 6400769 6401618 6401695 6402249 6403162 6403592 6403865 6404476 6404623 6404885 6404887 6404888 6405093 6405112 6405495 6405930 6406076 6406085 6406261 6406728 6407467 6407556 6407953 6408398 6409174 6409465 6409629 6410318 6410338 6410344 6410900 6410904 6410945 6410965 6411914 6411936 6411967 6412540 6412743 6412780 6413376 6413595 6413813 6413823 6414609 6414673 6415077 6415191 6415220 6415629 6415639 6415823 6415939 6416269 6416344 6416374 6416541 6416861 6416998 6417007 6417225 6417262 6417390 6417429 6417667 6417714 6417823 6417878 6417924 6418058 6418122 6418159 6418290 6418294 6418391 6418458 6418524 6419101 6419285 6419602 6419680 6419783 6419964 6419968 6420392 6420607 6421067 6422156 6422402 6422448 6422452 6422470 6422754 6422772 6422943 6422993 6423772 6424155 6424683 6424733 6425053 6425907 6426377 6426409 6426487 6426559 6426592 6426665 6427031 6427262 6427714 6427715 6427904 6428340 6428381 6428641 6428880 6428881 6429017 6429044 6429076 6429157 6429275 6429358 6429467 6429485 6429693 6429969 6430678 6430789 6430950 6431261 6431291 6431785 6431816 6431891 6431906 6431950 6433660 6433750 6433756 6433760 6433943 6434182 6434421 6434710 6435332 6435747 6435859 6435928 6436082 6436385 6437234 6437275 6438124 6438595 6438721 6438894 6439198 6439253 6439403 6439600 6439983 6440066 6440079 6440218 6440794 6441305 6441371 6441390 6442079 6442459 6443134 6443139 6443356 6443569 6443728 6444063 6444325 6444409 6445713 6446984 6447064 6447564 6447568 6447682 6448215 6448228 6449535 6449637 6450117 6450136 6450155 6450161 6450217 6450253 6450282 6450379 6450436 6450451 6450460 6450496 6450498 6450860 6451035 6451106 6451120 6451131 6451330 6451356 6451404 6451449 6451477 6451800 6451839 6452089 6452291 6452308 6452420 6452554 6452580 6452614 6452619 6452873 6452893 6452908 6452927 6452928 6452929 6453015 6453071 6453090 6453125 6453148 6453206 6453424 6453471 6453576 6453655 6453659 6453664 6453775 6453779 6453847 6453850 6453929 6454130 6454136 6454152 6454162 6454213 6454357 6454427 6454531 6455347 6455349 6455365 6455507 6455528 6455614 6456236 6456345 6456385 6456424 6456455 6456523 6456538 6456559 6456648 6456675 6456704 6456748 6456780 6456822 6456892 6456953 6457945 6459048 6459411 6459524 6459561 6460349 6460466 6460965 6460990 6461104 6461690 6461846 6461915 6462224 6462962 6463237 6464372 6464811 6465378 6465783 6466369 6466460 6466603 6466761 6466806 6467427 6467782 6467783 6468755 6468821 6469214 6469316 6469518 6469598 1000052144 6470185 6470874 6471812 1000001090 1000001876 1000002316 1000002968 1000003502 1000002037 1000004036 1000004168 1000004194 1000004210 1000004633 1000004715 1000005236 1000005518 1000005945 1000005946 1000005947 1000003410 1000005205 1000007327 1000003286 1000002436 1000001362 1000008027 1000008187 1000008819 1000008926 1000008938 1000006299 1000001531 1000008950 1000009089 1000009407 1000009532 1000005944 1000008053 1000010443 1000010181 1000010919 1000011064 1000011826 1000011882 1000011920 1000011922 1000012050 1000004803 1000012414 1000004783 1000013007 1000013008 1000013018 6390488 1000013326 6393554 1000013635 1000013859 1000010873 1000013881 1000014135 1000014136 1000014137 1000014168 1000008738 1000014473 1000014916 1000015096 1000015097 1000015099 1000015157 1000010243 1000013511 1000015608 1000015609 1000015610 1000015743 1000014224 6378310 1000012275 1000012596 1000008568 1000015723 1000018403 1000018492 1000018494 1000018495 1000018502 1000018589 1000010004 1000019252 1000019446 1000019452 1000012211 1000020272 1000020524 1000020892 1000020920 1000021159 1000021177 1000021007 1000021222 1000014850 1000021644 1000022185 1000022246 1000022275 1000022393 1000022438 1000022439 1000022444 1000022448 1000022475 1000022482 1000022486 1000022487 1000022512 1000022516 1000022582 1000022852 1000022855 1000022930 1000022939 1000023322 1000023859 1000014749 1000026180 1000015615 1000026573 1000020655 1000021567 1000027363 1000027364 1000027365 1000027366 1000015437 1000019834 1000028307 1000028308 1000028309 1000028315 1000028318 1000028355 1000028357 1000028358 1000028665 1000028666 1000012149 1000028998 1000028737 1000025948 1000029569 1000029579 1000029594 1000029635 1000029647 1000029668 1000031315 1000031317 1000031318 1000020181 1000031729 1000031730 1000031731 1000031732 1000031734 1000031737 1000031738 1000031740 1000031741 1000031742 1000031743 1000031744 1000031745 1000031747 1000031749 1000031751 1000031752 1000031757 1000031758 1000031760 1000031766 1000031767 1000031768 1000031770 1000031772 1000031773 1000031775 1000031777 1000031778 1000031779 1000031811 1000031812 1000031814 1000031815 1000031816 1000031818 1000031819 1000031821 1000031822 1000031823 1000031824 1000031825 1000031826 1000031827 1000031828 1000031829 1000031832 1000031833 1000031834 1000031835 1000031837 1000031838 1000031839 1000031871 1000031872 1000031881 1000031888 1000032317 1000032431 1000031873 1000032535 1000032536 1000032542 1000032084 1000033217 1000033220 1000005600 1000033654 1000033980 1000034352 1000030026 1000015443 1000035703 1000028674 1000027017 1000036586 1000037649 1000037705 1000037707 1000037708 1000037709 1000037710 1000038311 1000038314 1000038722 1000038723 1000038770 1000038773 1000038776 1000038859 1000038867 1000038870 1000016664 1000039015 1000039017 1000039019 1000039020 1000027770 1000040704 1000040728 1000040737 1000040908 1000041287 1000041290 1000041395 1000041402 1000041416 1000041417 1000041438 1000041441 1000041475 1000041504 1000041587 1000041763 1000041765 1000042069 1000042071 1000042410 1000041936 1000042738 1000042739 1000042741 1000042743 1000042744 1000042745 1000042749 1000042812 1000042831 1000042886 1000042887 1000043271 1000043273 1000043543 1000043546 1000042523 1000043636 1000043663 1000043665 1000043677 1000043678 1000043833 1000043835 1000043836 1000043838 1000043839 1000043851 1000018447 1000044038 1000044109 1000044110 1000044112 1000044140 1000044142 1000044147 1000044148 1000044150 1000044275 1000044288 1000044336 1000044807 1000044808 1000044810 1000045011 1000045013 1000045016 1000040900 1000025687 1000046279 1000046280 1000046281 1000046282 1000046283 1000046286 1000046287 1000046827 1000046796 1000046979 1000046988 1000046989 1000046990 1000046991 1000047127 1000047352 1000047441 1000047443 1000047444 1000047602 1000046444 1000047893 1000048085 1000048086 1000048113 1000048164 1000048061 1000048645 1000048651 1000048655 1000048658 1000042965 1000042849 1000042840 1000048875 1000048928 1000048970 1000049298 1000048776 6374013 1000020246 1000049877 1000049900 1000049975 1000050045 1000047354 1000050285 1000050286 1000050362 1000050361 1000050245 1000050597 1000048340 1000050665 1000050676 1000050733 1000050771 1000050831 1000050907 1000051072 1000048088 1000049043 1000051150 1000048314 1000049562 1000042567 1000045792 1000051402 1000022825 1000051495 1000051559 1000051722 1000051723 1000048597 1000052111 1000052611 1000052642 1000048997 1000052903 1000052472 1000053097 1000053218 1000053653 1000052448 1000053769 1000053607 1000050060 1000053605 1000054116 1000054140 1000054250 1000054304 1000054330 1000054354 1000054494 11024 ] |
|
2.88 ms (0.13%) |
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.55 ms (0.11%) |
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:
[
"45201-n3-couleur-n-c-18000101099"
]
|
|
2.18 ms (0.10%) |
11 |
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"
]
|
|
2.17 ms (0.10%) |
3 |
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:
[
11024
]
|
|
2.09 ms (0.09%) |
3 |
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:
[ 11024 0 ] |
|
1.73 ms (0.08%) |
6 |
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" 11024 ] |
|
1.43 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:
[ 11024 7 ] |
|
1.29 ms (0.06%) |
6 |
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"
]
|
|
1.12 ms (0.05%) |
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:
[ 11024 1 ] |
|
1.00 ms (0.04%) |
7 |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
|
0.77 ms (0.03%) |
3 |
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:
[ 11024 "C" ] |
|
0.75 ms (0.03%) |
3 |
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-15 12:37:45" "%2%" 11024 ] |
|
0.67 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:
[
199408
]
|
|
0.60 ms (0.03%) |
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:
[
11024
]
|
|
0.51 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:
[
"45201-n3-couleur-n-c-18000101099"
]
|
|
0.48 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 (NULL) AND p0_.is_active = 1 AND p0_.id <> ? AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 LIMIT 10
Parameters:
[
11024
]
|
|
0.46 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.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:
[
"45201-n3-couleur-n-c-18000101099"
]
|
|
0.37 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.discount AS discount_4, t0.product_id AS product_id_5 FROM promotion t0 WHERE t0.product_id = ?
Parameters:
[
70842
]
|
|
0.31 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:
[ 70842 9962915 ] |
|
0.23 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:
[
11024
]
|
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.