Query Metrics
158
Database Queries
24
Different statements
1770.52 ms
Query time
0
Invalid entities
2360
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
926.72 ms (52.34%) |
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:
[ 6384063 6385744 6384050 6381976 6377837 6386136 6386517 6386535 6386557 6382523 6380979 6394511 6394778 6395342 6396154 6396173 6396262 6396756 6399197 6400630 6403059 6403652 6403680 6404022 6404141 6407083 6407151 6407716 6407719 6408748 6410542 6410716 6411213 6411475 6411713 6413094 6416447 6416448 6416768 6416959 6417117 6417392 6417478 6417890 6418505 6419354 6419408 6419576 6419809 6419915 6420541 6420640 6420877 6421133 6421741 6421899 6421914 6421931 6421935 6422233 6422311 6422688 6424666 6425451 6425112 6426033 6426195 6426502 6428002 6428003 6428752 6430939 6431868 6434377 6433624 6434703 6434911 6435102 6435109 6435258 6435937 6437106 6437163 6437169 6437236 6437239 6437795 6439326 6439615 6439620 6439651 6440203 6440278 6441146 6441336 6441377 6441389 6441401 6444044 6444137 6444633 6445335 6445757 6446038 6446740 6446835 6447774 6449470 6449843 6449978 6450285 6450338 6450876 6450881 6450996 6450997 6450999 6451002 6451439 6452606 6452932 6452935 6453019 6453187 6453401 6454866 6455040 6455256 6455354 6455747 6455795 6456045 6462393 6463516 6464302 6464573 6466429 6469143 6470253 6470496 6474791 6475789 6477609 6480479 6480550 6480557 6480607 6481618 6481748 6481761 6483185 6483540 6483704 6487914 6488165 6488166 6488167 6488168 6488169 6488170 6488171 6488172 6488173 6488174 6488175 6488176 6488177 6488178 6488179 6488180 6488181 6488183 6488184 6488185 6488186 6488187 6488188 6488189 6488190 6488191 6488192 6488193 6488194 6488195 6488196 6488197 6488198 6488199 6488200 6488201 6488202 6488203 6488204 6488205 6488206 6488207 6488208 6488209 6488210 6488211 6488212 6488213 6488214 6488215 6488216 6488217 6488218 6488219 6488220 6488221 6488222 6488223 6488224 6488225 6488226 6488227 6488228 6488229 6488230 6488231 6488232 6488233 6488234 6488235 6488237 6488238 6488239 6488240 6488241 6488242 6488243 6488244 6488245 6488246 6488247 6489185 6489186 6489187 6489188 6489351 6489357 6489425 6489426 6489427 6489428 6489429 6489435 6489436 6489437 6489438 6489440 6489442 6489443 6489444 6489445 6489446 6489447 6489448 6489449 6489450 6489451 6489452 6489453 6489454 6489457 6489462 6489463 6489464 6489465 6489466 6489467 6489468 6489469 6489470 6489471 6489472 6489473 6489474 6490729 6492306 6492410 6492444 6492449 6492450 6492451 6492452 6492453 6492454 6492455 6492456 6492457 6492458 6492459 6492460 6492461 6492462 6492463 6492464 6492465 6492466 6492467 6492468 6492469 6492470 6492471 6492473 6492474 6492475 6492476 6492477 6492478 6492479 6492480 6492481 6492482 6492483 6492484 6492485 6492486 6492487 6492488 6492489 6492490 6492491 6492492 6492493 6492494 6492495 6492496 6492497 6492498 6492499 6492500 6492501 6492502 6492503 6492504 6492505 6492506 6492507 6492508 6492509 6492510 6492512 6492513 6492514 6492515 6492517 6492518 6492519 6492748 6492751 6492753 6492759 6492768 6492769 6492770 6492771 6492772 6492773 6492774 6492775 6492776 6492777 6492778 6492779 6492780 6492782 6492783 6492784 6492785 6492786 6492787 6492788 6492789 6492790 6492791 6492792 6492793 6492794 6492795 6492796 6492797 6492798 6492799 6492800 6492801 6492802 6492803 6492804 6493186 6494921 6494980 6495249 6495301 6495981 6496402 6497140 6497214 6497399 6498076 6498084 6498090 6498581 6499061 6499082 6499995 6499998 6501731 6501978 6502784 6503258 6503573 6504246 6504627 6505454 6505539 6506004 6506144 6507985 6507995 6507996 6507997 6507998 6507999 6508000 6508001 6508002 6508003 6508004 6508005 6508006 6508007 6508008 6508009 6508010 6508011 6508012 6508013 6508014 6508015 6508016 6508017 6508018 6508019 6508020 6508021 6508022 6508023 6508024 6508025 6508026 6508027 6508028 6508029 6508030 6508031 6508032 6508033 6508034 6508035 6508036 6508037 6508038 6508039 6508040 6508041 6508042 6508043 6508044 6508045 6508046 6508047 6508048 6508049 6508050 6508051 6508052 6508053 6508054 6508055 6508056 6508057 6508058 6508059 6508060 6508062 6508063 6508064 6508065 6508066 6508067 6508068 6508069 6508070 6508071 6508072 6508073 6508074 6508075 6508076 6508077 6509130 6509855 6509856 6509857 6509858 6509859 6509860 6509861 6509862 6509931 6509932 6509933 6509934 6509935 6509936 6509937 6510010 6510011 6510012 6510013 6510014 6510015 6510016 6510017 6510018 6510019 6510020 6510022 6510023 6510024 6510025 6510026 6510027 6510028 6510029 6510030 6510031 6510032 6510033 6510034 6510035 6510036 6510037 6510038 6510039 6510040 6510041 6510042 6510043 6510044 6510045 6510046 6510047 6510048 6510049 6510050 6510051 6510052 6510053 6510054 6510055 6510056 6510057 6510058 6510059 6510060 6510061 6510062 6510063 6510064 6510065 6510066 6510067 6510068 6510069 6510070 6510071 6510072 6510073 6510074 6510075 6510076 6510077 6510078 6510079 6510080 6510081 6510082 6510083 6510084 6510085 6510086 6510087 6510088 6510089 6510090 6510095 6510096 6510097 6510098 6510099 6510100 6510101 6510102 6510104 6510105 6510106 6510107 6510108 6510109 6510479 6512559 6515884 6515932 6516066 6516343 6516367 6516368 6516369 6516370 6516371 6516372 6516373 6516375 6516376 6516377 6516378 6516379 6516380 6516381 6516382 6516386 6516387 6516388 6516389 6516391 6516392 6516393 6516394 6516395 6516396 6516397 6516398 6516399 6516400 6516401 6516402 6516403 6516404 6516406 6516407 6516408 6516411 6516412 6516413 6516414 6516415 6517553 6517933 6517954 6518611 6519859 6520121 6521481 6521809 6522164 6522642 6522652 6522746 6524268 6524400 6524602 6524814 6524815 6524816 6524817 6524825 6526276 6526554 6526561 6526743 6527420 6528400 6528942 6529047 6529619 6529620 6529621 6529622 6529623 6529624 6529625 6529626 6529627 6529628 6529629 6529630 6529631 6529632 6529633 6529634 6529635 6529636 6529637 6529638 6529639 6529640 6529641 6529642 6529643 6529644 6529645 6529646 6529647 6529648 6529649 6529650 6529651 6529652 6529653 6529654 6529655 6529656 6529657 6529658 6529659 6529660 6529661 6529662 6529663 6529664 6529665 6529666 6529667 6529668 6529669 6529670 6529671 6529672 6529673 6529674 6529675 6529676 6529677 6529678 6529679 6529680 6529681 6529682 6529683 6529684 6529685 6529686 6529687 6529688 6529689 6529690 6529691 6529692 6529693 6529694 6529695 6529696 6529697 6529698 6529699 6529700 6529711 6529716 6529717 6529718 6529719 6530058 6530284 6530525 6530945 6531208 6531211 6531214 6531224 6531225 6531226 6531227 6531228 6531229 6532797 6533278 6534934 6536393 6538224 6541480 6542654 1000001346 1000001456 1000001349 6388954 1000002528 1000002419 1000002648 1000006058 1000006366 1000006367 1000006368 1000006369 1000006977 1000008019 1000008048 1000009359 1000004302 1000010358 1000010410 1000010411 1000010412 1000010413 1000010414 1000010415 1000010416 1000010419 1000010420 1000010437 6343241 1000012238 1000012262 1000015028 1000001135 1000015741 1000016178 1000016180 1000018908 1000018909 1000018912 1000018913 1000018977 1000018978 1000018979 1000018980 1000018981 1000018982 1000018983 1000018984 1000019756 1000020338 1000012314 1000015326 1000023038 1000023039 1000023040 1000023041 1000023042 1000023043 1000023044 1000023046 1000023047 1000023048 1000023049 1000023050 1000023051 1000023052 1000023053 1000023054 1000023056 1000023057 1000023058 1000023059 1000023060 1000023061 1000023062 1000023063 1000023065 1000023066 1000023067 1000023068 1000023069 1000023177 1000023178 1000023179 1000023180 1000023181 1000023182 1000023183 1000023184 1000023216 1000023220 1000023223 1000023225 1000023226 1000024004 1000024005 1000024006 1000024007 1000024044 1000024046 1000024100 1000024123 1000024134 1000024143 1000024148 1000024160 1000024163 1000024168 1000024169 1000024183 1000024184 1000024198 1000024199 1000024201 1000024203 1000024204 1000024205 1000024207 1000024208 1000024209 1000024210 1000024211 1000024212 1000024213 1000024215 1000024216 1000024217 1000024218 1000024219 1000024221 1000024222 1000024223 1000024224 1000024225 1000024243 1000024244 1000024247 1000024249 1000024250 1000024251 1000024252 1000024253 1000024255 1000024256 1000024257 1000024258 1000024259 1000024260 1000024261 1000024262 1000024263 1000024264 1000024265 1000024266 1000024267 1000024300 1000024301 1000024302 1000024303 1000024304 1000024308 1000024311 1000024312 1000024316 1000024317 1000024321 1000024325 1000024326 1000024327 1000024328 1000024329 1000024330 1000024331 1000024332 1000024333 1000024334 1000024353 1000025292 1000025293 1000025295 1000025307 1000025309 1000025313 1000025314 1000025318 1000025319 1000025320 1000025321 1000025322 1000025323 1000025324 1000025325 1000025326 1000025327 1000025328 1000025329 1000025330 1000025331 1000025332 1000025333 1000025334 1000025335 1000025336 1000025337 1000025338 1000025339 1000025340 1000025341 1000025342 1000025343 1000025344 1000025345 1000002074 1000016378 1000012798 1000012957 1000013934 1000014705 1000016216 1000027298 1000027300 1000027301 1000027302 1000027304 1000027306 1000027309 1000027310 1000027312 1000027315 1000027316 1000027317 1000027319 1000027320 1000027321 1000027322 1000027323 1000027324 1000027325 1000027326 1000027328 1000027330 1000027331 1000027333 1000027334 1000027335 1000027336 1000027338 1000027339 1000027341 1000027342 1000027343 1000027344 1000027362 1000027811 1000027812 1000027813 1000027814 1000027816 1000027817 1000027936 1000028144 1000028149 1000028150 1000028151 1000028153 1000028154 1000028161 1000028162 1000028163 1000028164 1000028165 1000028166 1000028167 1000028168 1000028169 1000028170 1000028171 1000028172 1000028173 1000028175 1000028176 1000028177 1000028179 1000028180 1000028181 1000028182 1000028407 1000028408 1000028409 1000028410 1000028411 1000028412 1000028414 1000028417 1000028429 1000028430 1000028432 1000028454 1000028456 1000028458 1000028460 1000028461 1000028462 1000028463 1000028464 1000028465 1000028466 1000028467 1000028494 1000028495 1000028496 1000028497 1000028498 1000028499 1000028500 1000028501 1000028502 1000028872 1000028873 1000028875 1000028876 1000028877 1000028878 1000028879 1000028880 1000028881 1000028882 1000028883 1000028884 1000010363 1000029211 1000029212 1000029213 1000029214 1000029215 1000029216 1000029433 1000013093 1000021416 1000031386 1000031389 1000031391 1000031394 1000031395 1000031398 1000031399 1000031400 1000031402 1000031404 1000031409 1000031411 1000031414 1000031415 1000031417 1000031419 1000020351 1000034746 1000034750 1000035432 1000035433 1000035434 1000035435 1000035436 1000035437 1000035438 1000035443 1000035444 1000035445 1000035446 1000035447 1000035448 1000035449 1000035450 1000035542 1000035543 1000035544 1000035546 1000035583 1000035584 1000036501 1000036503 1000036504 1000037935 1000037936 1000037937 1000037938 1000037939 1000037940 1000037941 1000037942 1000037943 1000037945 1000037946 1000037947 1000037948 1000037949 1000037950 1000037952 1000037953 1000037955 1000037956 1000037957 1000037958 1000037959 1000037960 1000037961 1000037962 1000038041 1000038043 1000038045 1000038047 1000038048 1000038049 1000038050 1000038051 1000038052 1000038055 1000038057 1000038058 1000038059 1000038060 1000038063 1000038064 1000038893 1000038894 1000038895 1000038896 1000038897 1000016485 1000040403 1000040405 1000040411 1000040413 1000040414 1000040415 1000040416 1000040418 1000040419 1000016436 1000040095 1000012483 1000036512 1000042188 1000042189 1000042868 1000042998 1000045800 1000047471 1000047473 1000047474 1000047490 1000048059 1000049496 1000049904 1000049334 1000050115 1000050116 1000050120 1000050695 1000051438 1000021337 1000052371 1000052658 1000050293 1000051603 1000053805 1000053808 1000053809 1000053810 1000054190 1000019932 1000054627 1000052567 1000055225 1000055277 1000055278 1000055412 1000055109 1000055926 1000056713 1000056714 1000056790 1000056712 1000058514 1000059278 1000059582 1000060507 1000059421 1000059821 1000059795 1000060592 1000060358 1000064899 1000065131 1000065103 1000066443 95978 ] |
|
623.10 ms (35.19%) |
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:
[ 95978 "2025-04-12 20:20:49" ] |
|
154.66 ms (8.74%) |
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:
[
"74691-stylos-billes-rouge-n-c-600453-m1-0"
]
|
|
13.24 ms (0.75%) |
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:
[
95978
]
|
|
8.47 ms (0.48%) |
14 |
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" 95978 ] |
|
7.27 ms (0.41%) |
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
]
|
|
5.90 ms (0.33%) |
7 |
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:
[ 95978 0 ] |
|
5.59 ms (0.32%) |
7 |
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:
[
95978
]
|
|
5.39 ms (0.30%) |
23 |
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"
]
|
|
3.45 ms (0.19%) |
14 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.affiliated_society AS affiliated_society_3, t0.address1 AS address1_4, t0.address2 AS address2_5, t0.address3 AS address3_6, t0.zip_code AS zip_code_7, t0.city AS city_8, t0.email AS email_9, t0.phone_number AS phone_number_10, t0.fax AS fax_11, t0.id_deposit AS id_deposit_12, t0.gen_code AS gen_code_13, t0.newspaper AS newspaper_14, t0.siren AS siren_15, t0.ape AS ape_16, t0.trading_registry AS trading_registry_17, t0.internal_tva AS internal_tva_18, t0.rib AS rib_19, t0.general_account AS general_account_20, t0.capital AS capital_21 FROM society t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"MOZ"
]
|
|
2.86 ms (0.16%) |
15 |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
|
2.60 ms (0.15%) |
7 |
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:
[ 95978 "C" ] |
|
2.51 ms (0.14%) |
6 |
SELECT d0_.quantity AS quantity_0, MIN(d0_.price_ht) AS sclr_1, MIN(d0_.price_ttc) AS sclr_2 FROM decreasing_price d0_ LEFT JOIN product p1_ ON d0_.product_id = p1_.id LEFT JOIN product_price p2_ ON d0_.product_price_id = p2_.id WHERE p1_.id = ? AND p2_.id = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC
Parameters:
[ 95978 9963780 ] |
|
2.10 ms (0.12%) |
7 |
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 20:20:50" "%2%" 95978 ] |
|
1.30 ms (0.07%) |
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:
[ 9616 7 ] |
|
1.22 ms (0.07%) |
6 |
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:
[
95976
]
|
|
0.83 ms (0.05%) |
1 |
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25 FROM product p0_ 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 290 95978 ] |
|
0.65 ms (0.04%) |
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:
[ 95978 1 ] |
|
0.55 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:
[
"74691-stylos-billes-rouge-n-c-600453-m1-0"
]
|
|
0.54 ms (0.03%) |
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.50 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.reference IN (?, ?, ?)
Parameters:
[ "74689" "74690" "74692" ] |
|
0.45 ms (0.03%) |
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:
[
"74691-stylos-billes-rouge-n-c-600453-m1-0"
]
|
|
0.34 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:
[
88140
]
|
|
0.27 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:
[
95978
]
|
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 | 1290 |
| App\Entity\Catalog\ProductCatalog | 240 |
| App\Entity\Catalog\CustomerCatalog | 240 |
| App\Entity\Customer\Customer | 122 |
| App\Entity\User\User | 98 |
| App\Entity\Delivery\Delivery | 94 |
| App\Entity\Product\ProductPrice | 59 |
| App\Entity\Pricing\Price | 51 |
| App\Entity\Product\Market | 45 |
| App\Entity\Internal\Commercial | 32 |
| App\Entity\Product\Product | 21 |
| App\Entity\Product\Category | 21 |
| App\Entity\Product\Characteristic | 17 |
| App\Entity\Product\CharacteristicLabel | 17 |
| App\Entity\Internal\Society | 5 |
| App\Entity\Delivery\DeliveryCost | 5 |
| App\Entity\Internal\Parameter | 3 |