Query Metrics
65
Database Queries
20
Different statements
2413.62 ms
Query time
0
Invalid entities
2949
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1215.88 ms (50.38%) |
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:
[ 6384734 6378967 6383123 6387454 6389019 6389051 6388915 6375698 6390440 6390558 6390561 6391258 6391363 6391500 6391112 6392140 6392440 6392549 6391120 6391102 6392314 6365569 6393669 6393295 6394311 6389080 6394447 6394731 6393897 6397009 6397577 6399744 6399981 6400202 6400469 6400515 6400690 6400764 6401946 6401956 6402404 6402615 6404586 6404608 6405442 6405686 6407025 1000002769 6407981 6408249 6409215 6409192 6409639 6409642 6410000 6410013 6410684 6410717 6410912 6411154 6411592 6411632 6413281 6413491 6413655 6414306 6414998 6415013 6415154 6415389 6415817 6415957 6416113 6416119 6416717 6416950 6416987 6417102 6417225 6417282 6417285 6417538 6417578 6417871 6418007 6418175 6418536 6418984 6418990 6419014 6419203 6419252 6419273 6419300 6419307 6419321 6419333 6419342 6419362 6419494 6419543 6419839 6420223 6420549 6420552 6420659 6420949 6421050 6421695 6422043 6422050 6422696 6422808 6422968 6423689 6423875 6424020 6424070 6424765 6425068 6425191 6425308 6425344 6425388 6426116 6426173 6426179 6425131 6426247 6426425 6426566 6426651 6426864 6426980 6427758 6428258 6428313 6428672 6428908 6429190 6429484 6429813 6430682 6430854 6430938 6431080 6431244 6431283 6431476 6431570 6431586 6431732 6431890 6431978 6432172 6432239 6432240 6432244 6432274 6432301 6433815 6434335 6434600 6434737 6435356 6435470 6435879 6436064 6436090 6436579 6436775 6437041 6437116 6437227 6437784 6438011 6438035 6438067 6438259 6439253 6439606 6439637 6439663 6440089 6440363 6440819 6440826 6441074 6441257 6441371 6441612 6441863 6442660 6442728 6442762 6442769 6443119 6443380 6443439 6443952 6444054 6444274 6444324 6445024 6445074 6445288 6445330 6445375 6445775 6446056 6446090 6446366 6446605 6446619 6446641 6446680 6446691 6447441 6447457 6447476 6447560 6447694 6448686 6448952 6448960 6449401 6449555 6449642 6449781 6450173 6450177 6450180 6450182 6450195 6450405 6450435 6450447 6450522 6450531 6450547 6450602 6450606 6450745 6450754 6450766 6450861 6450874 6450961 6451030 6451045 6451077 6451088 6451104 6451122 6451137 6451219 6451240 6451244 6451252 6451320 6451404 6451436 6451461 6451558 6451650 6451794 6451837 6452216 6452221 6452223 6452430 6452534 6452537 6452570 6452576 6452830 6452902 6453674 6453731 6453842 6453861 6453932 6454020 6454364 6454365 6454546 6454761 6454899 6454917 6454926 6454979 6454984 6455002 6455054 6455332 6455409 6455422 6455473 6455475 6455490 6455551 6455698 6455768 6455827 6455842 6456110 6456562 6456791 6457057 6457229 6457284 6457535 6457646 6458988 6459211 6459374 6459500 6459705 6460021 6460216 6461025 6462289 6462770 6462931 6463149 6463937 6464013 6464073 6464211 6464294 6464439 6464604 6466050 6466663 6466864 6468053 6469112 6469262 6469420 6470113 6470495 6470501 6470558 6470682 6470886 6470913 6471983 6471997 6472446 6472639 6472777 6472875 6474451 6474791 6476063 6476378 6476433 6476502 6476612 6477800 6478129 6480462 6480481 6480629 6480700 6480817 6481080 6481877 6481885 6483269 6483452 6483494 6483994 6484000 6484027 6484520 6484605 6484941 6485251 6485458 6485520 6485551 6485561 6485652 6485931 6486003 6486040 6486584 6486637 6486856 6487190 6488304 6488370 6488376 6488387 6488391 6488513 6489054 6489082 6489089 6489944 6490980 6491819 6492199 6492324 6492938 6493093 6494359 6494360 6494678 6494703 6494847 6495355 6495651 6496180 6496600 6496794 6497423 6497427 6497434 6497584 6497659 6497716 6497772 6497951 6498054 6498070 6498142 6498162 6498251 6498259 6498270 6498294 6498359 6498489 6498631 6498688 6498814 6499124 6499146 6499263 6499272 6499316 6499383 6499590 6499662 6500085 6500153 6500214 6500449 6500555 6500850 6501224 6501456 6501641 6501697 6501813 6501860 6501865 6501975 6502008 6502082 6502316 6502359 6502534 6502748 6503560 6503601 6503831 6504038 6504208 6504246 6504249 6504288 6504289 6504389 6505482 6505967 6506137 6506148 6506213 6506327 6506346 6506476 6506666 6506669 6507490 6507494 6507568 6507831 6507922 6508423 6508807 6508988 6509016 6509322 6509329 6509337 6509397 6509640 6510471 6510729 6510982 6511046 6511047 6511243 6512155 6512495 6512508 6512618 6512719 6512781 6515327 6515409 6517037 6518637 6519002 6519190 6519585 6520893 6521150 6521367 6521892 6522352 6522974 6523967 6523975 6524275 6524290 6524407 6524411 6524420 6524423 6524427 6524429 6524441 6524450 6524533 6524582 6525124 6525279 6525369 6525375 6525377 6525424 6525427 6525494 6525511 6525801 6525827 6525855 6525856 6526029 6526195 6526201 6526213 6526353 6526370 6526562 6526727 6527402 6527610 6527630 6527632 6527637 6527639 6527747 6528091 6528097 6528109 6528132 6528180 6528246 6528767 6528770 6529048 6529217 6529276 6529277 6529315 6529343 6529409 6529415 6529844 6529868 6529879 6529981 6529993 6530078 6530079 6530102 6530114 6530143 6530208 6530258 6530277 6530332 6530340 6530343 6530363 6530537 6530571 6530998 6532650 6532739 6532767 6533155 6533211 6533221 6533273 6535610 6535667 6535674 6535953 6535959 6535961 6536044 6536210 6537479 6537480 6537559 6537565 6537572 6538494 6538728 6538730 6539440 6539778 6539947 6539966 6540232 6540317 6540962 6541195 6542224 6542294 6388461 1000000837 6388477 1000001928 1000002137 1000002543 1000000976 1000002764 1000001987 1000003689 6381437 1000004338 6387473 1000005324 1000002382 1000002239 1000005521 1000006989 1000006065 1000005019 1000001931 1000007755 1000007912 1000008332 1000009596 1000009696 1000009281 1000009858 1000002032 1000010556 1000010648 1000010700 1000010701 1000010980 1000010703 1000012018 1000010953 1000012535 1000011864 1000012991 1000012172 1000013520 1000013591 1000013650 1000005983 1000013742 1000014037 1000012923 1000014773 1000014774 1000014797 1000012248 1000010100 1000013586 1000012236 1000009163 1000015315 1000015316 1000013925 1000014870 1000015174 1000009861 1000010834 1000014003 1000016105 1000016193 1000013469 1000016284 1000016286 1000016298 1000016299 1000016322 1000016323 1000016324 1000016325 1000016327 1000016328 1000016329 1000016330 1000016338 1000016339 1000016341 1000016342 1000016345 1000016347 1000016348 1000016349 1000016350 1000016351 1000016352 1000016630 1000016889 1000016933 1000017102 1000017526 1000017544 1000017707 1000017709 1000017710 1000017712 1000017733 1000017739 1000017746 1000017968 1000015332 1000018134 1000018137 1000018138 1000018139 1000018143 1000018144 1000018146 1000018474 1000018504 1000018561 1000018562 1000018641 1000018643 1000016969 1000018869 1000018870 1000018871 1000018872 1000018879 1000018891 1000018919 1000018945 1000018968 1000018969 1000018994 1000018996 1000018998 1000018999 1000019186 1000019187 1000019233 1000019235 1000019237 1000019243 1000019277 1000019281 1000019282 1000019299 1000019302 1000019305 1000019308 1000019318 1000019344 1000019371 1000019379 1000019380 1000019388 1000019393 1000019397 1000019398 1000019400 1000019415 1000019442 1000019481 1000019482 1000009571 1000019499 1000019501 1000019503 1000019589 1000019612 1000019804 1000019913 1000019915 1000019931 1000019949 1000019950 1000019966 1000019974 1000019995 1000020103 1000020241 1000020242 1000020247 1000020296 1000020300 1000020002 1000020439 1000014848 1000019489 1000021407 1000019270 1000010767 1000021773 1000000909 1000000901 1000022070 1000022073 1000022074 1000022075 1000022076 1000022077 1000022078 1000022083 1000022084 1000022085 6384170 1000019604 1000010604 1000016362 1000017422 1000022517 1000018950 1000009843 1000016655 1000024467 1000024502 1000024503 1000016439 1000025315 1000025715 1000012407 1000020889 1000026188 1000019352 1000026347 1000026351 1000026352 1000026353 1000016842 1000026463 1000016015 1000026905 1000026916 1000026917 1000026918 1000026920 1000026922 1000026924 1000026939 1000026953 1000026958 1000026959 1000014853 1000014579 1000018257 1000028576 1000028671 1000028673 1000015027 1000030202 1000030659 1000030664 1000030669 1000030671 1000030674 1000030677 1000030678 1000030679 1000030689 1000028675 1000031277 1000031282 1000017748 1000028676 1000016954 1000012435 1000032237 1000032239 1000032248 1000032249 1000032250 1000032359 1000032452 1000032466 1000032467 1000032468 1000032481 1000032495 1000032506 1000032507 1000032513 1000032699 1000032711 1000032715 1000032723 1000018130 1000033094 1000033095 1000033217 1000033220 1000005600 1000033103 1000033458 1000033504 1000033511 1000020299 1000033531 1000033532 1000033533 1000033535 1000033536 1000033537 1000033538 1000033539 1000033540 1000033545 1000033546 1000033547 1000033548 1000033549 1000026225 1000022198 1000032774 1000021719 1000034589 1000027529 1000019539 1000034709 1000002741 1000030602 1000028580 1000012637 1000035668 1000014560 1000036255 1000034234 1000036384 1000036965 1000036966 1000036967 1000036972 1000036982 1000036988 1000036991 1000036994 1000036995 1000036996 1000036997 1000036998 1000036999 1000037000 1000037001 1000037002 1000037003 1000037004 1000038143 1000038349 1000038350 1000038404 1000038405 1000038409 1000038410 1000038427 1000038429 1000038438 1000038528 1000038530 1000038548 1000038558 1000038560 1000038564 1000038574 1000038577 1000038720 1000039118 1000039329 1000039661 1000039667 1000039668 1000039669 1000039671 1000039672 1000039673 1000039678 1000039679 1000039680 1000039682 1000039683 1000039684 1000039685 1000039724 1000039725 1000039727 1000039738 1000039740 1000039777 1000040037 1000040066 1000040067 1000040069 1000040070 1000040071 1000040072 1000040073 1000040074 1000040077 1000040401 1000040828 1000040831 1000040909 1000040913 1000040926 1000040933 1000022526 1000041451 1000036577 1000042584 1000027618 1000016888 1000042942 1000043244 1000043247 1000043249 1000043250 1000043251 1000043253 1000043279 1000044140 1000044142 1000044147 1000044148 1000044150 1000044177 1000044211 1000044216 1000044219 1000044221 1000044222 1000044275 1000044292 1000044318 1000044336 1000044344 1000016576 1000044376 1000038585 1000044389 1000044396 1000044400 1000031882 1000044519 1000044534 1000044541 1000044561 1000039739 1000045262 1000045264 1000045416 1000045424 1000045436 1000045522 1000046052 1000046100 1000046353 1000046403 1000046404 1000046724 1000046725 1000046729 1000046732 1000046733 1000046735 1000046738 1000046739 6363195 1000047065 1000047066 1000047067 1000047068 1000047069 1000047070 1000047071 1000047341 1000047357 1000047361 1000047624 1000028253 1000047863 1000047864 1000047886 1000036563 1000047941 1000048101 1000048102 1000048103 1000047255 1000048189 1000048249 1000048164 1000048304 1000048315 1000048316 1000025269 1000048553 1000044992 1000048594 1000048803 1000048975 1000038556 1000040215 1000049226 1000001548 1000049555 1000041064 1000049639 1000049787 1000049853 1000049898 1000032909 1000049922 1000050335 1000050336 1000008587 1000050504 1000050551 1000050368 1000050161 1000050727 1000050732 1000043020 1000050695 1000050977 1000050234 1000051079 1000050964 1000051376 1000051576 1000051718 1000051728 1000051871 1000051065 1000052028 1000052082 1000050594 1000048311 1000049720 1000052368 1000052381 1000049637 1000052588 1000017969 1000052724 1000051996 1000052041 1000010492 1000052859 1000050357 1000052915 1000052940 1000052949 1000053024 1000053025 1000052914 1000053027 1000053063 1000048053 1000053104 1000048580 1000053333 1000053365 1000053398 1000053577 1000053614 1000053615 1000053619 1000051700 1000052726 1000053832 1000053837 1000052334 1000053932 1000053997 1000054034 1000050749 1000006965 1000054261 1000054282 1000054465 1000054503 1000054572 1000054579 1000054544 1000054848 1000054952 1000054955 1000053834 1000055042 1000048597 1000055196 1000055197 1000054240 1000047364 1000054039 1000055375 1000054774 1000055005 1000048691 1000053277 1000055611 1000056097 1000056262 1000056338 1000056408 1000056410 1000056458 1000056610 1000056764 1000056719 1000057028 1000034018 1000050104 1000057042 1000057043 1000053452 1000057131 1000056665 1000055043 1000046405 1000055273 1000057464 1000054938 1000057690 1000057842 1000057808 1000058153 1000057127 1000058832 1000058436 1000059536 1000059519 1000059763 1000051719 1000060188 1000060460 1000060072 1000059674 1000060791 1000059920 1000059243 1000061289 1000058146 1000052782 1000043242 1000059327 1000062307 1000047415 1000063062 1000063077 1000015844 1000062880 1000063246 1000063330 1000057868 1000063204 1000063896 1000064124 1000064138 1000064684 1000064696 1000064704 1000065116 1000064043 1000065000 1000065321 1000065417 1000065486 1000065520 1000065425 1000064103 1000066064 1000066395 1000066405 1000060313 1000063218 1000066462 60386 ] |
|
1074.50 ms (44.52%) |
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:
[ 60386 "2025-04-12 21:59:57" ] |
|
107.99 ms (4.47%) |
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:
[
"56103-papier-de-couleur-assorties-clairefontaine-1703"
]
|
|
3.92 ms (0.16%) |
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:
[
60386
]
|
|
2.83 ms (0.12%) |
18 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
1
]
|
|
1.23 ms (0.05%) |
1 |
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:
[ 60386 0 ] |
|
1.13 ms (0.05%) |
1 |
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:
[
60386
]
|
|
0.98 ms (0.04%) |
5 |
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"
]
|
|
0.74 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.price_id = ? AND t0.product_id = ? LIMIT 1
Parameters:
[ "CAISSE2011" 60386 ] |
|
0.66 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:
[ 44 210 211 212 213 214 215 213 60386 ] |
|
0.57 ms (0.02%) |
1 |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.manufacturer AS manufacturer_3, t0.short_label AS short_label_4, t0.long_label AS long_label_5, t0.weight AS weight_6, t0.sold_by AS sold_by_7, t0.ppht AS ppht_8, t0.ppttc AS ppttc_9, t0.paht AS paht_10, t0.pattc AS pattc_11, t0.legal_discount_library AS legal_discount_library_12, t0.fidelity_bonus AS fidelity_bonus_13, t0.brand AS brand_14, t0.time_limit AS time_limit_15, t0.coef AS coef_16, t0.is_discountable AS is_discountable_17, t0.is_btob AS is_btob_18, t0.is_btoc AS is_btoc_19, t0.is_customizable AS is_customizable_20, t0.is_library AS is_library_21, t0.is_nathan AS is_nathan_22, t0.is_green AS is_green_23, t0.is_orapi_grand_frais AS is_orapi_grand_frais_24, t0.is_active AS is_active_25, t0.slug AS slug_26, t27.id AS id_28, t27.min_qty AS min_qty_29, t27.max_qty AS max_qty_30, t27.step_qty AS step_qty_31, t27.product_id AS product_id_32 FROM product t0 LEFT JOIN product_rule t27 ON t27.product_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
"56103-papier-de-couleur-assorties-clairefontaine-1703"
]
|
|
0.44 ms (0.02%) |
2 |
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.43 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:
[ 60386 1 ] |
|
0.43 ms (0.02%) |
3 |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
|
0.36 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:
[
"56103-papier-de-couleur-assorties-clairefontaine-1703"
]
|
|
0.34 ms (0.01%) |
1 |
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:
[ 60386 "C" ] |
|
0.33 ms (0.01%) |
1 |
SELECT d0_.quantity AS quantity_0, MIN(d0_.price_ht) AS sclr_1, MIN(d0_.price_ttc) AS sclr_2 FROM decreasing_price d0_ LEFT JOIN product p1_ ON d0_.product_id = p1_.id LEFT JOIN product_price p2_ ON d0_.product_price_id = p2_.id WHERE p1_.id = ? AND p2_.id = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC
Parameters:
[ 60386 9961938 ] |
|
0.30 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:
[
60386
]
|
|
0.29 ms (0.01%) |
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.27 ms (0.01%) |
1 |
SELECT p0_.id AS id_0, p0_.label_reduction AS label_reduction_1, p0_.description_reduction AS description_reduction_2, p0_.product_id AS product_id_3, p0_.operation_id AS operation_id_4 FROM product_reduction_label p0_ INNER JOIN operation o1_ ON p0_.operation_id = o1_.id WHERE o1_.is_active = 1 AND o1_.end_date >= ? AND o1_.is_active = 1 AND o1_.view_by LIKE ? AND p0_.product_id = ?
Parameters:
[ "2025-09-12 21:59:59" "%2%" 60386 ] |
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 | 1307 |
| App\Entity\Customer\Customer | 426 |
| App\Entity\User\User | 331 |
| App\Entity\Delivery\Delivery | 295 |
| App\Entity\Catalog\ProductCatalog | 147 |
| App\Entity\Catalog\CustomerCatalog | 147 |
| App\Entity\Product\Market | 64 |
| App\Entity\Pricing\Price | 51 |
| App\Entity\Product\ProductPrice | 49 |
| App\Entity\Internal\Commercial | 40 |
| App\Entity\Product\Product | 21 |
| App\Entity\Product\Category | 21 |
| App\Entity\Product\Characteristic | 19 |
| App\Entity\Product\CharacteristicLabel | 18 |
| App\Entity\Internal\Society | 5 |
| App\Entity\Delivery\DeliveryCost | 5 |
| App\Entity\Internal\Parameter | 3 |