Query Metrics
85
Database Queries
25
Different statements
1819.41 ms
Query time
0
Invalid entities
2447
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
904.83 ms (49.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:
[ 87304 "2025-04-13 02:56:27" ] |
|
782.56 ms (43.01%) |
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:
[ 6385023 6386174 6386917 6388163 6389034 6391268 6391129 6391504 6391585 6391692 6391960 6392128 6393180 6389080 6394593 6395075 6395647 6396510 6396797 6397399 6397709 6399526 6400515 6403542 6403662 6403702 6404211 6405430 6405885 6407114 1000002769 6407583 6409215 6410327 6410755 6411431 6412931 6413639 6413743 6413876 6414250 6414297 6414553 6414780 6414897 6414934 6415038 6415386 6415409 6417219 6417465 6418171 6418536 6418827 6418990 6419049 6419208 6419321 6419360 6419439 6419577 6419587 6419685 6420084 6420228 6420603 6420630 6420637 6420715 6421845 6421884 6422662 6422685 6423070 6423085 6423996 6424177 6424263 6424844 6425785 6426443 6426592 6426685 6427391 6427608 6428436 6428451 6428494 6428520 6428974 6429041 6429577 6430552 6430854 6430860 6430907 6431138 6431494 6432261 6433508 6434232 6434624 6434626 6434647 6435597 6435634 6435688 6435935 6435955 6437116 6437597 6438505 6439593 6439607 6440073 6440121 6440740 6440944 6440949 6441616 6441612 6442896 6443134 6443551 6443903 6444501 6444571 6444653 6445179 6445244 6445811 6445827 6447288 6447368 6447542 6447674 6447761 6448289 6449047 6449391 6449470 6449508 6449955 6450173 6450180 6450195 6450274 6450277 6450330 6450750 6450953 6451071 6451163 6451248 6451318 6451381 6451477 6451591 6451703 6452059 6452124 6452214 6452604 6452722 6453180 6453551 6454009 6454136 6454369 6454582 6454591 6454607 6454671 6454761 6454841 6454862 6454935 6455024 6455053 6455076 6455138 6455146 6455171 6455390 6455426 6455455 6455487 6455490 6455738 6455757 6455768 6455835 6455914 6455988 6456124 6456266 6456780 6457260 6457414 6457507 6457513 6457645 6457646 6457671 6457711 6457939 6458952 6460011 6460915 6461315 6461360 6461568 6461633 6462744 6462905 6462931 6463659 6464883 6465820 6465940 6466709 6467929 6468042 6468115 6468495 6468951 6469961 6470275 6470360 6470504 6470550 6471067 6471864 6472234 6472762 6472925 6473002 6475318 6475431 6476190 6476562 6476865 6477162 6477801 6477802 6477878 6477909 6478186 6478516 6479646 6480451 6481105 6481339 6481693 6481698 6481710 6482087 6482527 6483286 6483537 6483863 6484933 6484995 6485304 6485348 6485443 6485460 6485516 6485578 6485977 6486041 6486098 6486162 6486782 6486783 6486845 6488428 6488958 6490052 6490055 6490985 6491006 6491471 6491549 6491553 6492017 6492041 6492183 6494208 6494314 6494427 6495778 6496217 6496302 6496477 6496632 6496901 6496908 6497060 6497135 6497136 6497168 6497281 6497296 6497328 6497423 6497735 6498090 6498126 6498281 6498579 6498982 6499062 6499263 6499282 6499315 6499378 6499446 6499514 6499536 6499570 6500127 6500264 6500282 6500349 6500353 6500561 6500659 6501082 6501454 6501603 6501813 6501869 6501939 6501973 6502019 6502044 6502073 6502080 6502275 6502621 6502667 6502679 6502711 6503073 6503096 6503999 6504006 6504245 6504246 6504249 6504452 6504645 6504704 6506223 6506384 6507849 6508388 6509604 6510111 6510310 6511056 6512094 6512175 6512929 6513236 6515859 6518071 6518409 6518843 6518931 6518981 6521108 6521287 6521731 6521749 6523973 6523977 6524331 6524678 6524776 6524779 6525076 6525510 6525515 6525891 6526199 6526347 6526410 6526418 6526556 6527033 6527369 6527607 6528049 6528050 6528161 6528269 6528369 6528736 6528740 6528770 6528778 6528859 6528862 6528945 6529144 6529240 6529380 6529842 6529847 6529871 6529879 6529955 6529971 6530102 6530109 6530143 6530169 6530252 6530267 6530278 6530279 6530321 6530330 6530333 6530342 6530347 6530379 6530764 6530773 6530877 6530998 6532782 6532874 6533205 6533207 6533216 6534198 6534640 6535624 6535741 6535953 6535962 6537422 6537437 6537559 6537583 6538297 6538298 6538395 6538637 6539947 6539949 6539966 6540305 6540541 6540936 6541287 6541751 6541843 1000000891 6389017 6378986 1000002203 1000002802 1000000904 1000002890 1000001676 1000004051 1000004054 1000002774 1000005324 1000005928 1000006105 1000004059 1000006896 1000006983 1000008020 1000008497 1000008498 1000008723 1000008747 1000008751 1000008966 1000001939 1000006281 1000009572 1000009662 1000009809 1000005988 6388978 1000010494 1000009615 1000009972 1000010551 1000009248 6386560 1000011830 1000011922 1000012401 1000000800 1000012690 1000012693 1000013035 1000013167 1000009753 1000013399 1000008795 1000013875 1000013907 1000014153 1000014470 1000014576 1000014578 1000009230 1000005279 1000011856 1000015655 1000015675 1000009862 1000015861 1000015862 1000015863 1000013595 1000010519 1000002600 1000016251 1000016298 1000016299 1000016322 1000016323 1000016324 1000016325 1000016327 1000016328 1000016329 1000016330 1000016338 1000016339 1000016341 1000016342 1000016345 1000016347 1000016348 1000016349 1000016350 1000016351 1000016352 1000016364 1000016462 1000013050 1000017003 1000017444 1000016175 1000017121 1000017707 1000017709 1000017710 1000017712 1000017733 1000017739 1000017746 1000015947 1000011989 1000018947 1000016434 1000019455 1000019467 1000019473 1000019559 1000019576 1000019706 1000019714 1000020406 1000020490 1000019469 1000020875 1000021652 1000021654 1000021746 1000021747 1000021753 1000021754 1000021755 1000019095 1000002245 1000017086 1000022166 1000022167 1000012427 1000009633 1000016362 1000018112 1000016488 1000022703 1000020925 1000023260 1000023261 1000023298 1000023729 1000023730 1000023731 1000023732 1000023733 1000023757 1000023767 1000023786 1000023787 1000023902 1000024495 1000024511 1000024512 1000024522 1000024523 1000024524 1000024525 1000024526 1000024527 1000024528 1000024529 1000024533 1000024535 1000024537 1000024538 1000025715 1000012407 1000025951 1000025952 1000025960 1000021785 1000023771 1000027985 1000029210 1000029914 1000029869 1000030055 1000030066 1000026008 1000030624 1000030836 1000030837 1000030840 1000030845 1000030846 1000030848 1000030865 1000030906 1000017748 1000031713 1000031716 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 1000031781 1000031754 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 1000010615 1000021180 1000033055 1000033071 1000033072 1000033081 1000033092 1000033093 1000033099 1000033106 1000033163 1000033164 1000033165 1000033167 1000033168 1000033169 1000033170 1000033171 1000033172 1000033468 1000016318 1000033174 1000029887 1000034156 1000034157 1000034166 1000034167 1000034168 1000023904 1000006407 1000031774 1000034996 1000035005 1000035082 1000033641 1000035273 1000035788 1000035793 1000036141 1000036142 1000036143 1000036144 1000036145 1000036466 1000036468 1000036469 1000036470 1000032014 1000036802 1000036804 1000036806 1000036434 1000037706 1000037747 1000037766 1000037785 1000037793 1000037803 1000037804 1000038180 1000038181 1000038182 1000038183 1000038184 1000038185 1000038186 1000038191 1000038401 1000038402 1000038403 1000038797 1000038846 1000038847 1000038849 1000039015 1000039017 1000039019 1000039020 1000039023 1000039027 1000014103 1000012165 1000009770 1000041209 1000041211 1000041214 1000041216 1000041217 1000041218 1000041221 1000041222 1000041225 1000041226 1000041227 1000041441 1000040095 1000039089 1000041774 1000039265 1000042069 1000042072 1000042073 1000042144 1000042145 1000042152 1000042157 1000042158 1000042159 1000022240 1000042686 1000042904 1000025829 1000043281 1000044087 1000044213 1000044220 1000044228 1000044235 1000044237 1000044238 1000044240 1000044289 1000044390 1000044476 1000045524 1000010963 1000046049 1000041235 1000046356 1000046660 1000046674 1000046939 1000046944 1000046945 1000046946 1000046947 1000046950 1000046953 1000046955 1000046968 1000047025 1000047168 1000047171 1000047172 1000047174 1000047175 1000047176 1000047191 1000047194 1000047217 1000047218 1000047219 1000047220 1000047221 1000047225 1000047237 1000047243 1000047248 1000047259 1000047583 1000047549 1000037770 1000048048 1000048175 1000048186 1000048202 1000048203 1000048205 1000048207 1000047196 1000048387 1000048389 1000048738 1000048778 1000047247 1000049146 1000024541 1000048943 1000049321 1000049515 1000049320 1000032163 1000049555 1000046113 1000048977 1000020466 1000050339 1000050386 1000050501 1000050872 1000051039 1000051223 1000051244 1000051277 1000042567 1000051340 1000051224 1000051357 1000051564 1000050609 1000051635 1000051849 1000012694 1000052011 1000052039 1000047976 1000052384 1000052402 1000052461 1000052467 1000052760 1000052772 1000052903 1000052499 1000048794 1000053122 1000053152 1000052996 1000053241 1000053466 1000053067 1000052895 1000053818 1000053849 1000053819 1000050765 1000054279 1000054404 1000054446 1000054489 1000054073 1000051299 1000054838 1000055021 1000055077 1000055143 1000055145 1000054961 1000050027 1000054530 1000055291 1000051883 1000053854 1000055713 1000056558 1000056723 1000055213 1000056947 1000056977 1000056978 1000049273 1000056866 1000057434 1000057471 1000057472 1000057847 1000054354 1000058261 1000058271 1000058709 1000058860 1000059848 1000060226 1000059470 1000060655 1000060914 1000060915 1000051447 1000061119 1000061150 1000061118 1000061294 1000061497 1000061691 1000037749 1000062417 1000062615 1000063205 1000063463 1000063464 1000062604 1000051989 1000064003 1000064022 1000064023 1000064359 1000064541 1000064741 1000064748 1000064975 1000062627 1000065251 1000065267 1000064255 1000065455 1000065573 1000065576 1000065577 1000065247 1000065640 1000065330 1000066026 1000065651 1000009054 1000066428 1000066429 1000066451 87304 ] |
|
105.82 ms (5.82%) |
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:
[
"70366-stylos-feutres-et-rollers-assorties-paper-mate-286460"
]
|
|
7.66 ms (0.42%) |
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:
[
87304
]
|
|
2.80 ms (0.15%) |
18 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
1
]
|
|
1.78 ms (0.10%) |
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:
[ 237 0 ] |
|
1.64 ms (0.09%) |
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.61 ms (0.09%) |
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:
[
237
]
|
|
1.42 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" 237 ] |
|
1.11 ms (0.06%) |
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.reference IN (?, ?, ?, ?)
Parameters:
[ "01520" "01521" "01522" "01523" ] |
|
1.09 ms (0.06%) |
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-13 02:56:29" "%2%" 237 ] |
|
0.90 ms (0.05%) |
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.78 ms (0.04%) |
5 |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
|
0.72 ms (0.04%) |
1 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_id AS product_id_3, t0.characteristic_label_id AS characteristic_label_id_4 FROM characteristic t0 WHERE t0.product_id = ? AND t0.characteristic_label_id = ? LIMIT 1
Parameters:
[ 5480 7 ] |
|
0.69 ms (0.04%) |
1 |
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25 FROM product p0_ LEFT JOIN product_category p2_ ON p0_.id = p2_.product_id LEFT JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.is_active = 1 AND p0_.id <> ? AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 LIMIT 10
Parameters:
[ 60 287 288 289 290 291 292 293 294 292 87304 ] |
|
0.58 ms (0.03%) |
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:
[ 237 "C" ] |
|
0.56 ms (0.03%) |
1 |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.manufacturer AS manufacturer_3, t0.short_label AS short_label_4, t0.long_label AS long_label_5, t0.weight AS weight_6, t0.sold_by AS sold_by_7, t0.ppht AS ppht_8, t0.ppttc AS ppttc_9, t0.paht AS paht_10, t0.pattc AS pattc_11, t0.legal_discount_library AS legal_discount_library_12, t0.fidelity_bonus AS fidelity_bonus_13, t0.brand AS brand_14, t0.time_limit AS time_limit_15, t0.coef AS coef_16, t0.is_discountable AS is_discountable_17, t0.is_btob AS is_btob_18, t0.is_btoc AS is_btoc_19, t0.is_customizable AS is_customizable_20, t0.is_library AS is_library_21, t0.is_nathan AS is_nathan_22, t0.is_green AS is_green_23, t0.is_orapi_grand_frais AS is_orapi_grand_frais_24, t0.is_active AS is_active_25, t0.slug AS slug_26, t27.id AS id_28, t27.min_qty AS min_qty_29, t27.max_qty AS max_qty_30, t27.step_qty AS step_qty_31, t27.product_id AS product_id_32 FROM product t0 LEFT JOIN product_rule t27 ON t27.product_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
"70366-stylos-feutres-et-rollers-assorties-paper-mate-286460"
]
|
|
0.42 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:
[
"70366-stylos-feutres-et-rollers-assorties-paper-mate-286460"
]
|
|
0.41 ms (0.02%) |
1 |
SELECT c0_.id AS id_0, c0_.value AS value_1, c1_.id AS id_2, c1_.list_order AS list_order_3, c1_.is_display_site AS is_display_site_4, c1_.is_search_site AS is_search_site_5, c1_.label AS label_6, c0_.product_id AS product_id_7, c0_.characteristic_label_id AS characteristic_label_id_8 FROM characteristic c0_ INNER JOIN characteristic_label c1_ ON c0_.characteristic_label_id = c1_.id WHERE c0_.product_id = ? AND c1_.is_display_site = ?
Parameters:
[ 87304 1 ] |
|
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:
[
237
]
|
|
0.35 ms (0.02%) |
2 |
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:
[
203912
]
|
|
0.35 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.33 ms (0.02%) |
1 |
SELECT d0_.quantity AS quantity_0, MIN(d0_.price_ht) AS sclr_1, MIN(d0_.price_ttc) AS sclr_2 FROM decreasing_price d0_ LEFT JOIN product p1_ ON d0_.product_id = p1_.id LEFT JOIN product_price p2_ ON d0_.product_price_id = p2_.id WHERE p1_.id = ? AND p2_.id = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC
Parameters:
[ 237 9955416 ] |
|
0.32 ms (0.02%) |
1 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_id AS product_id_3, t0.characteristic_label_id AS characteristic_label_id_4 FROM characteristic t0 WHERE t0.product_id = ?
Parameters:
[
87304
]
|
|
0.31 ms (0.02%) |
1 |
SELECT d0_.quantity AS quantity_0, MIN(d0_.price_ht) AS sclr_1, MIN(d0_.price_ttc) AS sclr_2 FROM decreasing_price d0_ LEFT JOIN product p1_ ON d0_.product_id = p1_.id LEFT JOIN product_price p2_ ON d0_.product_price_id = p2_.id WHERE p1_.id = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC
Parameters:
[
5480
]
|
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 | 1017 |
| App\Entity\Customer\Customer | 324 |
| App\Entity\User\User | 245 |
| App\Entity\Delivery\Delivery | 233 |
| App\Entity\Catalog\ProductCatalog | 157 |
| App\Entity\Catalog\CustomerCatalog | 157 |
| App\Entity\Product\Market | 75 |
| App\Entity\Product\ProductPrice | 51 |
| App\Entity\Pricing\Price | 49 |
| App\Entity\Internal\Commercial | 43 |
| App\Entity\Product\Product | 25 |
| App\Entity\Product\Category | 21 |
| App\Entity\Product\Characteristic | 17 |
| App\Entity\Product\CharacteristicLabel | 17 |
| App\Entity\Delivery\DeliveryCost | 6 |
| App\Entity\Internal\Society | 5 |
| App\Entity\Internal\Parameter | 3 |
| App\Entity\Pricing\Promotion | 1 |
| App\Entity\Pricing\SocietyPromotion | 1 |