Query Metrics
28
Database Queries
11
Different statements
1884.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
980.50 ms (52.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_ 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:
[ 6338249 6339982 6343217 6342903 6344371 6344447 6345112 6345174 6347754 6348789 6352838 6353373 6354735 6355577 6355585 6355618 6355641 6338769 6356631 6356729 6356771 6356803 6356806 6357367 6357519 6357536 6357663 6357942 6358176 6358178 6358230 6358996 6343914 6359218 6359628 6360059 6360157 6361248 6362978 6364027 6364118 6364522 6364752 6365985 6369317 6369319 6369965 6370371 6370395 6370530 6370537 6370547 6370551 6372051 6372053 6372369 6372374 6372420 6373330 6373365 6373370 6365015 6374812 6375256 6375785 6373889 6376425 6368818 6377453 6377772 6378950 6384757 6384823 6379676 6385338 6385849 6386745 6387289 6383791 6375767 6386706 6387139 6387750 6387876 6388152 6388207 6388271 6380678 6388017 6388459 6388480 6388581 6388730 6374299 6388962 6385288 6389065 6389069 6389179 6389302 6389461 6390145 6390511 6390555 6391060 6391257 6391323 6390607 6391474 6391475 6391526 6390106 6389026 6390792 6392027 6392049 6392151 6392349 6392395 6389573 6392745 6392862 6392929 6393520 6388629 6393734 6393348 6393915 6394229 6393601 6387546 6394511 6394532 6394683 6394713 6394935 6391308 6394970 6395085 6395238 6395409 6395753 6396102 6396362 6397232 6398164 6398551 6398707 6398847 6400446 6400516 6400563 6400630 6400727 6400732 6402149 6403038 6403331 6403402 6403495 6403714 6404344 6405415 6405422 6405472 6406127 6407120 6408056 6408706 6409567 6409608 6409678 6410539 6410678 6410708 6410717 6410867 6410894 6410914 6411011 6411105 6411403 6411729 6412054 6412163 6412171 6412172 6412194 6412215 6412209 6412635 6412665 6412694 6412742 6412907 6413068 6413172 6413317 6413371 6413560 6413592 6413661 6413695 6413697 6413717 6413770 6413816 6414000 6414280 6414293 6414315 6414542 6414544 6414609 6414685 6414730 6414750 6414897 6414993 6415038 6415072 6415107 6415151 6415154 6415509 6415714 6415730 6415820 6415833 6415949 6416013 6416035 6416038 6416112 6416134 6416153 6416191 6416205 6416217 6416239 6416269 6416814 6416836 6416877 6416947 6416950 6416957 6416979 6417012 6417042 6417103 6417288 6417444 6417554 6417597 6418171 6418172 6418526 6418545 6418843 6418893 6418915 6419188 6419236 6419239 6419243 6419272 6419273 6419285 6419319 6419350 6419354 6419355 6419391 6419540 6419552 6419574 6419914 6420628 6420630 6420658 6420661 6420868 6420877 6420906 6420949 6421284 6421292 6421623 6421690 6421741 6421855 6422649 6422993 6423128 6423686 6423712 6423809 6424264 6424405 6424727 6424815 6425027 6425090 6425186 6425191 6425305 6425388 6425450 6425565 6425568 6425577 6425538 6425702 6425775 6426117 6426321 6426399 6426408 6426425 6426443 6426450 6426524 6426611 6426812 6427067 6427165 6427189 6427223 6427269 6427285 6427329 6427424 6427558 6427743 6427771 6427938 6428170 6428183 6428232 6428316 6428321 6428425 6428474 6428505 6428590 6428745 6428783 6428927 6429236 6429620 6429629 6429659 6429856 6429887 6430400 6430534 6430633 6430798 6430965 6431147 6431198 6431258 6431470 6431506 6431529 6431541 6431679 6431672 6431714 6431995 6432046 6432165 6432213 6432221 6432240 6432272 6432619 6433845 6434067 6434103 6434162 6434228 6434288 6434384 6434423 6434484 6434622 6434647 6434674 6434700 6434747 6434757 6434789 6434795 6434833 6434859 6434876 6434891 6434932 6434967 6435081 6435101 6435181 6435206 6435242 6435252 6435298 6435301 6435488 6435917 6435961 6436064 6436442 6437030 6437084 6437581 6437674 6437714 6437726 6437793 6437988 6437994 6438044 6438045 6438061 6438094 6438096 6438503 6438554 6438688 6438766 6438805 6438818 6438825 6438828 6438831 6438849 6438890 6438899 6438913 6438986 6438979 6439076 6439263 6439266 6439269 6440026 6440170 6440819 6440846 6441051 6441180 6441243 6441261 6441304 6441439 6441575 6442221 6442246 6442728 6442769 6442789 6442806 6442885 6442976 6443053 6443119 6443487 6443728 6443855 6443935 6444102 6444641 6444643 6444653 6444750 6444758 6444853 6444857 6444922 6444967 6445002 6445017 6445146 6445244 6445378 6445560 6445638 6445642 6446086 6446113 6446139 6446390 6446428 6446483 6446658 6446743 6446755 6446779 6446861 6447017 6447076 6447257 6447376 6447431 6447674 6447697 6448697 6448776 6448814 6449029 6449361 6449470 6449588 6449703 6449725 6449761 6449770 6449834 6449836 6449885 6449897 6449912 6449958 6449979 6450168 6450172 6450183 6450198 6450199 6450268 6450270 6450274 6450496 6450640 6450698 6450766 6450870 6450961 6450969 6451025 6451041 6451066 6451072 6451086 6451088 6451094 6451104 6451151 6451214 6451236 6451248 6451252 6451281 6451285 6451330 6451338 6451346 6451390 6451398 6451437 6451512 6451561 6451591 6451666 6451707 6451803 6451825 6451834 6451880 6451884 6452000 6452007 6452010 6452023 6452026 6452039 6452040 6452041 6452042 6452051 6452099 6452236 6452247 6452264 6452301 6452314 6452320 6452332 6452358 6452367 6452394 6452410 6452483 6452570 6452590 6452609 6452614 6452830 6453154 6453471 6453481 6453482 6453501 6453517 6453659 6453674 6453836 6453868 6453869 6453881 6453890 6454024 6454025 6454180 6454181 6454185 6454533 6454534 6454535 6454536 6454537 6454586 6454620 6454690 6454733 6454742 6454758 6454783 6454787 6454794 6454795 6454829 6454842 6454848 6454855 6454897 6454926 6454982 6455138 6455150 6455166 6455196 6455198 6455199 6455244 6455282 6455345 6455354 6455416 6455419 6455423 6455443 6455453 6455469 6455490 6455508 6455517 6455519 6455521 6455546 6455551 6455557 6455561 6455617 6455626 6455628 6455683 6455688 6455698 6455700 6455702 6455716 6455747 6455785 6455787 6455835 6455884 6455955 6456089 6456103 6456112 6456264 6456293 6456467 6456560 6456787 6457052 6457064 6457206 6457245 6457263 6457415 6457427 6457437 6457440 6457443 6457520 6457534 6457538 6457645 6457720 6458657 6459200 6459546 6459638 6459709 6459884 6460126 6460141 6460156 6460208 6460222 6460997 6461315 6461316 6461320 6461336 6461395 6461450 6461568 6461619 6461645 6461681 6461710 6461828 6462118 6462861 6462886 6462965 6462996 6463332 6463333 6463334 6463335 6463336 6463337 6463338 6463339 6463340 6463341 6463343 6463344 6463345 6463346 6463347 6463348 6463349 6463350 6463351 6463352 6463353 6463401 6464021 6464264 6464275 6464303 6464664 6465172 6465575 6465826 6465906 6466495 6466761 6466778 6466851 6466864 6467882 6467883 6467884 6467885 6467886 6467887 6467888 6467889 6467890 6467891 6467892 6467893 6467894 6467895 6467896 6467897 6467898 6467900 6467901 6467902 6467903 6467904 6468056 1000001014 6393277 6393344 1000001549 1000001723 1000002291 1000002308 1000002307 1000000986 1000002399 1000002408 1000002472 1000002627 1000002193 1000002130 1000001024 6314823 1000004356 1000004597 1000004610 1000004747 1000000882 1000004357 1000004350 1000005292 1000005300 1000005564 1000005857 1000005377 1000005945 1000005946 1000005947 1000006096 1000006167 1000006175 1000006176 1000006298 1000006595 1000006606 1000006956 1000006989 6366500 1000007168 1000007176 1000007261 1000007262 6389526 1000007604 1000007186 1000007641 1000003838 1000003520 1000002495 1000008125 1000007905 1000008316 1000008317 1000008318 6393161 1000007976 1000008786 1000008861 6393248 1000001743 1000006984 1000004337 6356299 1000009304 6379629 6343957 1000006610 1000009312 1000009581 1000006858 1000009696 1000009721 1000002615 1000009809 1000004570 1000009968 1000005944 1000009165 1000009910 1000005293 1000007819 1000010110 1000008107 1000009858 1000008985 1000005033 1000010206 1000007460 1000009715 1000010427 1000010559 1000010052 1000010627 1000009615 1000010705 1000010591 1000010745 1000010607 1000011801 1000011880 1000011997 1000012130 1000012180 6343241 1000012283 1000012354 1000012380 1000009748 1000012262 1000012929 6390488 1000011022 1000012005 1000012768 1000012503 1000012453 1000010763 1000013376 1000012743 1000010819 1000014105 1000013589 1000012721 1000014515 1000014481 1000014633 1000014658 1000014802 1000009676 1000014936 1000014971 1000013475 1000012248 1000012647 1000008555 1000010100 1000010092 1000014692 1000015232 1000015233 1000015373 1000015374 1000014831 1000012761 1000015507 1000015509 1000011856 1000009775 1000015720 1000015721 1000006062 1000015746 1000015747 1000015818 1000012235 1000009705 1000014003 1000016053 6378345 1000009646 1000016155 1000016097 1000016764 1000016762 1000016869 1000016874 1000016876 1000016945 1000017123 1000017148 1000017208 1000017209 1000017210 1000017027 1000016984 1000001339 1000009771 1000016791 1000017453 1000017451 1000017508 1000017007 1000008325 1000009803 1000017694 1000017695 1000017728 1000017729 1000017740 1000017741 1000017744 1000017757 1000017776 1000017778 1000017806 1000017847 1000017891 1000017892 1000017897 1000017898 1000017904 1000017905 1000017906 1000017907 1000017908 1000017909 1000017910 1000017911 1000017912 1000017913 1000017914 1000017915 1000017916 1000017917 1000017918 1000017919 1000017920 1000017921 1000017922 1000017923 1000017924 1000017925 1000017926 1000017931 1000017960 1000017961 1000017962 1000017963 1000017965 1000017970 1000017977 1000017978 1000018030 1000017878 1000018118 1000018172 1000018173 1000018174 1000018175 1000018205 1000018206 1000018211 1000018213 1000018219 1000014675 1000015527 1000018591 1000018599 1000018611 1000018769 1000018782 1000018976 1000019037 1000019038 1000019041 1000019042 1000019070 1000019108 1000016449 1000019294 1000017704 1000016960 1000019500 1000019529 1000019531 1000019536 1000019549 1000019551 1000019575 1000019593 1000019625 1000020080 1000014519 1000016959 1000012402 1000020489 1000020490 1000012830 1000019069 1000021016 1000021018 1000021033 1000020007 1000010767 1000021662 1000021678 1000021746 1000021747 1000021753 1000021754 1000021755 1000021869 1000021892 1000021893 1000021776 1000021909 1000021910 1000021911 1000021912 1000021925 1000017163 1000002473 1000002206 1000003873 1000006074 1000022273 1000022284 1000022294 1000022326 1000022327 1000022328 1000022380 1000022413 1000022414 1000022415 1000022416 1000022417 1000022426 1000022437 1000014183 1000019402 1000017554 1000022722 1000009773 1000017087 1000022966 1000022990 1000022995 1000022997 1000022999 1000023005 1000023006 1000023008 1000015535 1000023034 1000023055 1000023064 1000023103 1000018126 6378270 1000023671 1000023718 1000023722 1000023725 1000023417 1000024039 1000024101 1000024469 1000024473 1000024479 1000024480 1000024496 1000024511 1000024512 1000024522 1000024523 1000024524 1000024525 1000024526 1000024527 1000024528 1000024529 1000024533 1000024535 1000024537 1000024538 1000024607 1000018873 1000024800 1000024801 1000024877 1000024878 1000024879 1000024880 1000024881 1000024999 1000025002 1000025041 1000025042 1000025046 1000025083 1000025091 1000025092 1000025093 1000025094 1000025095 1000025108 1000025113 1000025351 1000025372 1000025374 1000025376 1000025484 1000019629 1000025728 1000025939 1000025956 1000025957 1000020889 1000026129 1000026178 1000016926 1000026331 1000026334 1000026432 1000026434 1000026435 1000026436 1000016758 1000026482 1000026483 1000022522 1000021785 1000025122 1000023752 1000022447 1000026484 1000023091 1000027062 1000027065 1000027078 1000027083 1000027088 1000027089 1000027192 1000027250 1000027439 1000027674 1000027675 1000027679 1000027142 1000007576 1000027871 1000027872 1000027874 1000027887 1000027889 1000027891 1000012560 1000028391 1000028392 1000028394 1000028402 1000028403 1000028678 1000028706 1000028707 1000028709 1000028725 1000028757 1000028758 1000028759 1000028760 1000028768 1000028775 1000028789 1000015126 1000016054 1000014104 1000014049 1000029652 1000029658 1000026083 1000029854 1000027016 1000029895 1000015067 1000030022 1000030044 1000030048 1000025812 1000014410 1000027769 1000030413 1000030416 1000030419 1000010418 1000031332 1000031361 1000031365 1000031366 1000028296 1000031377 1000031378 1000031379 1000031381 1000031382 1000031383 1000031385 1000031392 1000031428 1000031467 1000031468 1000031472 1000031475 1000031476 1000031477 1000031478 1000031480 1000031502 1000031504 1000031506 1000031509 1000031526 1000031531 1000031532 1000031533 1000031546 1000031553 1000031558 1000031566 1000031567 1000031583 1000031585 1000031591 1000030047 1000031708 1000031875 1000031878 1000031932 1000031934 1000031985 1000031989 1000023685 1000032352 1000032356 1000032399 1000032403 1000032410 1000032413 1000032420 1000032432 1000032437 1000029721 1000032518 1000032525 1000022306 1000032529 1000025696 1000015682 1000032571 1000028397 1000032593 1000008763 1000024965 1000033314 1000033316 1000023086 1000023089 1000033345 1000033353 1000033366 1000033468 1000017152 1000018253 1000033631 1000021035 1000032020 1000033626 1000034029 1000034062 1000021719 1000034276 1000034277 1000034283 1000034294 1000034364 1000027352 1000026794 1000034476 1000014806 1000032596 1000026433 1000034689 1000017147 1000026785 1000034745 1000034756 1000034786 1000032483 1000002741 1000035205 1000035206 1000035207 1000035208 1000032789 1000015158 1000035501 1000035507 1000035508 1000035509 1000035511 1000035513 1000035520 1000035525 1000035534 1000034088 1000027017 1000023726 1000028710 1000031784 1000035526 1000037329 1000037826 1000037827 1000038226 1000038193 1000016968 1000038414 1000038419 1000038420 1000038422 1000038423 1000038424 1000038532 1000038533 1000038535 1000038576 1000038592 1000038599 1000038602 1000038612 1000038614 1000038619 1000038848 1000038890 1000038926 1000038937 1000038938 1000038953 1000038955 1000038956 1000038959 1000038964 1000039110 1000039112 1000039116 1000039179 1000039193 1000039210 1000039267 1000039738 1000039740 1000029363 1000040355 1000040356 1000040358 1000040368 1000040457 1000040476 1000040498 1000013484 1000040892 1000040904 1000040905 1000040911 1000040917 1000040920 1000040921 1000040923 1000040925 1000040926 1000040977 1000027462 1000041074 1000041075 1000009770 1000041118 1000041296 1000041312 1000041328 1000041329 1000041331 1000041478 1000040095 1000041504 1000041168 1000041587 1000041929 1000041933 1000041950 1000041953 1000042192 1000042194 1000042200 1000042207 1000042443 1000042444 1000042464 1000042466 1000042473 1000042475 1000042476 1000042478 1000042479 1000034456 1000042552 1000042553 1000042554 1000042584 1000040837 1000032533 1000042686 1000042708 1000038229 1000019856 1000025570 1000042964 1000042966 1000042969 1000042970 1000042971 1000043003 1000043004 1000043005 1000043006 1000043007 1000043008 1000043019 6394868 1000043093 1000043239 1000043271 1000043273 1000043565 1000043566 1000043248 1000035720 1000043648 1000043669 1000043672 1000043679 1000043681 1000043705 1000043833 1000043835 1000043836 1000043838 1000043839 1000043847 1000043851 1000044004 1000044005 1000044006 1000044010 1000044018 1000044022 1000044023 1000044030 1000044031 1000044032 1000044033 1000044140 1000044142 1000044147 1000044148 1000044150 1000044275 1000044336 1000044361 1000044387 1000044388 1000044467 1000044517 1000044587 1000044435 1000045059 1000045101 1000045109 1000045114 1000045120 1000045130 1000045132 1000045133 1000045134 1000045135 1000045218 1000045219 1000045220 1000045221 1000045222 1000045223 1000045238 1000045239 1000045294 1000045473 1000046051 1000046177 1000046182 1000046183 1000046184 1000046185 1000046187 1000046188 1000046189 1000046190 1000046196 1000046198 1000046203 1000046207 1000046244 1000046245 1000034739 1000036227 1000046409 1000046510 1000046511 1000046513 1000047013 1000047128 1000047129 1000047130 1000047018 1000047271 1000047274 1000047424 1000047422 1000047467 1000047483 1000047485 1000047539 1000047544 1000043611 1000038968 1000026446 1000047547 1000047741 1000032326 1000047769 1000047840 1000047785 1000047872 1000045301 1000047504 1000048072 1000012406 1000041047 1000048100 1000048121 1000048134 1000048097 1000048175 1000048120 1000044284 1000048268 1000048270 1000048271 1000048272 1000048296 1000041387 1000044034 1000048462 1000048471 1000048481 1000048290 1000048591 1000048592 1000048596 1000047904 1000045194 1000048652 1000048539 1000048628 1000048236 1000048248 1000048897 1000048957 1000048985 1000017981 1000024541 1000049349 1000049537 1000049675 1000049677 1000049751 1000049753 1000049121 1000049807 1000049830 1000049377 1000049971 1000049973 1000050030 1000050031 1000047363 1000050091 1000050115 1000050116 1000042940 1000050175 1000050176 1000050277 1000050285 1000050286 1000050252 1000050120 1000048192 1000050133 1000050578 1000016534 1000050619 1000050637 1000047122 1000047146 1000050708 1000050742 1000047929 1000049579 1000050999 1000051015 1000051018 1000051039 1000050978 1000048177 1000048685 1000046253 1000051264 1000050835 1000051314 1000051317 1000049689 1000051519 1000050510 1000051622 1000051630 1000051631 1000051654 1000051640 1000051761 1000051762 1000013023 1000049870 1000049911 1000052047 1000052183 1000052248 1000050278 1000051354 1000052409 1000051572 1000050159 1000049956 1000051047 1000052663 1000052736 1000052773 1000052807 1000052802 1000052775 1000052900 1000052423 1000052966 1000053021 1000052187 1000053037 1000053053 1000047586 1000052036 1000052261 1000046248 1000053275 1000053267 1000052727 1000053414 1000053416 1000037525 1000052013 1000052018 1000052134 1000053481 1000053488 80440 ] |
|
843.45 ms (44.76%) |
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:
[ 80440 "2025-02-12 08:17:42" ] |
|
53.75 ms (2.85%) |
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:
[
"68248-cahiers-polypro-couleur-n-c-68248-maju"
]
|
|
2.89 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.35 ms (0.07%) |
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:
[ 80440 1 ] |
|
0.73 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:
[ 41 189 190 191 192 193 194 195 191 80440 ] |
|
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 FROM product t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"68248-cahiers-polypro-couleur-n-c-68248-maju"
]
|
|
0.44 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.37 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:
[
"68248-cahiers-polypro-couleur-n-c-68248-maju"
]
|
|
0.28 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:
[
80440
]
|
|
0.22 ms (0.01%) |
1 |
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"
]
|
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.