Symfony Profiler

Query Metrics

28 Database Queries

11 Different statements

2047.21 ms Query time

0 Invalid entities

Grouped Statements

Time▼	Count	Info
1171.89 ms (57.24%)	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: [6343257 6345227 6346002 6346718 6347767 6349572 6353912 6354133 6355315 6356906 6357918 6357966 6358125 6358230 6362322 6363785 6364027 6364694 6364830 6365059 6365080 6365102 6365949 6367441 6367442 6368859 6370233 6371245 6372087 6377010 6352574 6381624 6382928 6382118 6381725 6366688 6380834 6386872 6387230 6365663 6388014 6388303 6388460 6388524 6388552 6389120 6389553 6390348 6391444 6392489 6392505 6394022 6394345 6396240 6396336 6398605 6400742 6400794 6401429 6402611 6403262 6403662 6405136 6405445 6405911 6406415 6406625 6406653 6407383 6408633 6408692 6408986 6409032 6410444 6410445 6410446 6410447 6410448 6410449 6410450 6410451 6410452 6410453 6410454 6410455 6410456 6410457 6410458 6410459 6410460 6410461 6410462 6410465 6410466 6410467 6410468 6410469 6410470 6410471 6410472 6410473 6410474 6410475 6410476 6410477 6410478 6410479 6410480 6410481 6410482 6410483 6410484 6410485 6410486 6410487 6410488 6410489 6410490 6410491 6410492 6410493 6410494 6410495 6410496 6410497 6410498 6410499 6410500 6410501 6410502 6410503 6410504 6410505 6410506 6410507 6410508 6410509 6410510 6410511 6410512 6410513 6410514 6410515 6410516 6410517 6410518 6410519 6410520 6410521 6410522 6410523 6410524 6410525 6410526 6410527 6410528 6410529 6410530 6410531 6410532 6410533 6410926 6411011 6412111 6412728 6412747 6412888 6412934 6413311 6413590 6413648 6414267 6414731 6414714 6414790 6414791 6414792 6414793 6414794 6414795 6414796 6414797 6414798 6414799 6414800 6414802 6414803 6414804 6414805 6414806 6414807 6414808 6414809 6414810 6414811 6414812 6414813 6414814 6414815 6414817 6414818 6414819 6414820 6414821 6414822 6414823 6414824 6414984 6414999 6415012 6415023 6415072 6415205 6415412 6415657 6415835 6415842 6416116 6416121 6416599 6416688 6417135 6417432 6417638 6417662 6418265 6418827 6419024 6419286 6419401 6419548 6419554 6419878 6419882 6419888 6420604 6420606 6420622 6420628 6420677 6420857 6420930 6420964 6421663 6421691 6421714 6421721 6421722 6421743 6421798 6421866 6421874 6421938 6422798 6422885 6422999 6423000 6423001 6423002 6423003 6423004 6423005 6423006 6423007 6423008 6423009 6423010 6423011 6423012 6423013 6423014 6423015 6423016 6423017 6423018 6423019 6423020 6423021 6423022 6423023 6423024 6423025 6423026 6423027 6423028 6423029 6423030 6423031 6423032 6423033 6423034 6423035 6423036 6423037 6423038 6423039 6423041 6423042 6423043 6423044 6423045 6423046 6423047 6423048 6423049 6423050 6423051 6423052 6423053 6423054 6423055 6423056 6423057 6423058 6423059 6423060 6423061 6423062 6423063 6423064 6423065 6423066 6423067 6423068 6423069 6423089 6423209 6423210 6423211 6423212 6423213 6423214 6423215 6423216 6423217 6423218 6423219 6423220 6423221 6423222 6423223 6423224 6423225 6423226 6423227 6423228 6423690 6423945 6424499 6424501 6424502 6424503 6424505 6424506 6424507 6424508 6424510 6424511 6424513 6424514 6424515 6424516 6424517 6424518 6424519 6424520 6424521 6424522 6424523 6424524 6424525 6424527 6424528 6424529 6424530 6424532 6424533 6424534 6424535 6424536 6424537 6424538 6424790 6425206 6425256 6425291 6425393 6425598 6425825 6426197 6426615 6426889 6426942 6426965 6426985 6427012 6427192 6427226 6427253 6427438 6427641 6427693 6428410 6428898 6428974 6429017 6429309 6429488 6429555 6430646 6430877 6430880 6431497 6431524 6431672 6431954 6432154 6432187 6432194 6432230 6432237 6433598 6433600 6433620 6433627 6433658 6433664 6433668 6433670 6433686 6433697 6429517 6433756 6433831 6433834 6434026 6434044 6434047 6434058 6434060 6434384 6434622 6434703 6434805 6434837 6434847 6434858 6434865 6434935 6434966 6434967 6435236 6435238 6435328 6435329 6435353 6435355 6435399 6435433 6435438 6435480 6435490 6435540 6435544 6435616 6435620 6435647 6435649 6435728 6435874 6435928 6436020 6436090 6436719 6437025 6437136 6437335 6437336 6437594 6437596 6437612 6437615 6437793 6437825 6438011 6438077 6438645 6438854 6439051 6439201 6439234 6439237 6439262 6439297 6439301 6439367 6439370 6439512 6439513 6439514 6439518 6439520 6439535 6439536 6439589 6439590 6439598 6439599 6439616 6439637 6439681 6439918 6439937 6439980 6440363 6440511 6440537 6425424 6440641 6440718 6440860 6441051 6441254 6441255 6441264 6441266 6441296 6441406 6441407 6441565 6441567 6441701 6441703 6442179 6442300 6442349 6442459 6442677 6442680 6442895 6443132 6443258 6444079 6444179 6444274 6444579 6444752 6444986 6445005 6445467 6445638 6445639 6445713 6445741 6445757 6445765 6445799 6446038 6446054 6446105 6446119 6446127 6446193 6446208 6446232 6446418 6446613 6446630 6446793 6446978 6447024 6447057 6447384 6447670 6447692 6447761 6448735 6448829 6449361 6449435 6449641 6449703 6449926 6450043 6450166 6450172 6450198 6450253 6450441 6450493 6450538 6450648 6450744 6450745 6450754 6450791 6450881 6450974 6450991 6450992 6451006 6451059 6451090 6451120 6451214 6451221 6451294 6451297 6451383 6451439 6451593 6451616 6452037 6452041 6452184 6452194 6452195 6452395 6452408 6452418 6452444 6452482 6452510 6452579 6452580 6452595 6452609 6452614 6453471 6453518 6453731 6453833 6453867 6453873 6454162 6454473 6454531 6454582 6454683 6454690 6454783 6454786 6454842 6454924 6454926 6454930 6454949 6454970 6454976 6454982 6455030 6455136 6455152 6455153 6455274 6455307 6455594 6455682 6455762 6455782 6455827 6456078 6456099 6456113 6456298 6456652 6456949 6456972 6456995 6457009 6457071 6457249 6457258 6457266 6457446 6458475 6458876 6459109 6459447 6459524 6459959 6459957 6460001 6460003 6460058 6460060 6460213 6460269 6461011 6461154 6461454 6461761 6461838 6462390 6462717 6462746 6463212 6463215 6464029 6464073 6464356 6464382 6464428 6465286 6465287 6465294 6465706 6465755 6465962 6465963 6465964 6465965 6465966 6465967 6465968 6465969 6465970 6465971 6465972 6465973 6465974 6465975 6465976 6465977 6465978 6465979 6465980 6465981 6465982 6465983 6465984 6465985 6465986 6465987 6465988 6465989 6465990 6465991 6465992 6465993 6465994 6465995 6465996 6465997 6465998 6465999 6466000 6466001 6466002 6466003 6466004 6466006 6466007 6466008 6466009 6466010 6466011 6466012 6466013 6466014 6466015 6466016 6466017 6466018 6466019 6466020 6466021 6466022 6466023 6466024 6466025 6466027 6466028 6466029 6466030 6466031 6466032 6466033 6466034 6466035 6466036 6466037 6466038 6466039 6466040 6466148 6466149 6466150 6466151 6466152 6466153 6466154 6466155 6466156 6466157 6466158 6466159 6466160 6466161 6466162 6466163 6466164 6466165 6466167 6466168 6466169 6466170 6466171 6466172 6466173 6466174 6466175 6466176 6466177 6466178 6466179 6466180 6466181 6466182 6466183 6466184 6466185 6466186 6466187 6466188 6466189 6466190 6466191 6466192 6466193 6466194 6466195 6466196 6466197 6466198 6466199 6466200 6466201 6466202 6466203 6466204 6466205 6466206 6466207 6466208 6466209 6466210 6466211 6466212 6466213 6466214 6466215 6466216 6466217 6466218 6381895 6466495 6466654 6466719 6466903 6466905 6466906 6467007 6467762 6468042 6468071 6468119 6468153 6468155 6468161 6468224 6468227 6468239 6468545 6468669 6468676 6390708 1000000973 6383992 6378986 1000002275 1000002548 1000002570 6385410 1000000887 1000003845 1000005277 6374946 1000005564 1000005849 6391433 6392532 6378512 1000006566 1000006968 1000008119 1000008125 1000008313 1000008321 1000008641 1000008861 1000008586 1000009539 1000009968 1000009989 1000009992 1000000827 1000001857 1000009927 6390590 1000009003 1000010361 1000010343 1000010475 1000010476 1000008530 1000009631 1000005996 1000010760 1000010743 1000010839 1000009904 1000010962 1000009943 1000011059 1000011801 1000011816 1000011830 1000009958 1000010840 1000009062 1000010561 1000007988 1000010466 1000012323 1000009429 1000012750 1000012762 1000012853 1000012861 1000004783 1000013094 1000009970 1000012931 1000012172 1000006028 1000010147 1000012685 1000012662 1000013564 1000012348 1000013504 1000012104 1000013888 1000005460 1000005721 1000014179 1000012914 1000013554 1000006473 1000014928 1000015081 1000012784 1000013511 1000015383 1000009127 1000014625 1000015669 1000010470 1000016694 1000016762 1000016869 1000016878 1000016972 1000017065 1000012570 1000017177 1000017121 1000017510 1000017046 1000017944 1000017953 1000017954 1000017955 1000017956 1000017965 1000017970 1000017977 1000017978 1000018121 1000018296 1000018297 1000018300 1000018301 1000018302 1000018309 1000018311 1000018315 1000018318 1000018320 1000018326 1000018329 1000018334 1000018335 1000018345 1000018464 1000018466 1000018471 1000018906 1000018911 1000018920 1000018926 1000018927 1000018937 1000019070 1000019124 1000019157 1000019383 1000019403 1000019407 1000019414 1000019425 1000010586 1000017186 1000020146 1000020495 1000020496 1000020507 1000020555 1000020556 1000020695 1000019251 1000018377 1000012314 1000020562 1000014859 1000021334 1000012776 1000015808 1000014850 1000021820 1000021822 1000021823 1000021871 1000021872 1000021878 1000021884 1000022153 1000022154 1000022155 1000022156 1000022158 1000022159 1000022160 1000022161 1000022163 1000022164 1000022170 1000022171 1000022172 1000022173 1000016210 1000013196 1000006074 1000019091 1000022817 1000022834 1000022880 1000012471 1000023092 1000023163 1000023196 1000023198 1000023215 1000023217 1000023221 1000023222 1000023224 1000023227 1000023228 1000023231 1000023233 1000023236 1000023237 1000023238 1000023239 1000023240 1000023241 1000023242 1000023243 1000023244 1000023245 1000023246 1000023247 1000023248 1000023249 1000023250 1000023251 1000023262 1000023263 1000023266 1000023267 1000023268 1000023269 1000023270 1000023271 1000023273 1000023274 1000023275 1000023276 1000023277 1000023718 1000023722 1000023750 1000016655 1000024083 1000024100 1000024123 1000024134 1000024143 1000024153 1000024154 1000024155 1000024161 1000024162 1000024170 1000024171 1000024173 1000024174 1000024175 1000024176 1000024177 1000024178 1000024179 1000024180 1000024181 1000024197 1000024200 1000024432 1000024434 1000024467 1000024502 1000024503 1000025000 1000025162 1000025164 1000025168 1000021907 1000025486 1000025551 1000025704 1000025705 1000017957 1000017945 1000025768 1000025772 1000025774 1000025775 1000025776 1000025777 1000025778 1000025779 1000025780 1000025781 1000025782 1000025783 1000025784 1000025785 1000025786 1000025787 1000025788 1000025789 1000025790 1000025791 1000025792 1000025793 1000025794 1000025795 1000025796 1000025797 1000025798 1000025799 1000025800 1000025801 1000025802 1000025803 1000025817 1000025818 1000025819 1000025820 1000025821 1000025822 1000025830 1000025848 1000025849 1000025850 1000025851 1000025852 1000026331 1000026334 1000022657 1000026187 1000026497 1000026499 1000026557 1000026602 1000026603 1000026604 1000026613 1000026615 1000026625 1000022857 1000006969 1000008043 1000026679 1000015657 1000026786 1000026800 1000026802 1000026803 1000026804 1000026805 1000026806 1000026807 1000026808 1000026809 1000026810 1000026811 1000026812 1000026813 1000026829 1000008554 1000026902 1000026995 1000021567 1000027105 1000027107 1000027108 1000027109 1000027110 1000027111 1000027112 1000027113 1000027114 1000027115 1000027117 1000027120 1000027121 1000027122 1000027124 1000027125 1000027127 1000017699 1000027128 1000027129 1000027130 1000027131 1000027134 1000027140 1000027143 1000027145 1000027148 1000027149 1000027150 1000027151 1000027152 1000027153 1000027154 1000027159 1000027160 1000027161 1000027162 1000027166 1000027168 1000027171 1000027174 1000027175 1000027176 1000027177 1000027178 1000027179 1000027180 1000027189 1000027193 1000027194 1000027195 1000027196 1000027197 1000027203 1000027208 1000027209 1000027210 1000027211 1000027212 1000027213 1000027215 1000027216 1000027228 1000027229 1000027230 1000027231 1000027260 1000027263 1000027297 1000027650 1000027655 1000027657 1000027682 1000027683 1000027685 1000027695 1000027892 1000027969 1000027971 1000027972 1000028138 1000028259 1000028260 1000028261 1000028262 1000028263 1000028265 1000028266 1000028280 1000028281 1000028283 1000028285 1000028307 1000028308 1000028365 1000028391 1000028392 1000028394 1000028436 1000028437 1000028438 1000028439 1000028440 1000028441 1000028442 1000028444 1000028445 1000028446 1000028628 1000028643 1000028644 1000028646 1000028647 1000028649 1000028650 1000028658 1000012149 1000028996 1000029003 1000029110 1000029112 1000029130 1000029152 1000029411 1000029421 1000029425 1000029428 1000029433 1000029773 1000029983 1000029984 1000029985 1000029987 1000029988 1000029989 1000029990 1000029991 1000029992 1000029994 1000029995 1000029996 1000029997 1000029998 1000029999 1000030000 1000030001 1000030002 1000030003 1000030004 1000030005 1000030006 1000030007 1000030008 1000030009 1000030010 1000030011 1000030012 1000030049 1000030050 1000030051 1000013580 1000030403 1000030404 6343267 1000030869 1000030870 1000030871 1000030872 1000030873 1000030874 1000030875 1000030876 1000030877 1000030912 1000030913 1000030915 1000030916 1000030917 1000030918 1000030919 1000030920 1000030922 1000030924 1000030925 1000030943 1000030944 1000030946 1000030947 1000030948 1000030949 1000030950 1000030951 1000030952 1000030953 1000030954 1000030970 1000031000 1000031020 1000031032 1000031035 1000031036 1000031242 1000031243 1000031292 1000031293 1000031294 1000031295 1000031296 1000031297 1000031298 1000031299 1000031300 1000031301 1000031302 1000031427 1000028651 1000022031 1000028476 1000012435 1000032247 1000032255 1000032361 1000032434 1000032472 1000032474 1000032475 1000032477 1000032478 1000032479 1000032480 1000013359 1000015816 1000028397 1000032657 1000032659 1000032661 1000032663 1000032664 1000032670 1000032680 1000032681 1000032682 1000032685 1000032686 1000032689 1000032702 1000032703 1000032704 1000032705 1000032706 1000032708 1000032709 1000032714 1000032718 1000032727 1000032731 1000032733 1000032821 1000032822 1000032823 1000032829 1000032830 1000032831 1000032832 1000030434 1000033015 1000033039 1000033042 1000033058 1000033059 1000033061 1000033194 1000033195 1000033200 1000033201 1000033202 1000033246 1000033247 1000033248 1000033250 1000033251 1000033252 1000033253 1000033255 1000033259 1000033261 1000033262 1000033268 1000033391 1000033393 1000033396 1000033398 1000033399 1000033400 1000033401 1000033402 1000033403 1000033441 1000033567 1000033568 1000033870 1000033885 1000033973 1000033984 1000034040 1000034042 1000032441 1000021444 1000028629 1000034256 1000034277 1000034052 1000034312 1000024507 1000034476 1000009832 1000034546 1000024137 1000018119 1000035265 1000035428 1000035503 1000033569 1000035586 1000035634 1000035844 1000036009 1000036015 1000015433 1000036054 1000036055 1000036056 1000036057 1000036058 1000036059 1000036060 1000036061 1000036062 1000036063 1000036064 1000036066 1000036067 1000036068 1000036070 1000036071 1000036072 1000036073 1000036074 1000036075 1000036076 1000036077 1000036079 1000036080 1000036081 1000036082 1000036083 1000036084 1000036085 1000036095 1000034088 1000036494 1000036501 1000036503 1000036504 1000036514 1000036550 1000036646 1000036647 1000036649 1000036678 1000036679 1000036682 1000036685 1000036687 1000036688 1000036689 1000036691 1000036692 1000036707 1000036714 1000036720 1000036745 1000036749 1000034258 1000036982 1000036988 1000036991 1000036994 1000036995 1000036996 1000036997 1000036998 1000036999 1000037000 1000037342 1000037343 1000037344 1000037345 1000037346 1000037347 1000037348 1000037349 1000037350 1000037351 1000006045 1000037391 1000037627 1000037717 1000037734 1000037739 1000038081 1000038082 1000038083 1000038085 1000038086 1000038087 1000038108 1000038109 1000038111 1000038112 1000038113 1000038114 1000038115 1000038116 1000038124 1000038125 1000038126 1000038127 1000038128 1000038130 1000038131 1000038311 1000038314 1000038327 1000038328 1000038783 1000038790 1000038797 1000038846 1000038847 1000038849 1000039262 1000039384 1000039500 1000039509 1000039510 1000039511 1000039516 1000039523 1000039526 1000039548 1000039565 1000039567 1000039568 1000039569 1000039578 1000039580 1000039584 1000039585 1000039586 1000039587 1000039588 1000039609 1000039611 1000039612 1000039613 1000039614 1000039615 1000039616 1000040166 1000040745 1000040746 1000040748 1000040868 1000040978 1000040979 1000040980 1000040989 1000041505 1000033890 1000041663 1000041664 1000041665 1000041666 1000041734 1000041757 1000041763 1000041765 1000041907 1000036512 1000042079 1000042081 1000042082 1000042083 1000042085 1000042312 1000042342 1000042457 1000042458 1000042459 1000042460 1000042465 1000037837 1000042755 1000042757 1000042812 1000042865 1000042990 1000042999 1000043000 1000043022 1000043029 1000043057 1000043592 1000043596 1000043743 1000005141 1000043875 1000044338 1000044350 1000044382 1000044384 1000044385 1000044492 1000027614 1000044861 1000026490 1000045105 1000045147 1000045199 1000045200 1000045205 1000045207 1000045316 1000037400 1000045349 1000045350 1000045351 1000045352 1000045414 1000045681 1000045699 1000045716 1000045717 1000045731 1000045732 1000045733 1000045734 1000045735 1000045736 1000045737 1000045738 1000045739 1000045740 1000045741 1000045742 1000045743 1000045744 1000045745 1000045746 1000045748 1000045749 1000045750 1000045751 1000045752 1000045753 1000045754 1000045755 1000045756 1000045757 1000045758 1000045759 1000045760 1000046053 1000046297 1000046298 1000046300 1000046352 1000046370 1000046371 1000046372 1000046373 1000046392 1000046460 1000046465 1000046417 1000046575 1000046577 1000046578 1000046579 1000046580 1000046581 1000046583 1000046584 1000046586 1000046587 1000046588 1000046589 1000046590 1000046664 1000046665 1000046666 1000046667 1000046668 1000046669 1000046671 1000046672 1000046673 1000046675 1000046677 1000046678 1000046679 1000046680 1000046681 1000046682 1000046683 1000046684 1000046685 1000046686 1000046687 1000046688 1000046689 1000046691 1000046692 1000046693 1000046694 1000046695 1000046696 1000046824 1000046934 1000047441 1000047443 1000047444 1000047466 1000046444 1000047839 1000023316 1000047504 1000048022 1000048064 1000048065 1000048070 1000048189 1000047949 1000048358 1000047468 1000043973 1000035758 1000048491 1000048461 1000044992 1000048565 1000048566 1000048581 1000048625 1000048648 1000048347 1000048841 1000048889 1000048890 1000048891 1000015244 1000048946 1000048947 1000025427 1000048858 1000047821 1000003540 1000049264 1000049265 1000049304 1000049321 1000048208 1000049434 1000049439 1000049463 1000049471 1000049469 1000049587 1000049071 1000049602 1000049603 1000044958 1000049636 1000049658 1000049703 1000049743 1000049830 1000045271 1000049885 1000048554 1000050325 1000050479 1000050512 1000050370 1000050069 1000044393 1000050781 1000050783 1000014593 1000050957 1000050990 1000050234 1000051013 1000048650 1000051402 1000051440 1000050071 1000051622 1000048273 1000051770 1000051793 1000051794 1000051789 1000051847 1000051893 1000051962 1000051971 1000051972 1000051981 1000051985 1000052014 1000052026 1000052039 1000052124 1000052133 1000052027 1000052355 1000050971 1000043879 1000052516 1000052525 1000052532 1000016634 1000052144 1000052596 1000052630 1000052656 1000052738 1000052755 1000052813 1000052044 1000052833 1000052176 1000052966 1000053053 1000053113 1000053200 1000053227 1000053252 1000053261 1000053265 1000053362 1000053367 1000053368 1000053404 1000053418 67678] View formatted query View runnable query Explain query 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 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 (6343257, 6345227, 6346002, 6346718, 6347767, 6349572, 6353912, 6354133, 6355315, 6356906, 6357918, 6357966, 6358125, 6358230, 6362322, 6363785, 6364027, 6364694, 6364830, 6365059, 6365080, 6365102, 6365949, 6367441, 6367442, 6368859, 6370233, 6371245, 6372087, 6377010, 6352574, 6381624, 6382928, 6382118, 6381725, 6366688, 6380834, 6386872, 6387230, 6365663, 6388014, 6388303, 6388460, 6388524, 6388552, 6389120, 6389553, 6390348, 6391444, 6392489, 6392505, 6394022, 6394345, 6396240, 6396336, 6398605, 6400742, 6400794, 6401429, 6402611, 6403262, 6403662, 6405136, 6405445, 6405911, 6406415, 6406625, 6406653, 6407383, 6408633, 6408692, 6408986, 6409032, 6410444, 6410445, 6410446, 6410447, 6410448, 6410449, 6410450, 6410451, 6410452, 6410453, 6410454, 6410455, 6410456, 6410457, 6410458, 6410459, 6410460, 6410461, 6410462, 6410465, 6410466, 6410467, 6410468, 6410469, 6410470, 6410471, 6410472, 6410473, 6410474, 6410475, 6410476, 6410477, 6410478, 6410479, 6410480, 6410481, 6410482, 6410483, 6410484, 6410485, 6410486, 6410487, 6410488, 6410489, 6410490, 6410491, 6410492, 6410493, 6410494, 6410495, 6410496, 6410497, 6410498, 6410499, 6410500, 6410501, 6410502, 6410503, 6410504, 6410505, 6410506, 6410507, 6410508, 6410509, 6410510, 6410511, 6410512, 6410513, 6410514, 6410515, 6410516, 6410517, 6410518, 6410519, 6410520, 6410521, 6410522, 6410523, 6410524, 6410525, 6410526, 6410527, 6410528, 6410529, 6410530, 6410531, 6410532, 6410533, 6410926, 6411011, 6412111, 6412728, 6412747, 6412888, 6412934, 6413311, 6413590, 6413648, 6414267, 6414731, 6414714, 6414790, 6414791, 6414792, 6414793, 6414794, 6414795, 6414796, 6414797, 6414798, 6414799, 6414800, 6414802, 6414803, 6414804, 6414805, 6414806, 6414807, 6414808, 6414809, 6414810, 6414811, 6414812, 6414813, 6414814, 6414815, 6414817, 6414818, 6414819, 6414820, 6414821, 6414822, 6414823, 6414824, 6414984, 6414999, 6415012, 6415023, 6415072, 6415205, 6415412, 6415657, 6415835, 6415842, 6416116, 6416121, 6416599, 6416688, 6417135, 6417432, 6417638, 6417662, 6418265, 6418827, 6419024, 6419286, 6419401, 6419548, 6419554, 6419878, 6419882, 6419888, 6420604, 6420606, 6420622, 6420628, 6420677, 6420857, 6420930, 6420964, 6421663, 6421691, 6421714, 6421721, 6421722, 6421743, 6421798, 6421866, 6421874, 6421938, 6422798, 6422885, 6422999, 6423000, 6423001, 6423002, 6423003, 6423004, 6423005, 6423006, 6423007, 6423008, 6423009, 6423010, 6423011, 6423012, 6423013, 6423014, 6423015, 6423016, 6423017, 6423018, 6423019, 6423020, 6423021, 6423022, 6423023, 6423024, 6423025, 6423026, 6423027, 6423028, 6423029, 6423030, 6423031, 6423032, 6423033, 6423034, 6423035, 6423036, 6423037, 6423038, 6423039, 6423041, 6423042, 6423043, 6423044, 6423045, 6423046, 6423047, 6423048, 6423049, 6423050, 6423051, 6423052, 6423053, 6423054, 6423055, 6423056, 6423057, 6423058, 6423059, 6423060, 6423061, 6423062, 6423063, 6423064, 6423065, 6423066, 6423067, 6423068, 6423069, 6423089, 6423209, 6423210, 6423211, 6423212, 6423213, 6423214, 6423215, 6423216, 6423217, 6423218, 6423219, 6423220, 6423221, 6423222, 6423223, 6423224, 6423225, 6423226, 6423227, 6423228, 6423690, 6423945, 6424499, 6424501, 6424502, 6424503, 6424505, 6424506, 6424507, 6424508, 6424510, 6424511, 6424513, 6424514, 6424515, 6424516, 6424517, 6424518, 6424519, 6424520, 6424521, 6424522, 6424523, 6424524, 6424525, 6424527, 6424528, 6424529, 6424530, 6424532, 6424533, 6424534, 6424535, 6424536, 6424537, 6424538, 6424790, 6425206, 6425256, 6425291, 6425393, 6425598, 6425825, 6426197, 6426615, 6426889, 6426942, 6426965, 6426985, 6427012, 6427192, 6427226, 6427253, 6427438, 6427641, 6427693, 6428410, 6428898, 6428974, 6429017, 6429309, 6429488, 6429555, 6430646, 6430877, 6430880, 6431497, 6431524, 6431672, 6431954, 6432154, 6432187, 6432194, 6432230, 6432237, 6433598, 6433600, 6433620, 6433627, 6433658, 6433664, 6433668, 6433670, 6433686, 6433697, 6429517, 6433756, 6433831, 6433834, 6434026, 6434044, 6434047, 6434058, 6434060, 6434384, 6434622, 6434703, 6434805, 6434837, 6434847, 6434858, 6434865, 6434935, 6434966, 6434967, 6435236, 6435238, 6435328, 6435329, 6435353, 6435355, 6435399, 6435433, 6435438, 6435480, 6435490, 6435540, 6435544, 6435616, 6435620, 6435647, 6435649, 6435728, 6435874, 6435928, 6436020, 6436090, 6436719, 6437025, 6437136, 6437335, 6437336, 6437594, 6437596, 6437612, 6437615, 6437793, 6437825, 6438011, 6438077, 6438645, 6438854, 6439051, 6439201, 6439234, 6439237, 6439262, 6439297, 6439301, 6439367, 6439370, 6439512, 6439513, 6439514, 6439518, 6439520, 6439535, 6439536, 6439589, 6439590, 6439598, 6439599, 6439616, 6439637, 6439681, 6439918, 6439937, 6439980, 6440363, 6440511, 6440537, 6425424, 6440641, 6440718, 6440860, 6441051, 6441254, 6441255, 6441264, 6441266, 6441296, 6441406, 6441407, 6441565, 6441567, 6441701, 6441703, 6442179, 6442300, 6442349, 6442459, 6442677, 6442680, 6442895, 6443132, 6443258, 6444079, 6444179, 6444274, 6444579, 6444752, 6444986, 6445005, 6445467, 6445638, 6445639, 6445713, 6445741, 6445757, 6445765, 6445799, 6446038, 6446054, 6446105, 6446119, 6446127, 6446193, 6446208, 6446232, 6446418, 6446613, 6446630, 6446793, 6446978, 6447024, 6447057, 6447384, 6447670, 6447692, 6447761, 6448735, 6448829, 6449361, 6449435, 6449641, 6449703, 6449926, 6450043, 6450166, 6450172, 6450198, 6450253, 6450441, 6450493, 6450538, 6450648, 6450744, 6450745, 6450754, 6450791, 6450881, 6450974, 6450991, 6450992, 6451006, 6451059, 6451090, 6451120, 6451214, 6451221, 6451294, 6451297, 6451383, 6451439, 6451593, 6451616, 6452037, 6452041, 6452184, 6452194, 6452195, 6452395, 6452408, 6452418, 6452444, 6452482, 6452510, 6452579, 6452580, 6452595, 6452609, 6452614, 6453471, 6453518, 6453731, 6453833, 6453867, 6453873, 6454162, 6454473, 6454531, 6454582, 6454683, 6454690, 6454783, 6454786, 6454842, 6454924, 6454926, 6454930, 6454949, 6454970, 6454976, 6454982, 6455030, 6455136, 6455152, 6455153, 6455274, 6455307, 6455594, 6455682, 6455762, 6455782, 6455827, 6456078, 6456099, 6456113, 6456298, 6456652, 6456949, 6456972, 6456995, 6457009, 6457071, 6457249, 6457258, 6457266, 6457446, 6458475, 6458876, 6459109, 6459447, 6459524, 6459959, 6459957, 6460001, 6460003, 6460058, 6460060, 6460213, 6460269, 6461011, 6461154, 6461454, 6461761, 6461838, 6462390, 6462717, 6462746, 6463212, 6463215, 6464029, 6464073, 6464356, 6464382, 6464428, 6465286, 6465287, 6465294, 6465706, 6465755, 6465962, 6465963, 6465964, 6465965, 6465966, 6465967, 6465968, 6465969, 6465970, 6465971, 6465972, 6465973, 6465974, 6465975, 6465976, 6465977, 6465978, 6465979, 6465980, 6465981, 6465982, 6465983, 6465984, 6465985, 6465986, 6465987, 6465988, 6465989, 6465990, 6465991, 6465992, 6465993, 6465994, 6465995, 6465996, 6465997, 6465998, 6465999, 6466000, 6466001, 6466002, 6466003, 6466004, 6466006, 6466007, 6466008, 6466009, 6466010, 6466011, 6466012, 6466013, 6466014, 6466015, 6466016, 6466017, 6466018, 6466019, 6466020, 6466021, 6466022, 6466023, 6466024, 6466025, 6466027, 6466028, 6466029, 6466030, 6466031, 6466032, 6466033, 6466034, 6466035, 6466036, 6466037, 6466038, 6466039, 6466040, 6466148, 6466149, 6466150, 6466151, 6466152, 6466153, 6466154, 6466155, 6466156, 6466157, 6466158, 6466159, 6466160, 6466161, 6466162, 6466163, 6466164, 6466165, 6466167, 6466168, 6466169, 6466170, 6466171, 6466172, 6466173, 6466174, 6466175, 6466176, 6466177, 6466178, 6466179, 6466180, 6466181, 6466182, 6466183, 6466184, 6466185, 6466186, 6466187, 6466188, 6466189, 6466190, 6466191, 6466192, 6466193, 6466194, 6466195, 6466196, 6466197, 6466198, 6466199, 6466200, 6466201, 6466202, 6466203, 6466204, 6466205, 6466206, 6466207, 6466208, 6466209, 6466210, 6466211, 6466212, 6466213, 6466214, 6466215, 6466216, 6466217, 6466218, 6381895, 6466495, 6466654, 6466719, 6466903, 6466905, 6466906, 6467007, 6467762, 6468042, 6468071, 6468119, 6468153, 6468155, 6468161, 6468224, 6468227, 6468239, 6468545, 6468669, 6468676, 6390708, 1000000973, 6383992, 6378986, 1000002275, 1000002548, 1000002570, 6385410, 1000000887, 1000003845, 1000005277, 6374946, 1000005564, 1000005849, 6391433, 6392532, 6378512, 1000006566, 1000006968, 1000008119, 1000008125, 1000008313, 1000008321, 1000008641, 1000008861, 1000008586, 1000009539, 1000009968, 1000009989, 1000009992, 1000000827, 1000001857, 1000009927, 6390590, 1000009003, 1000010361, 1000010343, 1000010475, 1000010476, 1000008530, 1000009631, 1000005996, 1000010760, 1000010743, 1000010839, 1000009904, 1000010962, 1000009943, 1000011059, 1000011801, 1000011816, 1000011830, 1000009958, 1000010840, 1000009062, 1000010561, 1000007988, 1000010466, 1000012323, 1000009429, 1000012750, 1000012762, 1000012853, 1000012861, 1000004783, 1000013094, 1000009970, 1000012931, 1000012172, 1000006028, 1000010147, 1000012685, 1000012662, 1000013564, 1000012348, 1000013504, 1000012104, 1000013888, 1000005460, 1000005721, 1000014179, 1000012914, 1000013554, 1000006473, 1000014928, 1000015081, 1000012784, 1000013511, 1000015383, 1000009127, 1000014625, 1000015669, 1000010470, 1000016694, 1000016762, 1000016869, 1000016878, 1000016972, 1000017065, 1000012570, 1000017177, 1000017121, 1000017510, 1000017046, 1000017944, 1000017953, 1000017954, 1000017955, 1000017956, 1000017965, 1000017970, 1000017977, 1000017978, 1000018121, 1000018296, 1000018297, 1000018300, 1000018301, 1000018302, 1000018309, 1000018311, 1000018315, 1000018318, 1000018320, 1000018326, 1000018329, 1000018334, 1000018335, 1000018345, 1000018464, 1000018466, 1000018471, 1000018906, 1000018911, 1000018920, 1000018926, 1000018927, 1000018937, 1000019070, 1000019124, 1000019157, 1000019383, 1000019403, 1000019407, 1000019414, 1000019425, 1000010586, 1000017186, 1000020146, 1000020495, 1000020496, 1000020507, 1000020555, 1000020556, 1000020695, 1000019251, 1000018377, 1000012314, 1000020562, 1000014859, 1000021334, 1000012776, 1000015808, 1000014850, 1000021820, 1000021822, 1000021823, 1000021871, 1000021872, 1000021878, 1000021884, 1000022153, 1000022154, 1000022155, 1000022156, 1000022158, 1000022159, 1000022160, 1000022161, 1000022163, 1000022164, 1000022170, 1000022171, 1000022172, 1000022173, 1000016210, 1000013196, 1000006074, 1000019091, 1000022817, 1000022834, 1000022880, 1000012471, 1000023092, 1000023163, 1000023196, 1000023198, 1000023215, 1000023217, 1000023221, 1000023222, 1000023224, 1000023227, 1000023228, 1000023231, 1000023233, 1000023236, 1000023237, 1000023238, 1000023239, 1000023240, 1000023241, 1000023242, 1000023243, 1000023244, 1000023245, 1000023246, 1000023247, 1000023248, 1000023249, 1000023250, 1000023251, 1000023262, 1000023263, 1000023266, 1000023267, 1000023268, 1000023269, 1000023270, 1000023271, 1000023273, 1000023274, 1000023275, 1000023276, 1000023277, 1000023718, 1000023722, 1000023750, 1000016655, 1000024083, 1000024100, 1000024123, 1000024134, 1000024143, 1000024153, 1000024154, 1000024155, 1000024161, 1000024162, 1000024170, 1000024171, 1000024173, 1000024174, 1000024175, 1000024176, 1000024177, 1000024178, 1000024179, 1000024180, 1000024181, 1000024197, 1000024200, 1000024432, 1000024434, 1000024467, 1000024502, 1000024503, 1000025000, 1000025162, 1000025164, 1000025168, 1000021907, 1000025486, 1000025551, 1000025704, 1000025705, 1000017957, 1000017945, 1000025768, 1000025772, 1000025774, 1000025775, 1000025776, 1000025777, 1000025778, 1000025779, 1000025780, 1000025781, 1000025782, 1000025783, 1000025784, 1000025785, 1000025786, 1000025787, 1000025788, 1000025789, 1000025790, 1000025791, 1000025792, 1000025793, 1000025794, 1000025795, 1000025796, 1000025797, 1000025798, 1000025799, 1000025800, 1000025801, 1000025802, 1000025803, 1000025817, 1000025818, 1000025819, 1000025820, 1000025821, 1000025822, 1000025830, 1000025848, 1000025849, 1000025850, 1000025851, 1000025852, 1000026331, 1000026334, 1000022657, 1000026187, 1000026497, 1000026499, 1000026557, 1000026602, 1000026603, 1000026604, 1000026613, 1000026615, 1000026625, 1000022857, 1000006969, 1000008043, 1000026679, 1000015657, 1000026786, 1000026800, 1000026802, 1000026803, 1000026804, 1000026805, 1000026806, 1000026807, 1000026808, 1000026809, 1000026810, 1000026811, 1000026812, 1000026813, 1000026829, 1000008554, 1000026902, 1000026995, 1000021567, 1000027105, 1000027107, 1000027108, 1000027109, 1000027110, 1000027111, 1000027112, 1000027113, 1000027114, 1000027115, 1000027117, 1000027120, 1000027121, 1000027122, 1000027124, 1000027125, 1000027127, 1000017699, 1000027128, 1000027129, 1000027130, 1000027131, 1000027134, 1000027140, 1000027143, 1000027145, 1000027148, 1000027149, 1000027150, 1000027151, 1000027152, 1000027153, 1000027154, 1000027159, 1000027160, 1000027161, 1000027162, 1000027166, 1000027168, 1000027171, 1000027174, 1000027175, 1000027176, 1000027177, 1000027178, 1000027179, 1000027180, 1000027189, 1000027193, 1000027194, 1000027195, 1000027196, 1000027197, 1000027203, 1000027208, 1000027209, 1000027210, 1000027211, 1000027212, 1000027213, 1000027215, 1000027216, 1000027228, 1000027229, 1000027230, 1000027231, 1000027260, 1000027263, 1000027297, 1000027650, 1000027655, 1000027657, 1000027682, 1000027683, 1000027685, 1000027695, 1000027892, 1000027969, 1000027971, 1000027972, 1000028138, 1000028259, 1000028260, 1000028261, 1000028262, 1000028263, 1000028265, 1000028266, 1000028280, 1000028281, 1000028283, 1000028285, 1000028307, 1000028308, 1000028365, 1000028391, 1000028392, 1000028394, 1000028436, 1000028437, 1000028438, 1000028439, 1000028440, 1000028441, 1000028442, 1000028444, 1000028445, 1000028446, 1000028628, 1000028643, 1000028644, 1000028646, 1000028647, 1000028649, 1000028650, 1000028658, 1000012149, 1000028996, 1000029003, 1000029110, 1000029112, 1000029130, 1000029152, 1000029411, 1000029421, 1000029425, 1000029428, 1000029433, 1000029773, 1000029983, 1000029984, 1000029985, 1000029987, 1000029988, 1000029989, 1000029990, 1000029991, 1000029992, 1000029994, 1000029995, 1000029996, 1000029997, 1000029998, 1000029999, 1000030000, 1000030001, 1000030002, 1000030003, 1000030004, 1000030005, 1000030006, 1000030007, 1000030008, 1000030009, 1000030010, 1000030011, 1000030012, 1000030049, 1000030050, 1000030051, 1000013580, 1000030403, 1000030404, 6343267, 1000030869, 1000030870, 1000030871, 1000030872, 1000030873, 1000030874, 1000030875, 1000030876, 1000030877, 1000030912, 1000030913, 1000030915, 1000030916, 1000030917, 1000030918, 1000030919, 1000030920, 1000030922, 1000030924, 1000030925, 1000030943, 1000030944, 1000030946, 1000030947, 1000030948, 1000030949, 1000030950, 1000030951, 1000030952, 1000030953, 1000030954, 1000030970, 1000031000, 1000031020, 1000031032, 1000031035, 1000031036, 1000031242, 1000031243, 1000031292, 1000031293, 1000031294, 1000031295, 1000031296, 1000031297, 1000031298, 1000031299, 1000031300, 1000031301, 1000031302, 1000031427, 1000028651, 1000022031, 1000028476, 1000012435, 1000032247, 1000032255, 1000032361, 1000032434, 1000032472, 1000032474, 1000032475, 1000032477, 1000032478, 1000032479, 1000032480, 1000013359, 1000015816, 1000028397, 1000032657, 1000032659, 1000032661, 1000032663, 1000032664, 1000032670, 1000032680, 1000032681, 1000032682, 1000032685, 1000032686, 1000032689, 1000032702, 1000032703, 1000032704, 1000032705, 1000032706, 1000032708, 1000032709, 1000032714, 1000032718, 1000032727, 1000032731, 1000032733, 1000032821, 1000032822, 1000032823, 1000032829, 1000032830, 1000032831, 1000032832, 1000030434, 1000033015, 1000033039, 1000033042, 1000033058, 1000033059, 1000033061, 1000033194, 1000033195, 1000033200, 1000033201, 1000033202, 1000033246, 1000033247, 1000033248, 1000033250, 1000033251, 1000033252, 1000033253, 1000033255, 1000033259, 1000033261, 1000033262, 1000033268, 1000033391, 1000033393, 1000033396, 1000033398, 1000033399, 1000033400, 1000033401, 1000033402, 1000033403, 1000033441, 1000033567, 1000033568, 1000033870, 1000033885, 1000033973, 1000033984, 1000034040, 1000034042, 1000032441, 1000021444, 1000028629, 1000034256, 1000034277, 1000034052, 1000034312, 1000024507, 1000034476, 1000009832, 1000034546, 1000024137, 1000018119, 1000035265, 1000035428, 1000035503, 1000033569, 1000035586, 1000035634, 1000035844, 1000036009, 1000036015, 1000015433, 1000036054, 1000036055, 1000036056, 1000036057, 1000036058, 1000036059, 1000036060, 1000036061, 1000036062, 1000036063, 1000036064, 1000036066, 1000036067, 1000036068, 1000036070, 1000036071, 1000036072, 1000036073, 1000036074, 1000036075, 1000036076, 1000036077, 1000036079, 1000036080, 1000036081, 1000036082, 1000036083, 1000036084, 1000036085, 1000036095, 1000034088, 1000036494, 1000036501, 1000036503, 1000036504, 1000036514, 1000036550, 1000036646, 1000036647, 1000036649, 1000036678, 1000036679, 1000036682, 1000036685, 1000036687, 1000036688, 1000036689, 1000036691, 1000036692, 1000036707, 1000036714, 1000036720, 1000036745, 1000036749, 1000034258, 1000036982, 1000036988, 1000036991, 1000036994, 1000036995, 1000036996, 1000036997, 1000036998, 1000036999, 1000037000, 1000037342, 1000037343, 1000037344, 1000037345, 1000037346, 1000037347, 1000037348, 1000037349, 1000037350, 1000037351, 1000006045, 1000037391, 1000037627, 1000037717, 1000037734, 1000037739, 1000038081, 1000038082, 1000038083, 1000038085, 1000038086, 1000038087, 1000038108, 1000038109, 1000038111, 1000038112, 1000038113, 1000038114, 1000038115, 1000038116, 1000038124, 1000038125, 1000038126, 1000038127, 1000038128, 1000038130, 1000038131, 1000038311, 1000038314, 1000038327, 1000038328, 1000038783, 1000038790, 1000038797, 1000038846, 1000038847, 1000038849, 1000039262, 1000039384, 1000039500, 1000039509, 1000039510, 1000039511, 1000039516, 1000039523, 1000039526, 1000039548, 1000039565, 1000039567, 1000039568, 1000039569, 1000039578, 1000039580, 1000039584, 1000039585, 1000039586, 1000039587, 1000039588, 1000039609, 1000039611, 1000039612, 1000039613, 1000039614, 1000039615, 1000039616, 1000040166, 1000040745, 1000040746, 1000040748, 1000040868, 1000040978, 1000040979, 1000040980, 1000040989, 1000041505, 1000033890, 1000041663, 1000041664, 1000041665, 1000041666, 1000041734, 1000041757, 1000041763, 1000041765, 1000041907, 1000036512, 1000042079, 1000042081, 1000042082, 1000042083, 1000042085, 1000042312, 1000042342, 1000042457, 1000042458, 1000042459, 1000042460, 1000042465, 1000037837, 1000042755, 1000042757, 1000042812, 1000042865, 1000042990, 1000042999, 1000043000, 1000043022, 1000043029, 1000043057, 1000043592, 1000043596, 1000043743, 1000005141, 1000043875, 1000044338, 1000044350, 1000044382, 1000044384, 1000044385, 1000044492, 1000027614, 1000044861, 1000026490, 1000045105, 1000045147, 1000045199, 1000045200, 1000045205, 1000045207, 1000045316, 1000037400, 1000045349, 1000045350, 1000045351, 1000045352, 1000045414, 1000045681, 1000045699, 1000045716, 1000045717, 1000045731, 1000045732, 1000045733, 1000045734, 1000045735, 1000045736, 1000045737, 1000045738, 1000045739, 1000045740, 1000045741, 1000045742, 1000045743, 1000045744, 1000045745, 1000045746, 1000045748, 1000045749, 1000045750, 1000045751, 1000045752, 1000045753, 1000045754, 1000045755, 1000045756, 1000045757, 1000045758, 1000045759, 1000045760, 1000046053, 1000046297, 1000046298, 1000046300, 1000046352, 1000046370, 1000046371, 1000046372, 1000046373, 1000046392, 1000046460, 1000046465, 1000046417, 1000046575, 1000046577, 1000046578, 1000046579, 1000046580, 1000046581, 1000046583, 1000046584, 1000046586, 1000046587, 1000046588, 1000046589, 1000046590, 1000046664, 1000046665, 1000046666, 1000046667, 1000046668, 1000046669, 1000046671, 1000046672, 1000046673, 1000046675, 1000046677, 1000046678, 1000046679, 1000046680, 1000046681, 1000046682, 1000046683, 1000046684, 1000046685, 1000046686, 1000046687, 1000046688, 1000046689, 1000046691, 1000046692, 1000046693, 1000046694, 1000046695, 1000046696, 1000046824, 1000046934, 1000047441, 1000047443, 1000047444, 1000047466, 1000046444, 1000047839, 1000023316, 1000047504, 1000048022, 1000048064, 1000048065, 1000048070, 1000048189, 1000047949, 1000048358, 1000047468, 1000043973, 1000035758, 1000048491, 1000048461, 1000044992, 1000048565, 1000048566, 1000048581, 1000048625, 1000048648, 1000048347, 1000048841, 1000048889, 1000048890, 1000048891, 1000015244, 1000048946, 1000048947, 1000025427, 1000048858, 1000047821, 1000003540, 1000049264, 1000049265, 1000049304, 1000049321, 1000048208, 1000049434, 1000049439, 1000049463, 1000049471, 1000049469, 1000049587, 1000049071, 1000049602, 1000049603, 1000044958, 1000049636, 1000049658, 1000049703, 1000049743, 1000049830, 1000045271, 1000049885, 1000048554, 1000050325, 1000050479, 1000050512, 1000050370, 1000050069, 1000044393, 1000050781, 1000050783, 1000014593, 1000050957, 1000050990, 1000050234, 1000051013, 1000048650, 1000051402, 1000051440, 1000050071, 1000051622, 1000048273, 1000051770, 1000051793, 1000051794, 1000051789, 1000051847, 1000051893, 1000051962, 1000051971, 1000051972, 1000051981, 1000051985, 1000052014, 1000052026, 1000052039, 1000052124, 1000052133, 1000052027, 1000052355, 1000050971, 1000043879, 1000052516, 1000052525, 1000052532, 1000016634, 1000052144, 1000052596, 1000052630, 1000052656, 1000052738, 1000052755, 1000052813, 1000052044, 1000052833, 1000052176, 1000052966, 1000053053, 1000053113, 1000053200, 1000053227, 1000053252, 1000053261, 1000053265, 1000053362, 1000053367, 1000053368, 1000053404, 1000053418) AND p0_.id <> 67678 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;
807.09 ms (39.42%)	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: [`67678 "2025-02-12 08:37:35"`] View formatted query View runnable query Explain query 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 >= ? 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 = 67678 AND c0_.created_at >= '2025-02-12 08:37:35';
59.96 ms (2.93%)	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: [`"60825-compas-couleur-maped-0196004"`] View formatted query View runnable query Explain query 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 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 = '60825-compas-couleur-maped-0196004' AND p0_.is_active = 1;
3.33 ms (0.16%)	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`] View formatted query View runnable query Explain query 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 = ? 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 = 1;
2.40 ms (0.12%)	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: [`67678 1`] View formatted query View runnable query Explain query 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 = ? 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 = 67678 AND c1_.is_display_site = 1;
0.65 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: [`59 279 280 281 282 283 284 285 286 280 67678`] View formatted query View runnable query Explain query 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 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 (59, 279, 280, 281, 282, 283, 284, 285, 286, 280) AND p0_.is_active = 1 AND p0_.id <> 67678 AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 LIMIT 10;
0.50 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`] View formatted query View runnable query Explain query 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 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 = 1 LIMIT 1;
0.46 ms (0.02%)	1	SELECT t0.id AS id_1, t0.reference AS reference_2, t0.manufacturer AS manufacturer_3, t0.short_label AS short_label_4, t0.long_label AS long_label_5, t0.weight AS weight_6, t0.sold_by AS sold_by_7, t0.ppht AS ppht_8, t0.ppttc AS ppttc_9, t0.paht AS paht_10, t0.pattc AS pattc_11, t0.legal_discount_library AS legal_discount_library_12, t0.fidelity_bonus AS fidelity_bonus_13, t0.brand AS brand_14, t0.time_limit AS time_limit_15, t0.coef AS coef_16, t0.is_discountable AS is_discountable_17, t0.is_btob AS is_btob_18, t0.is_btoc AS is_btoc_19, t0.is_customizable AS is_customizable_20, t0.is_library AS is_library_21, t0.is_nathan AS is_nathan_22, t0.is_green AS is_green_23, t0.is_orapi_grand_frais AS is_orapi_grand_frais_24, t0.is_active AS is_active_25, t0.slug AS slug_26 FROM product t0 WHERE t0.id = ? LIMIT 1 Parameters: [`"60825-compas-couleur-maped-0196004"`] View formatted query View runnable query Explain query 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 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 = '60825-compas-couleur-maped-0196004' LIMIT 1;
0.40 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: [`"60825-compas-couleur-maped-0196004"`] View formatted query View runnable query Explain query 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 = ? 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 = '60825-compas-couleur-maped-0196004';
0.27 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: [`67678`] View formatted query View runnable query Explain query 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 = ? 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 = 67678;
0.25 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"`] View formatted query View runnable query Explain query 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 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 = 'ourClientsAlsoBoughtMonths' LIMIT 1;

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.

Entities Mapping

Class	Mapping errors
App\Entity\Product\Product	No errors.
App\Entity\Product\ProductPrice	No errors.
App\Entity\Pricing\Price	No errors.
App\Entity\Product\Category	No errors.
App\Entity\Pricing\Promotion	No errors.
App\Entity\Catalog\ProductCatalog	No errors.
App\Entity\Catalog\CustomerCatalog	No errors.
App\Entity\PromotionalOperations\Operation	No errors.
App\Entity\Product\ProductMarket	No errors.
App\Entity\Product\Characteristic	No errors.
App\Entity\Personalization\ColorInkModel	No errors.
App\Entity\Personalization\ColorCustom	No errors.
App\Entity\Personalization\PoliceModelCustom	No errors.
App\Entity\Personalization\GlobalPersonnalization	No errors.
App\Entity\Personalization\ModelCustom	No errors.
App\Entity\RubberStamp\RubberStampCustom	No errors.
App\Entity\Customer\Customer	No errors.
App\Entity\Internal\Counter	No errors.
App\Entity\Order\CustomerOrder	No errors.
App\Entity\User\User	No errors.
App\Entity\Product\CharacteristicLabel	No errors.
App\Entity\Internal\Parameter	No errors.
App\Entity\Order\CustomerOrderLines	No errors.
App\Entity\Delivery\Delivery	No errors.
App\Entity\Product\Market	No errors.
App\Entity\Internal\Society	No errors.
App\Entity\Internal\Commercial	No errors.
App\Entity\Delivery\DeliveryCost	No errors.
App\Entity\Order\ReclamationOrder	No errors.

Symfony Profiler

GET https://staging.pgdis.com/produit/60825-compas-couleur-maped-0196004

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping