Symfony Profiler

Query Metrics

64 Database Queries

21 Different statements

2501.46 ms Query time

0 Invalid entities

Grouped Statements

Time▼	Count	Info
1264.68 ms (50.56%)	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: [6342903 6345112 6352809 6353371 6355527 6355707 6356637 6356853 6358165 6358230 6360164 6362275 6363645 6363853 6363886 6363895 6364027 6364728 6366995 6368190 6368701 6371949 6372053 6373306 6373544 6373563 6374571 6376551 6376829 6377810 6377082 6381413 6377147 6381874 6383109 6383907 6384749 6385107 6385426 6385630 6386133 6388021 6388017 6388460 6388916 6365325 6385288 6387016 6388950 6389461 6386995 6390253 6390348 6389070 6390559 6390562 6390625 6390679 6391138 6391168 6391192 6391376 6391526 6391808 6391830 6391983 6391112 6385359 6392181 6392332 6389066 6390656 6392501 6392314 6389032 6384846 6390807 6392929 6390865 6388629 6393640 6393657 6393669 6393773 6393790 6394161 6394311 6394346 6394397 6394412 6394466 6394511 6394554 6394662 6394683 6394781 6394895 6394956 6395251 6395404 6395408 6396984 6398541 6398681 6398693 6398707 6398734 6398786 6400409 6400465 6400630 6400730 6400838 6401521 6401545 6401652 6402683 6402880 6402889 6403231 6403608 6404344 6404549 6405159 6405400 6405431 6405499 6406012 6406021 6406090 6406267 6406381 6406832 6407522 6407529 6408021 6408448 6408584 6408700 6408769 6408801 6408841 6408895 6408915 6409166 6409192 6409575 6409644 6409687 6410364 6410702 6410859 6410950 6411014 6411059 6411122 6411334 6411657 6411820 6412214 6412328 6413024 6413068 6413076 6413135 6413136 6413137 6413138 6413139 6413140 6413141 6413142 6413143 6413144 6413145 6413146 6413147 6413148 6413149 6413150 6413151 6413152 6413153 6413154 6413155 6413156 6413157 6413158 6413159 6413160 6413161 6413162 6413163 6413164 6413165 6413166 6413167 6413168 6413169 6413170 6413171 6413173 6413174 6413175 6413176 6413177 6413178 6413179 6413180 6413181 6413182 6413184 6413185 6413186 6413187 6413188 6413189 6413190 6413191 6413192 6413193 6413194 6413195 6413196 6413197 6413198 6413199 6413200 6413201 6413202 6413203 6413204 6413205 6413206 6413207 6413208 6413209 6413210 6413211 6413212 6413213 6413214 6413215 6413216 6413217 6413218 6413219 6413221 6413222 6413223 6413224 6413225 6413226 6413227 6413228 6413229 6413230 6413231 6413232 6413233 6413234 6413300 6413508 6413566 6413641 6413648 6413656 6413816 6413836 6413925 6414024 6414025 6414026 6414027 6414028 6414029 6414030 6414031 6414032 6414033 6414034 6414035 6414036 6414037 6414038 6414039 6414040 6414041 6414042 6414046 6414047 6414048 6414049 6414050 6414051 6414052 6414054 6414055 6414056 6414057 6414058 6414059 6414060 6414061 6414062 6414063 6414064 6414065 6414066 6414067 6414068 6414069 6414070 6414071 6414072 6414073 6414074 6414075 6414207 6414267 6414270 6414280 6414295 6414308 6414334 6414335 6414336 6414337 6414557 6414714 6414730 6414897 6415001 6415012 6415023 6415125 6415151 6415350 6415364 6415460 6415618 6415647 6415817 6415835 6415848 6415854 6415959 6416066 6416071 6416106 6416270 6416295 6416312 6416330 6416390 6416408 6416836 6416840 6416850 6417045 6417118 6417225 6417315 6417316 6417585 6417638 6417640 6417972 6418171 6418247 6418380 6418893 6418919 6418933 6418942 6418978 6418998 6419184 6419188 6419203 6419273 6419282 6419339 6419343 6419354 6419362 6419379 6419391 6419403 6419414 6419463 6419549 6419553 6419555 6419559 6419885 6419886 6420265 6420622 6420630 6420647 6420657 6420668 6420677 6420718 6420731 6420892 6420903 6420909 6420935 6421376 6421570 6421693 6421721 6421760 6421836 6421909 6422022 6422051 6422696 6422711 6422745 6422748 6422807 6422814 6422815 6423128 6423701 6423717 6423719 6423809 6423822 6423954 6424037 6424040 6424050 6424074 6424095 6424306 6424350 6424551 6424552 6424553 6424555 6424556 6424557 6424558 6424559 6424560 6424561 6424562 6424563 6424564 6424565 6424566 6424573 6424574 6424575 6424576 6424577 6424578 6424579 6424580 6424581 6424582 6424583 6424584 6424585 6424586 6424587 6424588 6424589 6424590 6424591 6424592 6424593 6424594 6424595 6424596 6424597 6424598 6424599 6424600 6424601 6424602 6424603 6424604 6424605 6424606 6424607 6424608 6424609 6424610 6424611 6424612 6424613 6424641 6424668 6424727 6424815 6425042 6425068 6425180 6425210 6425448 6425756 6426307 6426324 6426557 6426601 6426733 6426838 6426840 6426978 6427228 6427257 6427471 6427682 6428020 6428024 6428239 6428258 6428425 6428505 6428846 6428871 6428908 6429620 6429866 6430036 6430336 6430363 6430413 6430530 6430534 6430564 6430579 6430877 6430908 6430916 6431281 6431322 6431470 6431497 6431541 6431793 6431895 6432274 6432335 6433057 6433544 6434147 6434215 6434335 6434428 6434628 6434789 6434805 6434852 6434891 6435010 6435158 6435181 6435574 6435593 6435638 6435728 6435936 6436250 6431869 6425276 6425538 6436449 6431943 6436468 6436480 6436492 6436755 6437009 6437019 6437058 6437099 6437148 6437181 6437210 6437246 6437275 6437583 6437641 6437726 6437793 6437807 6437825 6437942 6437994 6438026 6438038 6438503 6438631 6438655 6438808 6438974 6439058 6439059 6439069 6439076 6439128 6439254 6439266 6439503 6439566 6439593 6439681 6439721 6439768 6439838 6440089 6440203 6440271 6440544 6440673 6440741 6440808 6440846 6441142 6441190 6441200 6441410 6441428 6441863 6441949 6441958 6442050 6442061 6442087 6442127 6442660 6442715 6442716 6442717 6442718 6442719 6442721 6442761 6442765 6442763 6442776 6442814 6442818 6442871 6442876 6442883 6442943 6443179 6443320 6443571 6443602 6443728 6443757 6443920 6444031 6444114 6444155 6444245 6444387 6444511 6444592 6444641 6444663 6444671 6444752 6444776 6444849 6444969 6445476 6445521 6445649 6446128 6446136 6446209 6446222 6446342 6446366 6446378 6446449 6446518 6446613 6446680 6446797 6446812 6446814 6446938 6447036 6447123 6447229 6447280 6447288 6447332 6447375 6447422 6447453 6447477 6447559 6447777 6447788 6448801 6449088 6449615 6449673 6449688 6449725 6449777 6449811 6449812 6449940 6449972 6450025 6450040 6450152 6450167 6450172 6450178 6450183 6450185 6450186 6450191 6450198 6450233 6450253 6450268 6450271 6450329 6450405 6450435 6450496 6450603 6450613 6450659 6450753 6450831 6450832 6450889 6450962 6450977 6450993 6450999 6451003 6451024 6451025 6451031 6451103 6451108 6451121 6451122 6451129 6451203 6451209 6451213 6451220 6451228 6451239 6451243 6451247 6451282 6451283 6451298 6451301 6451317 6451338 6451364 6451367 6451418 6451544 6451549 6451634 6451659 6451875 6451884 6451944 6452004 6452037 6452039 6452082 6452212 6452245 6452247 6452253 6452266 6452372 6452514 6452529 6452555 6452611 6453140 6453154 6453405 6453406 6453482 6453501 6453518 6453532 6453558 6453772 6453836 6453861 6453873 6454019 6454025 6454062 6454130 6454162 6454206 6454525 6454526 6454561 6454563 6454582 6454587 6454619 6454626 6454628 6454632 6454634 6454683 6454707 6454769 6454774 6454830 6454848 6454864 6454865 6454899 6454921 6454926 6454984 6455003 6455030 6455136 6455137 6455138 6455153 6455192 6455193 6455194 6455210 6455213 6455227 6455244 6455276 6455320 6455345 6455347 6455409 6455420 6455423 6455451 6455490 6455508 6455551 6455557 6455581 6455606 6455669 6455702 6455716 6455732 6455764 6455835 6455850 6455852 6455913 6456092 6456230 6456237 6456253 6456268 6456271 6456273 6456278 6456317 6456467 6456536 6456983 6457209 6457228 6457248 6457258 6457267 6457268 6457421 6457440 6457441 6457448 6457523 6457529 6457539 6457541 6457645 6457735 6458430 6458648 6459126 6459200 6459222 6459250 6459917 6460036 6460216 6460232 6460348 6460358 6460418 6460462 6460610 6461091 6461237 6461249 6461336 6461432 6461439 6461475 6461603 6461761 6461838 6461853 6461902 6462390 6462578 6462862 6462884 6462886 6462941 6463281 6463282 6463283 6463284 6463285 6463286 6463287 6463288 6463289 6463290 6463291 6463292 6463293 6463294 6463295 6463296 6463297 6463298 6463299 6463300 6463301 6463308 6463309 6463310 6463311 6463312 6463313 6463314 6463315 6463316 6463317 6463318 6463319 6463320 6463321 6463322 6463323 6463324 6463325 6463326 6463327 6463328 6463329 6463332 6463333 6463334 6463335 6463336 6463337 6463338 6463339 6463340 6463341 6463343 6463344 6463345 6463346 6463347 6463348 6463349 6463350 6463351 6463352 6463353 6463354 6463355 6463356 6463358 6463359 6463360 6463361 6463362 6463363 6463364 6463365 6463366 6463367 6463368 6463374 6463375 6463376 6463377 6463378 6463379 6463380 6463381 6463382 6463383 6463475 6463672 6463991 6464382 6464626 6464767 6465172 6465760 6465824 6466425 6466622 6466636 6466655 6467065 6467470 6467853 6467854 6467855 6467856 6467857 6467858 6467859 6467860 6467861 6467862 6467863 6467865 6467866 6467867 6467868 6467869 6467870 6467871 6467872 6467873 6467874 6467875 6467876 6467882 6467883 6467884 6467885 6467886 6467887 6467888 6467889 6467890 6467891 6467892 6467893 6467894 6467895 6467896 6467897 6467898 6467900 6467901 6467902 6467903 6467904 6467908 6467909 6467910 6467911 6467912 6467913 6467914 6467915 6467916 6467917 6467918 6467920 6467921 6467922 6467924 6467925 6467930 6467931 6467932 6467933 6467934 6467935 6467936 6467937 6467938 6467939 6467940 6467941 6467942 6467943 6467944 6467945 6467946 6467947 6467948 6467949 6467950 6467951 6467954 6467957 6467958 6467959 6467960 6467961 6467962 6467963 6467964 6467965 6467966 6468066 6468071 6468079 6468112 6468884 1000000755 1000000963 1000000975 1000001000 1000000950 1000001124 1000000853 6386237 6387055 1000001723 6368603 1000001752 1000001807 1000002083 1000002093 1000002113 1000002114 1000002126 1000001593 1000002395 1000002589 1000002591 1000002639 1000002718 1000002848 6390683 6391773 1000003577 1000002130 1000004071 1000004072 1000004073 6360112 6387598 1000001347 1000004129 1000001847 1000004396 1000004410 1000004411 1000004414 1000004708 1000004070 6393430 1000004842 1000002186 1000005183 1000002756 1000004999 1000005985 1000000869 6392776 1000006298 1000006590 1000006504 1000006727 1000007261 1000007262 1000003850 1000005937 1000004074 1000007341 1000007851 1000004700 1000001675 1000002301 1000002077 1000002058 1000001639 1000008264 1000008704 1000002505 1000008786 1000002647 1000008950 1000008259 1000009114 1000008586 1000009470 1000004324 1000009636 1000009637 1000009663 1000009689 1000009752 1000009853 1000009854 1000009621 1000006630 1000005293 1000010045 6391408 1000001940 1000010110 1000009371 1000008985 1000004422 1000010285 1000010295 1000009922 1000010149 1000009715 1000010627 1000010665 1000009615 1000010553 1000010743 1000010839 1000008368 1000011024 1000011059 1000007860 1000011079 1000011084 1000004768 1000010515 1000009241 1000011913 1000009732 1000010840 1000009602 1000009062 1000010561 1000011880 1000010520 6391605 1000012108 1000005986 1000009412 1000009064 1000012321 1000012464 1000012495 1000012554 1000012562 1000012563 1000012620 1000012429 1000012669 1000012708 1000012709 1000012736 1000012823 1000011864 1000012991 1000009875 1000012621 1000009232 1000005855 1000013178 1000013182 1000013191 1000008209 1000006579 1000010215 1000010313 1000012171 1000013521 1000013566 1000013603 1000013183 1000009936 6341943 1000013376 1000011875 1000005361 1000008349 1000010819 1000014051 1000010389 1000014121 1000013338 1000006957 1000002099 1000014658 1000008138 1000014283 1000012236 1000014039 1000009611 1000015232 1000015233 1000015251 1000015352 1000015373 1000015374 1000012648 1000015565 1000010042 1000013268 1000015655 1000015720 1000015721 1000009800 1000015818 1000009705 1000016109 1000016111 1000016137 1000016164 1000009646 1000016277 1000016315 1000014387 1000016155 1000016437 1000016477 1000016494 1000016507 1000014161 1000016694 1000016909 1000016972 1000017148 1000017157 1000017208 1000017209 1000017210 1000017102 1000017526 1000010017 1000017046 1000017544 1000017970 1000017977 1000017978 1000018066 1000018089 1000018090 1000018118 1000018172 1000018173 1000018174 1000018175 1000018205 1000018206 1000018211 1000018213 1000018219 1000015527 1000018569 1000018611 1000018627 1000018798 1000018745 1000018835 1000016275 1000019037 1000019070 1000014728 1000019108 1000016449 1000016914 1000019222 1000019300 1000019373 1000015456 1000019417 1000019419 1000019494 1000019566 1000019567 1000020043 1000020225 1000020226 1000020243 1000020258 1000020271 1000020279 1000020292 1000020318 1000020320 1000020321 1000020322 1000020323 1000020324 1000020325 1000020414 1000014736 1000020489 1000011924 1000014848 1000018133 1000018731 1000007024 1000016460 1000015937 1000020947 1000021134 1000018094 1000016685 1000016529 1000021299 1000021582 1000021583 1000021585 1000021881 1000021885 1000021887 1000021776 1000017163 1000014111 1000002102 1000013626 1000018223 1000014715 1000014496 1000018636 1000022459 1000019091 1000017022 1000016171 1000016161 1000022678 1000014753 1000022732 1000022747 1000022750 1000022753 1000022755 1000022757 1000022761 1000022763 1000022789 1000016453 1000009774 1000015440 1000015442 1000019493 1000006230 1000022958 1000020095 1000021890 1000023671 1000023030 1000023763 1000023764 1000023765 1000023883 1000024323 1000024324 1000024338 1000024341 1000024346 1000024357 1000024360 1000024361 1000024362 1000024366 1000024376 1000024377 1000024378 1000024379 1000024383 1000024389 1000024393 1000024399 1000024405 1000024422 1000024423 1000024426 1000024429 1000024430 1000024435 1000024438 1000024439 1000024440 1000024441 1000024644 1000024658 1000024659 1000024660 1000024720 1000024721 1000024722 1000024723 1000024745 1000024752 1000024755 1000024756 1000024762 1000024791 1000024812 1000025038 1000016259 1000016272 1000025180 1000025181 1000025182 1000025185 1000025236 1000025259 1000025266 1000025315 1000025435 1000025438 1000025647 1000025649 1000016910 1000026082 1000026010 1000026128 1000026134 1000026178 1000019352 1000026329 1000026331 1000026334 1000022120 1000026497 1000026499 1000026504 1000022522 1000014495 1000026557 1000022765 1000022857 1000009675 1000013934 1000014869 1000026915 1000026928 1000026929 1000026934 1000027071 1000027348 1000027436 1000027523 1000017509 1000025265 1000025268 1000027684 1000027764 1000027771 1000027772 1000027777 1000028243 1000028245 1000028255 1000028391 1000028392 1000028394 1000028492 1000028553 1000028554 1000028555 1000028556 1000028558 1000028559 1000028560 1000028562 1000028563 1000028564 1000028565 1000028566 1000028567 1000028569 1000028570 1000028571 1000028572 1000028573 1000028592 1000028597 1000028630 1000028635 1000028636 1000028722 1000028724 1000028726 1000028727 1000028728 1000028729 1000028730 1000028731 1000028732 1000028733 1000028734 1000028735 1000028768 1000028736 1000028775 1000028777 1000028789 1000017132 1000016135 1000014185 1000014968 1000012763 1000025948 1000021551 1000022056 1000013224 1000018321 1000028090 1000030227 1000016833 1000030413 1000030416 1000030419 1000024088 1000030794 1000030808 1000030821 1000031729 1000031730 1000031731 1000031732 1000031734 1000031737 1000031738 1000031740 1000031741 1000031742 1000031743 1000031744 1000031745 1000031747 1000031749 1000031751 1000031752 1000031757 1000031758 1000031760 1000031762 1000031763 1000031764 1000031766 1000031767 1000031768 1000031770 1000031771 1000031772 1000031773 1000031775 1000031777 1000031778 1000031779 1000031795 1000021135 1000031811 1000031812 1000031814 1000031815 1000031816 1000031818 1000031819 1000031821 1000031822 1000031823 1000031824 1000031825 1000031826 1000031827 1000031828 1000031829 1000031832 1000031833 1000031834 1000031835 1000031837 1000031838 1000031839 1000031856 1000031871 1000031872 1000031874 1000031881 1000031888 1000031917 1000031923 1000031952 1000031955 1000031966 1000031967 1000019337 1000012340 1000032053 1000032061 1000032064 1000032067 1000032092 1000032095 1000032100 1000023685 1000032191 1000032195 1000032199 1000032201 1000032205 1000032207 1000032208 1000032287 1000032301 1000032303 1000032320 1000032330 1000032331 1000017001 1000032346 1000032347 1000032349 1000032417 1000032447 1000032486 1000032514 1000020468 1000025447 1000028397 1000023741 1000032418 1000032699 1000032711 1000032715 1000032723 1000032786 1000032788 1000032848 1000032849 1000033015 1000033039 1000033042 1000033058 1000033059 1000033061 1000033099 1000033106 1000033163 1000033164 1000033165 1000033167 1000033168 1000033169 1000033170 1000033171 1000033172 1000033194 1000033195 1000033200 1000033201 1000033202 1000033451 1000033452 1000033479 1000033480 1000033481 1000033484 1000033487 1000033502 1000033567 1000033568 1000033663 1000033665 1000033666 1000032774 1000030417 1000033835 1000033970 1000033174 1000033988 1000034067 1000034070 1000034072 1000034074 1000034191 1000034194 1000034196 1000034208 1000020297 1000015050 1000024395 1000009832 1000017056 1000034521 1000034640 1000019539 1000026332 1000021588 1000017550 1000034724 1000018064 1000034814 1000032483 1000034958 1000035010 1000035142 1000023884 1000035268 1000035356 1000035499 1000035500 1000033569 1000035682 1000035683 1000035684 1000035685 1000035687 1000035688 1000035689 1000035691 1000035692 1000035693 1000035828 1000035830 1000035835 1000035836 1000035837 1000035839 1000035866 1000035867 1000035873 1000035875 1000035880 1000035905 1000035906 1000035917 1000035922 1000035934 1000035963 1000028622 1000036154 1000036165 1000024806 1000036187 1000036272 1000035536 1000036384 1000036390 1000036476 1000027017 1000036626 1000036690 1000036377 1000036813 1000036814 1000036815 1000036816 1000036817 1000036818 1000036824 1000036829 1000036830 1000036831 1000036832 1000036833 1000036834 1000036835 1000036836 1000036837 1000036905 1000036906 1000036910 1000036911 1000036912 1000036913 1000036915 1000036916 1000036917 1000036919 1000036926 1000036927 1000037070 1000037071 1000037072 1000037073 1000037085 1000037086 1000037087 1000037095 1000037096 1000037097 1000037108 1000037110 1000037217 1000037218 1000037228 1000037230 1000037236 1000037237 1000037333 1000037334 1000037335 1000037336 1000037338 1000037408 1000037409 1000037413 1000024461 1000037501 1000033599 1000018418 1000037769 1000037771 1000037772 1000037781 1000037782 1000037783 1000037784 1000037787 1000037801 1000037819 1000037820 1000037831 1000037840 1000037864 1000037899 1000037904 1000037932 1000038006 1000038008 1000018095 1000027686 1000027708 1000038339 1000016968 1000038380 1000038386 1000038392 1000038396 1000038398 1000038401 1000038402 1000038403 1000038406 1000038407 1000038689 1000038713 1000038715 1000038725 1000038762 1000038777 1000038789 1000038795 1000038848 1000016664 1000038937 1000038955 1000038956 1000039214 1000039216 1000039217 1000039218 1000039221 1000039331 1000039379 1000039380 1000039382 1000039390 1000039405 1000039413 1000039415 1000039416 1000039501 1000039502 1000039504 1000039505 1000039507 1000039508 1000039509 1000039510 1000039511 1000039512 1000039516 1000039523 1000039526 1000039548 1000039565 1000039623 1000039634 1000039681 1000039693 1000039696 1000039699 1000039700 1000039710 1000039714 1000039716 1000039719 1000039720 1000039721 1000040110 1000040166 1000039711 1000040273 1000040354 1000040365 1000040366 1000040383 1000040384 1000034509 1000040745 1000040746 1000040748 1000040839 1000040912 1000040914 1000040918 1000040922 1000040924 1000040927 1000040930 1000041105 1000041389 1000041440 1000041759 1000041790 1000041791 1000041792 1000041794 1000041809 1000041943 1000041944 1000041946 1000041949 1000041952 1000041957 1000042154 1000042246 1000042075 1000042310 1000042311 1000042319 1000042323 1000042324 1000042328 1000042330 1000042354 1000042358 1000042363 1000042365 1000032332 1000040742 1000042465 1000019182 1000042755 1000042757 1000027618 1000027525 1000043222 1000043225 1000043227 1000043276 1000043281 1000043292 1000043368 1000043421 1000043422 1000043423 1000043425 1000043430 1000043431 1000043433 1000043435 1000043439 1000043596 1000035720 1000043771 1000043812 1000043813 1000043862 1000034646 1000038796 1000044004 1000044005 1000044006 1000044010 1000044018 1000044022 1000044023 1000044030 1000044031 1000044032 1000044033 1000044114 1000044115 1000044116 1000044117 1000044118 1000044119 1000044317 1000044319 1000044324 1000044332 1000044341 1000044342 1000044362 1000044364 1000044366 1000044368 1000044370 1000044371 1000041637 1000044434 1000044455 1000044485 1000044512 1000044513 1000044524 1000044525 1000044533 1000044540 1000044543 1000044551 1000044552 1000044555 1000044556 1000044558 1000044559 1000044579 1000032266 1000044587 1000044774 1000044786 1000044788 1000044995 1000045002 1000045235 1000038270 1000046034 1000046055 1000046211 1000046213 1000046215 1000046246 1000046252 1000046268 1000046276 1000046350 1000046415 1000046731 1000009301 1000032059 1000046823 1000047065 1000047066 1000047067 1000047068 1000047165 1000047166 1000047439 1000047458 1000047459 1000047277 1000047530 1000043611 1000044822 1000038791 1000047749 1000047863 1000047864 1000047886 1000044583 1000023316 1000048032 1000048067 1000048108 1000048250 1000039513 1000043973 1000035758 1000044034 1000047764 1000048346 1000048514 1000048624 1000048123 1000048648 1000048507 1000048707 1000048713 1000048721 1000010832 1000048367 1000048339 1000048915 1000049073 1000017981 1000049193 1000048958 1000049308 1000049336 1000049434 1000049439 1000049441 1000049445 1000049453 1000026983 1000049540 1000049538 1000049780 1000039448 1000042645 1000049377 1000049946 1000013231 1000048913 1000048124 1000050033 1000050039 1000049960 1000050090 1000050093 1000050162 1000050218 1000042943 1000050249 1000046748 1000050122 1000050497 1000050551 1000050370 1000050593 1000016526 1000050069 1000050419 1000050000 1000050114 1000050308 1000050897 1000050695 1000050977 1000050999 1000051036 1000051058 1000048088 1000051109 1000051263 1000051264 1000051277 1000051293 1000051294 1000049952 1000049599 1000051426 1000051432 1000051439 1000051440 1000051451 1000048694 1000051483 1000049383 1000048611 1000051606 1000051630 1000051631 1000051635 1000051636 1000039254 1000051659 1000023450 1000050244 1000051708 1000051710 1000051739 1000051741 1000051801 1000051824 1000013023 1000049385 1000048949 1000016856 1000052042 1000052045 1000052102 1000051883 1000052100 1000052248 1000051354 1000052279 1000052415 1000052547 1000052750 1000052788 1000052859 1000052423 1000052651 1000050022 1000053037 1000053073 1000053093 1000053138 1000049668 1000053227 1000052686 1000053278 1000053282 1000053285 1000053288 1000053290 1000050556 1000053329 1000052748 1000053385 1000051829 1000053116 1000053480 1000052804 87250] 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 (6342903, 6345112, 6352809, 6353371, 6355527, 6355707, 6356637, 6356853, 6358165, 6358230, 6360164, 6362275, 6363645, 6363853, 6363886, 6363895, 6364027, 6364728, 6366995, 6368190, 6368701, 6371949, 6372053, 6373306, 6373544, 6373563, 6374571, 6376551, 6376829, 6377810, 6377082, 6381413, 6377147, 6381874, 6383109, 6383907, 6384749, 6385107, 6385426, 6385630, 6386133, 6388021, 6388017, 6388460, 6388916, 6365325, 6385288, 6387016, 6388950, 6389461, 6386995, 6390253, 6390348, 6389070, 6390559, 6390562, 6390625, 6390679, 6391138, 6391168, 6391192, 6391376, 6391526, 6391808, 6391830, 6391983, 6391112, 6385359, 6392181, 6392332, 6389066, 6390656, 6392501, 6392314, 6389032, 6384846, 6390807, 6392929, 6390865, 6388629, 6393640, 6393657, 6393669, 6393773, 6393790, 6394161, 6394311, 6394346, 6394397, 6394412, 6394466, 6394511, 6394554, 6394662, 6394683, 6394781, 6394895, 6394956, 6395251, 6395404, 6395408, 6396984, 6398541, 6398681, 6398693, 6398707, 6398734, 6398786, 6400409, 6400465, 6400630, 6400730, 6400838, 6401521, 6401545, 6401652, 6402683, 6402880, 6402889, 6403231, 6403608, 6404344, 6404549, 6405159, 6405400, 6405431, 6405499, 6406012, 6406021, 6406090, 6406267, 6406381, 6406832, 6407522, 6407529, 6408021, 6408448, 6408584, 6408700, 6408769, 6408801, 6408841, 6408895, 6408915, 6409166, 6409192, 6409575, 6409644, 6409687, 6410364, 6410702, 6410859, 6410950, 6411014, 6411059, 6411122, 6411334, 6411657, 6411820, 6412214, 6412328, 6413024, 6413068, 6413076, 6413135, 6413136, 6413137, 6413138, 6413139, 6413140, 6413141, 6413142, 6413143, 6413144, 6413145, 6413146, 6413147, 6413148, 6413149, 6413150, 6413151, 6413152, 6413153, 6413154, 6413155, 6413156, 6413157, 6413158, 6413159, 6413160, 6413161, 6413162, 6413163, 6413164, 6413165, 6413166, 6413167, 6413168, 6413169, 6413170, 6413171, 6413173, 6413174, 6413175, 6413176, 6413177, 6413178, 6413179, 6413180, 6413181, 6413182, 6413184, 6413185, 6413186, 6413187, 6413188, 6413189, 6413190, 6413191, 6413192, 6413193, 6413194, 6413195, 6413196, 6413197, 6413198, 6413199, 6413200, 6413201, 6413202, 6413203, 6413204, 6413205, 6413206, 6413207, 6413208, 6413209, 6413210, 6413211, 6413212, 6413213, 6413214, 6413215, 6413216, 6413217, 6413218, 6413219, 6413221, 6413222, 6413223, 6413224, 6413225, 6413226, 6413227, 6413228, 6413229, 6413230, 6413231, 6413232, 6413233, 6413234, 6413300, 6413508, 6413566, 6413641, 6413648, 6413656, 6413816, 6413836, 6413925, 6414024, 6414025, 6414026, 6414027, 6414028, 6414029, 6414030, 6414031, 6414032, 6414033, 6414034, 6414035, 6414036, 6414037, 6414038, 6414039, 6414040, 6414041, 6414042, 6414046, 6414047, 6414048, 6414049, 6414050, 6414051, 6414052, 6414054, 6414055, 6414056, 6414057, 6414058, 6414059, 6414060, 6414061, 6414062, 6414063, 6414064, 6414065, 6414066, 6414067, 6414068, 6414069, 6414070, 6414071, 6414072, 6414073, 6414074, 6414075, 6414207, 6414267, 6414270, 6414280, 6414295, 6414308, 6414334, 6414335, 6414336, 6414337, 6414557, 6414714, 6414730, 6414897, 6415001, 6415012, 6415023, 6415125, 6415151, 6415350, 6415364, 6415460, 6415618, 6415647, 6415817, 6415835, 6415848, 6415854, 6415959, 6416066, 6416071, 6416106, 6416270, 6416295, 6416312, 6416330, 6416390, 6416408, 6416836, 6416840, 6416850, 6417045, 6417118, 6417225, 6417315, 6417316, 6417585, 6417638, 6417640, 6417972, 6418171, 6418247, 6418380, 6418893, 6418919, 6418933, 6418942, 6418978, 6418998, 6419184, 6419188, 6419203, 6419273, 6419282, 6419339, 6419343, 6419354, 6419362, 6419379, 6419391, 6419403, 6419414, 6419463, 6419549, 6419553, 6419555, 6419559, 6419885, 6419886, 6420265, 6420622, 6420630, 6420647, 6420657, 6420668, 6420677, 6420718, 6420731, 6420892, 6420903, 6420909, 6420935, 6421376, 6421570, 6421693, 6421721, 6421760, 6421836, 6421909, 6422022, 6422051, 6422696, 6422711, 6422745, 6422748, 6422807, 6422814, 6422815, 6423128, 6423701, 6423717, 6423719, 6423809, 6423822, 6423954, 6424037, 6424040, 6424050, 6424074, 6424095, 6424306, 6424350, 6424551, 6424552, 6424553, 6424555, 6424556, 6424557, 6424558, 6424559, 6424560, 6424561, 6424562, 6424563, 6424564, 6424565, 6424566, 6424573, 6424574, 6424575, 6424576, 6424577, 6424578, 6424579, 6424580, 6424581, 6424582, 6424583, 6424584, 6424585, 6424586, 6424587, 6424588, 6424589, 6424590, 6424591, 6424592, 6424593, 6424594, 6424595, 6424596, 6424597, 6424598, 6424599, 6424600, 6424601, 6424602, 6424603, 6424604, 6424605, 6424606, 6424607, 6424608, 6424609, 6424610, 6424611, 6424612, 6424613, 6424641, 6424668, 6424727, 6424815, 6425042, 6425068, 6425180, 6425210, 6425448, 6425756, 6426307, 6426324, 6426557, 6426601, 6426733, 6426838, 6426840, 6426978, 6427228, 6427257, 6427471, 6427682, 6428020, 6428024, 6428239, 6428258, 6428425, 6428505, 6428846, 6428871, 6428908, 6429620, 6429866, 6430036, 6430336, 6430363, 6430413, 6430530, 6430534, 6430564, 6430579, 6430877, 6430908, 6430916, 6431281, 6431322, 6431470, 6431497, 6431541, 6431793, 6431895, 6432274, 6432335, 6433057, 6433544, 6434147, 6434215, 6434335, 6434428, 6434628, 6434789, 6434805, 6434852, 6434891, 6435010, 6435158, 6435181, 6435574, 6435593, 6435638, 6435728, 6435936, 6436250, 6431869, 6425276, 6425538, 6436449, 6431943, 6436468, 6436480, 6436492, 6436755, 6437009, 6437019, 6437058, 6437099, 6437148, 6437181, 6437210, 6437246, 6437275, 6437583, 6437641, 6437726, 6437793, 6437807, 6437825, 6437942, 6437994, 6438026, 6438038, 6438503, 6438631, 6438655, 6438808, 6438974, 6439058, 6439059, 6439069, 6439076, 6439128, 6439254, 6439266, 6439503, 6439566, 6439593, 6439681, 6439721, 6439768, 6439838, 6440089, 6440203, 6440271, 6440544, 6440673, 6440741, 6440808, 6440846, 6441142, 6441190, 6441200, 6441410, 6441428, 6441863, 6441949, 6441958, 6442050, 6442061, 6442087, 6442127, 6442660, 6442715, 6442716, 6442717, 6442718, 6442719, 6442721, 6442761, 6442765, 6442763, 6442776, 6442814, 6442818, 6442871, 6442876, 6442883, 6442943, 6443179, 6443320, 6443571, 6443602, 6443728, 6443757, 6443920, 6444031, 6444114, 6444155, 6444245, 6444387, 6444511, 6444592, 6444641, 6444663, 6444671, 6444752, 6444776, 6444849, 6444969, 6445476, 6445521, 6445649, 6446128, 6446136, 6446209, 6446222, 6446342, 6446366, 6446378, 6446449, 6446518, 6446613, 6446680, 6446797, 6446812, 6446814, 6446938, 6447036, 6447123, 6447229, 6447280, 6447288, 6447332, 6447375, 6447422, 6447453, 6447477, 6447559, 6447777, 6447788, 6448801, 6449088, 6449615, 6449673, 6449688, 6449725, 6449777, 6449811, 6449812, 6449940, 6449972, 6450025, 6450040, 6450152, 6450167, 6450172, 6450178, 6450183, 6450185, 6450186, 6450191, 6450198, 6450233, 6450253, 6450268, 6450271, 6450329, 6450405, 6450435, 6450496, 6450603, 6450613, 6450659, 6450753, 6450831, 6450832, 6450889, 6450962, 6450977, 6450993, 6450999, 6451003, 6451024, 6451025, 6451031, 6451103, 6451108, 6451121, 6451122, 6451129, 6451203, 6451209, 6451213, 6451220, 6451228, 6451239, 6451243, 6451247, 6451282, 6451283, 6451298, 6451301, 6451317, 6451338, 6451364, 6451367, 6451418, 6451544, 6451549, 6451634, 6451659, 6451875, 6451884, 6451944, 6452004, 6452037, 6452039, 6452082, 6452212, 6452245, 6452247, 6452253, 6452266, 6452372, 6452514, 6452529, 6452555, 6452611, 6453140, 6453154, 6453405, 6453406, 6453482, 6453501, 6453518, 6453532, 6453558, 6453772, 6453836, 6453861, 6453873, 6454019, 6454025, 6454062, 6454130, 6454162, 6454206, 6454525, 6454526, 6454561, 6454563, 6454582, 6454587, 6454619, 6454626, 6454628, 6454632, 6454634, 6454683, 6454707, 6454769, 6454774, 6454830, 6454848, 6454864, 6454865, 6454899, 6454921, 6454926, 6454984, 6455003, 6455030, 6455136, 6455137, 6455138, 6455153, 6455192, 6455193, 6455194, 6455210, 6455213, 6455227, 6455244, 6455276, 6455320, 6455345, 6455347, 6455409, 6455420, 6455423, 6455451, 6455490, 6455508, 6455551, 6455557, 6455581, 6455606, 6455669, 6455702, 6455716, 6455732, 6455764, 6455835, 6455850, 6455852, 6455913, 6456092, 6456230, 6456237, 6456253, 6456268, 6456271, 6456273, 6456278, 6456317, 6456467, 6456536, 6456983, 6457209, 6457228, 6457248, 6457258, 6457267, 6457268, 6457421, 6457440, 6457441, 6457448, 6457523, 6457529, 6457539, 6457541, 6457645, 6457735, 6458430, 6458648, 6459126, 6459200, 6459222, 6459250, 6459917, 6460036, 6460216, 6460232, 6460348, 6460358, 6460418, 6460462, 6460610, 6461091, 6461237, 6461249, 6461336, 6461432, 6461439, 6461475, 6461603, 6461761, 6461838, 6461853, 6461902, 6462390, 6462578, 6462862, 6462884, 6462886, 6462941, 6463281, 6463282, 6463283, 6463284, 6463285, 6463286, 6463287, 6463288, 6463289, 6463290, 6463291, 6463292, 6463293, 6463294, 6463295, 6463296, 6463297, 6463298, 6463299, 6463300, 6463301, 6463308, 6463309, 6463310, 6463311, 6463312, 6463313, 6463314, 6463315, 6463316, 6463317, 6463318, 6463319, 6463320, 6463321, 6463322, 6463323, 6463324, 6463325, 6463326, 6463327, 6463328, 6463329, 6463332, 6463333, 6463334, 6463335, 6463336, 6463337, 6463338, 6463339, 6463340, 6463341, 6463343, 6463344, 6463345, 6463346, 6463347, 6463348, 6463349, 6463350, 6463351, 6463352, 6463353, 6463354, 6463355, 6463356, 6463358, 6463359, 6463360, 6463361, 6463362, 6463363, 6463364, 6463365, 6463366, 6463367, 6463368, 6463374, 6463375, 6463376, 6463377, 6463378, 6463379, 6463380, 6463381, 6463382, 6463383, 6463475, 6463672, 6463991, 6464382, 6464626, 6464767, 6465172, 6465760, 6465824, 6466425, 6466622, 6466636, 6466655, 6467065, 6467470, 6467853, 6467854, 6467855, 6467856, 6467857, 6467858, 6467859, 6467860, 6467861, 6467862, 6467863, 6467865, 6467866, 6467867, 6467868, 6467869, 6467870, 6467871, 6467872, 6467873, 6467874, 6467875, 6467876, 6467882, 6467883, 6467884, 6467885, 6467886, 6467887, 6467888, 6467889, 6467890, 6467891, 6467892, 6467893, 6467894, 6467895, 6467896, 6467897, 6467898, 6467900, 6467901, 6467902, 6467903, 6467904, 6467908, 6467909, 6467910, 6467911, 6467912, 6467913, 6467914, 6467915, 6467916, 6467917, 6467918, 6467920, 6467921, 6467922, 6467924, 6467925, 6467930, 6467931, 6467932, 6467933, 6467934, 6467935, 6467936, 6467937, 6467938, 6467939, 6467940, 6467941, 6467942, 6467943, 6467944, 6467945, 6467946, 6467947, 6467948, 6467949, 6467950, 6467951, 6467954, 6467957, 6467958, 6467959, 6467960, 6467961, 6467962, 6467963, 6467964, 6467965, 6467966, 6468066, 6468071, 6468079, 6468112, 6468884, 1000000755, 1000000963, 1000000975, 1000001000, 1000000950, 1000001124, 1000000853, 6386237, 6387055, 1000001723, 6368603, 1000001752, 1000001807, 1000002083, 1000002093, 1000002113, 1000002114, 1000002126, 1000001593, 1000002395, 1000002589, 1000002591, 1000002639, 1000002718, 1000002848, 6390683, 6391773, 1000003577, 1000002130, 1000004071, 1000004072, 1000004073, 6360112, 6387598, 1000001347, 1000004129, 1000001847, 1000004396, 1000004410, 1000004411, 1000004414, 1000004708, 1000004070, 6393430, 1000004842, 1000002186, 1000005183, 1000002756, 1000004999, 1000005985, 1000000869, 6392776, 1000006298, 1000006590, 1000006504, 1000006727, 1000007261, 1000007262, 1000003850, 1000005937, 1000004074, 1000007341, 1000007851, 1000004700, 1000001675, 1000002301, 1000002077, 1000002058, 1000001639, 1000008264, 1000008704, 1000002505, 1000008786, 1000002647, 1000008950, 1000008259, 1000009114, 1000008586, 1000009470, 1000004324, 1000009636, 1000009637, 1000009663, 1000009689, 1000009752, 1000009853, 1000009854, 1000009621, 1000006630, 1000005293, 1000010045, 6391408, 1000001940, 1000010110, 1000009371, 1000008985, 1000004422, 1000010285, 1000010295, 1000009922, 1000010149, 1000009715, 1000010627, 1000010665, 1000009615, 1000010553, 1000010743, 1000010839, 1000008368, 1000011024, 1000011059, 1000007860, 1000011079, 1000011084, 1000004768, 1000010515, 1000009241, 1000011913, 1000009732, 1000010840, 1000009602, 1000009062, 1000010561, 1000011880, 1000010520, 6391605, 1000012108, 1000005986, 1000009412, 1000009064, 1000012321, 1000012464, 1000012495, 1000012554, 1000012562, 1000012563, 1000012620, 1000012429, 1000012669, 1000012708, 1000012709, 1000012736, 1000012823, 1000011864, 1000012991, 1000009875, 1000012621, 1000009232, 1000005855, 1000013178, 1000013182, 1000013191, 1000008209, 1000006579, 1000010215, 1000010313, 1000012171, 1000013521, 1000013566, 1000013603, 1000013183, 1000009936, 6341943, 1000013376, 1000011875, 1000005361, 1000008349, 1000010819, 1000014051, 1000010389, 1000014121, 1000013338, 1000006957, 1000002099, 1000014658, 1000008138, 1000014283, 1000012236, 1000014039, 1000009611, 1000015232, 1000015233, 1000015251, 1000015352, 1000015373, 1000015374, 1000012648, 1000015565, 1000010042, 1000013268, 1000015655, 1000015720, 1000015721, 1000009800, 1000015818, 1000009705, 1000016109, 1000016111, 1000016137, 1000016164, 1000009646, 1000016277, 1000016315, 1000014387, 1000016155, 1000016437, 1000016477, 1000016494, 1000016507, 1000014161, 1000016694, 1000016909, 1000016972, 1000017148, 1000017157, 1000017208, 1000017209, 1000017210, 1000017102, 1000017526, 1000010017, 1000017046, 1000017544, 1000017970, 1000017977, 1000017978, 1000018066, 1000018089, 1000018090, 1000018118, 1000018172, 1000018173, 1000018174, 1000018175, 1000018205, 1000018206, 1000018211, 1000018213, 1000018219, 1000015527, 1000018569, 1000018611, 1000018627, 1000018798, 1000018745, 1000018835, 1000016275, 1000019037, 1000019070, 1000014728, 1000019108, 1000016449, 1000016914, 1000019222, 1000019300, 1000019373, 1000015456, 1000019417, 1000019419, 1000019494, 1000019566, 1000019567, 1000020043, 1000020225, 1000020226, 1000020243, 1000020258, 1000020271, 1000020279, 1000020292, 1000020318, 1000020320, 1000020321, 1000020322, 1000020323, 1000020324, 1000020325, 1000020414, 1000014736, 1000020489, 1000011924, 1000014848, 1000018133, 1000018731, 1000007024, 1000016460, 1000015937, 1000020947, 1000021134, 1000018094, 1000016685, 1000016529, 1000021299, 1000021582, 1000021583, 1000021585, 1000021881, 1000021885, 1000021887, 1000021776, 1000017163, 1000014111, 1000002102, 1000013626, 1000018223, 1000014715, 1000014496, 1000018636, 1000022459, 1000019091, 1000017022, 1000016171, 1000016161, 1000022678, 1000014753, 1000022732, 1000022747, 1000022750, 1000022753, 1000022755, 1000022757, 1000022761, 1000022763, 1000022789, 1000016453, 1000009774, 1000015440, 1000015442, 1000019493, 1000006230, 1000022958, 1000020095, 1000021890, 1000023671, 1000023030, 1000023763, 1000023764, 1000023765, 1000023883, 1000024323, 1000024324, 1000024338, 1000024341, 1000024346, 1000024357, 1000024360, 1000024361, 1000024362, 1000024366, 1000024376, 1000024377, 1000024378, 1000024379, 1000024383, 1000024389, 1000024393, 1000024399, 1000024405, 1000024422, 1000024423, 1000024426, 1000024429, 1000024430, 1000024435, 1000024438, 1000024439, 1000024440, 1000024441, 1000024644, 1000024658, 1000024659, 1000024660, 1000024720, 1000024721, 1000024722, 1000024723, 1000024745, 1000024752, 1000024755, 1000024756, 1000024762, 1000024791, 1000024812, 1000025038, 1000016259, 1000016272, 1000025180, 1000025181, 1000025182, 1000025185, 1000025236, 1000025259, 1000025266, 1000025315, 1000025435, 1000025438, 1000025647, 1000025649, 1000016910, 1000026082, 1000026010, 1000026128, 1000026134, 1000026178, 1000019352, 1000026329, 1000026331, 1000026334, 1000022120, 1000026497, 1000026499, 1000026504, 1000022522, 1000014495, 1000026557, 1000022765, 1000022857, 1000009675, 1000013934, 1000014869, 1000026915, 1000026928, 1000026929, 1000026934, 1000027071, 1000027348, 1000027436, 1000027523, 1000017509, 1000025265, 1000025268, 1000027684, 1000027764, 1000027771, 1000027772, 1000027777, 1000028243, 1000028245, 1000028255, 1000028391, 1000028392, 1000028394, 1000028492, 1000028553, 1000028554, 1000028555, 1000028556, 1000028558, 1000028559, 1000028560, 1000028562, 1000028563, 1000028564, 1000028565, 1000028566, 1000028567, 1000028569, 1000028570, 1000028571, 1000028572, 1000028573, 1000028592, 1000028597, 1000028630, 1000028635, 1000028636, 1000028722, 1000028724, 1000028726, 1000028727, 1000028728, 1000028729, 1000028730, 1000028731, 1000028732, 1000028733, 1000028734, 1000028735, 1000028768, 1000028736, 1000028775, 1000028777, 1000028789, 1000017132, 1000016135, 1000014185, 1000014968, 1000012763, 1000025948, 1000021551, 1000022056, 1000013224, 1000018321, 1000028090, 1000030227, 1000016833, 1000030413, 1000030416, 1000030419, 1000024088, 1000030794, 1000030808, 1000030821, 1000031729, 1000031730, 1000031731, 1000031732, 1000031734, 1000031737, 1000031738, 1000031740, 1000031741, 1000031742, 1000031743, 1000031744, 1000031745, 1000031747, 1000031749, 1000031751, 1000031752, 1000031757, 1000031758, 1000031760, 1000031762, 1000031763, 1000031764, 1000031766, 1000031767, 1000031768, 1000031770, 1000031771, 1000031772, 1000031773, 1000031775, 1000031777, 1000031778, 1000031779, 1000031795, 1000021135, 1000031811, 1000031812, 1000031814, 1000031815, 1000031816, 1000031818, 1000031819, 1000031821, 1000031822, 1000031823, 1000031824, 1000031825, 1000031826, 1000031827, 1000031828, 1000031829, 1000031832, 1000031833, 1000031834, 1000031835, 1000031837, 1000031838, 1000031839, 1000031856, 1000031871, 1000031872, 1000031874, 1000031881, 1000031888, 1000031917, 1000031923, 1000031952, 1000031955, 1000031966, 1000031967, 1000019337, 1000012340, 1000032053, 1000032061, 1000032064, 1000032067, 1000032092, 1000032095, 1000032100, 1000023685, 1000032191, 1000032195, 1000032199, 1000032201, 1000032205, 1000032207, 1000032208, 1000032287, 1000032301, 1000032303, 1000032320, 1000032330, 1000032331, 1000017001, 1000032346, 1000032347, 1000032349, 1000032417, 1000032447, 1000032486, 1000032514, 1000020468, 1000025447, 1000028397, 1000023741, 1000032418, 1000032699, 1000032711, 1000032715, 1000032723, 1000032786, 1000032788, 1000032848, 1000032849, 1000033015, 1000033039, 1000033042, 1000033058, 1000033059, 1000033061, 1000033099, 1000033106, 1000033163, 1000033164, 1000033165, 1000033167, 1000033168, 1000033169, 1000033170, 1000033171, 1000033172, 1000033194, 1000033195, 1000033200, 1000033201, 1000033202, 1000033451, 1000033452, 1000033479, 1000033480, 1000033481, 1000033484, 1000033487, 1000033502, 1000033567, 1000033568, 1000033663, 1000033665, 1000033666, 1000032774, 1000030417, 1000033835, 1000033970, 1000033174, 1000033988, 1000034067, 1000034070, 1000034072, 1000034074, 1000034191, 1000034194, 1000034196, 1000034208, 1000020297, 1000015050, 1000024395, 1000009832, 1000017056, 1000034521, 1000034640, 1000019539, 1000026332, 1000021588, 1000017550, 1000034724, 1000018064, 1000034814, 1000032483, 1000034958, 1000035010, 1000035142, 1000023884, 1000035268, 1000035356, 1000035499, 1000035500, 1000033569, 1000035682, 1000035683, 1000035684, 1000035685, 1000035687, 1000035688, 1000035689, 1000035691, 1000035692, 1000035693, 1000035828, 1000035830, 1000035835, 1000035836, 1000035837, 1000035839, 1000035866, 1000035867, 1000035873, 1000035875, 1000035880, 1000035905, 1000035906, 1000035917, 1000035922, 1000035934, 1000035963, 1000028622, 1000036154, 1000036165, 1000024806, 1000036187, 1000036272, 1000035536, 1000036384, 1000036390, 1000036476, 1000027017, 1000036626, 1000036690, 1000036377, 1000036813, 1000036814, 1000036815, 1000036816, 1000036817, 1000036818, 1000036824, 1000036829, 1000036830, 1000036831, 1000036832, 1000036833, 1000036834, 1000036835, 1000036836, 1000036837, 1000036905, 1000036906, 1000036910, 1000036911, 1000036912, 1000036913, 1000036915, 1000036916, 1000036917, 1000036919, 1000036926, 1000036927, 1000037070, 1000037071, 1000037072, 1000037073, 1000037085, 1000037086, 1000037087, 1000037095, 1000037096, 1000037097, 1000037108, 1000037110, 1000037217, 1000037218, 1000037228, 1000037230, 1000037236, 1000037237, 1000037333, 1000037334, 1000037335, 1000037336, 1000037338, 1000037408, 1000037409, 1000037413, 1000024461, 1000037501, 1000033599, 1000018418, 1000037769, 1000037771, 1000037772, 1000037781, 1000037782, 1000037783, 1000037784, 1000037787, 1000037801, 1000037819, 1000037820, 1000037831, 1000037840, 1000037864, 1000037899, 1000037904, 1000037932, 1000038006, 1000038008, 1000018095, 1000027686, 1000027708, 1000038339, 1000016968, 1000038380, 1000038386, 1000038392, 1000038396, 1000038398, 1000038401, 1000038402, 1000038403, 1000038406, 1000038407, 1000038689, 1000038713, 1000038715, 1000038725, 1000038762, 1000038777, 1000038789, 1000038795, 1000038848, 1000016664, 1000038937, 1000038955, 1000038956, 1000039214, 1000039216, 1000039217, 1000039218, 1000039221, 1000039331, 1000039379, 1000039380, 1000039382, 1000039390, 1000039405, 1000039413, 1000039415, 1000039416, 1000039501, 1000039502, 1000039504, 1000039505, 1000039507, 1000039508, 1000039509, 1000039510, 1000039511, 1000039512, 1000039516, 1000039523, 1000039526, 1000039548, 1000039565, 1000039623, 1000039634, 1000039681, 1000039693, 1000039696, 1000039699, 1000039700, 1000039710, 1000039714, 1000039716, 1000039719, 1000039720, 1000039721, 1000040110, 1000040166, 1000039711, 1000040273, 1000040354, 1000040365, 1000040366, 1000040383, 1000040384, 1000034509, 1000040745, 1000040746, 1000040748, 1000040839, 1000040912, 1000040914, 1000040918, 1000040922, 1000040924, 1000040927, 1000040930, 1000041105, 1000041389, 1000041440, 1000041759, 1000041790, 1000041791, 1000041792, 1000041794, 1000041809, 1000041943, 1000041944, 1000041946, 1000041949, 1000041952, 1000041957, 1000042154, 1000042246, 1000042075, 1000042310, 1000042311, 1000042319, 1000042323, 1000042324, 1000042328, 1000042330, 1000042354, 1000042358, 1000042363, 1000042365, 1000032332, 1000040742, 1000042465, 1000019182, 1000042755, 1000042757, 1000027618, 1000027525, 1000043222, 1000043225, 1000043227, 1000043276, 1000043281, 1000043292, 1000043368, 1000043421, 1000043422, 1000043423, 1000043425, 1000043430, 1000043431, 1000043433, 1000043435, 1000043439, 1000043596, 1000035720, 1000043771, 1000043812, 1000043813, 1000043862, 1000034646, 1000038796, 1000044004, 1000044005, 1000044006, 1000044010, 1000044018, 1000044022, 1000044023, 1000044030, 1000044031, 1000044032, 1000044033, 1000044114, 1000044115, 1000044116, 1000044117, 1000044118, 1000044119, 1000044317, 1000044319, 1000044324, 1000044332, 1000044341, 1000044342, 1000044362, 1000044364, 1000044366, 1000044368, 1000044370, 1000044371, 1000041637, 1000044434, 1000044455, 1000044485, 1000044512, 1000044513, 1000044524, 1000044525, 1000044533, 1000044540, 1000044543, 1000044551, 1000044552, 1000044555, 1000044556, 1000044558, 1000044559, 1000044579, 1000032266, 1000044587, 1000044774, 1000044786, 1000044788, 1000044995, 1000045002, 1000045235, 1000038270, 1000046034, 1000046055, 1000046211, 1000046213, 1000046215, 1000046246, 1000046252, 1000046268, 1000046276, 1000046350, 1000046415, 1000046731, 1000009301, 1000032059, 1000046823, 1000047065, 1000047066, 1000047067, 1000047068, 1000047165, 1000047166, 1000047439, 1000047458, 1000047459, 1000047277, 1000047530, 1000043611, 1000044822, 1000038791, 1000047749, 1000047863, 1000047864, 1000047886, 1000044583, 1000023316, 1000048032, 1000048067, 1000048108, 1000048250, 1000039513, 1000043973, 1000035758, 1000044034, 1000047764, 1000048346, 1000048514, 1000048624, 1000048123, 1000048648, 1000048507, 1000048707, 1000048713, 1000048721, 1000010832, 1000048367, 1000048339, 1000048915, 1000049073, 1000017981, 1000049193, 1000048958, 1000049308, 1000049336, 1000049434, 1000049439, 1000049441, 1000049445, 1000049453, 1000026983, 1000049540, 1000049538, 1000049780, 1000039448, 1000042645, 1000049377, 1000049946, 1000013231, 1000048913, 1000048124, 1000050033, 1000050039, 1000049960, 1000050090, 1000050093, 1000050162, 1000050218, 1000042943, 1000050249, 1000046748, 1000050122, 1000050497, 1000050551, 1000050370, 1000050593, 1000016526, 1000050069, 1000050419, 1000050000, 1000050114, 1000050308, 1000050897, 1000050695, 1000050977, 1000050999, 1000051036, 1000051058, 1000048088, 1000051109, 1000051263, 1000051264, 1000051277, 1000051293, 1000051294, 1000049952, 1000049599, 1000051426, 1000051432, 1000051439, 1000051440, 1000051451, 1000048694, 1000051483, 1000049383, 1000048611, 1000051606, 1000051630, 1000051631, 1000051635, 1000051636, 1000039254, 1000051659, 1000023450, 1000050244, 1000051708, 1000051710, 1000051739, 1000051741, 1000051801, 1000051824, 1000013023, 1000049385, 1000048949, 1000016856, 1000052042, 1000052045, 1000052102, 1000051883, 1000052100, 1000052248, 1000051354, 1000052279, 1000052415, 1000052547, 1000052750, 1000052788, 1000052859, 1000052423, 1000052651, 1000050022, 1000053037, 1000053073, 1000053093, 1000053138, 1000049668, 1000053227, 1000052686, 1000053278, 1000053282, 1000053285, 1000053288, 1000053290, 1000050556, 1000053329, 1000052748, 1000053385, 1000051829, 1000053116, 1000053480, 1000052804) AND p0_.id <> 87250 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;
1137.57 ms (45.48%)	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: [`87250 "2025-02-12 07:40:04"`] 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 = 87250 AND c0_.created_at >= '2025-02-12 07:40:04';
78.34 ms (3.13%)	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: [`"72200-cahiers-polypro-violet-n-c-72200-maju"`] 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 = '72200-cahiers-polypro-violet-n-c-72200-maju' AND p0_.is_active = 1;
2.96 ms (0.12%)	18	SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ? Parameters: [`1`] 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.83 ms (0.11%)	2	SELECT d0_.quantity AS quantity_0, d0_.price_ht AS price_ht_1, d0_.price_ttc AS price_ttc_2 FROM decreasing_price d0_ WHERE d0_.product_id = ? AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC Parameters: [`80450`] View formatted query View runnable query Explain query SELECT d0_.quantity AS quantity_0, d0_.price_ht AS price_ht_1, d0_.price_ttc AS price_ttc_2 FROM decreasing_price d0_ WHERE d0_.product_id = ? AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC SELECT d0_.quantity AS quantity_0, d0_.price_ht AS price_ht_1, d0_.price_ttc AS price_ttc_2 FROM decreasing_price d0_ WHERE d0_.product_id = 80450 AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC;
2.56 ms (0.10%)	2	SELECT d0_.id AS id_0, d0_.quantity AS quantity_1, d0_.price_ht AS price_ht_2, d0_.price_ttc AS price_ttc_3, d0_.product_id AS product_id_4, d0_.product_price_id AS product_price_id_5, d0_.promotion_id AS promotion_id_6, d0_.market_id AS market_id_7 FROM decreasing_price d0_ WHERE d0_.product_id = ? AND d0_.quantity <= ? AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC LIMIT 1 Parameters: [`80450 0`] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.quantity AS quantity_1, d0_.price_ht AS price_ht_2, d0_.price_ttc AS price_ttc_3, d0_.product_id AS product_id_4, d0_.product_price_id AS product_price_id_5, d0_.promotion_id AS promotion_id_6, d0_.market_id AS market_id_7 FROM decreasing_price d0_ WHERE d0_.product_id = ? AND d0_.quantity <= ? AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC LIMIT 1 SELECT d0_.id AS id_0, d0_.quantity AS quantity_1, d0_.price_ht AS price_ht_2, d0_.price_ttc AS price_ttc_3, d0_.product_id AS product_id_4, d0_.product_price_id AS product_price_id_5, d0_.promotion_id AS promotion_id_6, d0_.market_id AS market_id_7 FROM decreasing_price d0_ WHERE d0_.product_id = 80450 AND d0_.quantity <= 0 AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC LIMIT 1;
1.99 ms (0.08%)	8	SELECT t0.id AS id_1, t0.name AS name_2, t0.value1 AS value1_3, t0.value2 AS value2_4, t0.value3 AS value3_5 FROM parameter t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"ourClientsAlsoBoughtMonths"`] 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;
1.71 ms (0.07%)	4	SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.price_id = ? AND t0.product_id = ? LIMIT 1 Parameters: [`"CAISSE2011" 80450`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.price_id = ? AND t0.product_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.price_id = 'CAISSE2011' AND t0.product_id = 80450 LIMIT 1;
0.97 ms (0.04%)	4	SELECT t0.id AS id_1, t0.name AS name_2, t0.affiliated_society AS affiliated_society_3, t0.address1 AS address1_4, t0.address2 AS address2_5, t0.address3 AS address3_6, t0.zip_code AS zip_code_7, t0.city AS city_8, t0.email AS email_9, t0.phone_number AS phone_number_10, t0.fax AS fax_11, t0.id_deposit AS id_deposit_12, t0.gen_code AS gen_code_13, t0.newspaper AS newspaper_14, t0.siren AS siren_15, t0.ape AS ape_16, t0.trading_registry AS trading_registry_17, t0.internal_tva AS internal_tva_18, t0.rib AS rib_19, t0.general_account AS general_account_20, t0.capital AS capital_21 FROM society t0 WHERE t0.id = ? LIMIT 1 Parameters: [`"MOZ"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.affiliated_society AS affiliated_society_3, t0.address1 AS address1_4, t0.address2 AS address2_5, t0.address3 AS address3_6, t0.zip_code AS zip_code_7, t0.city AS city_8, t0.email AS email_9, t0.phone_number AS phone_number_10, t0.fax AS fax_11, t0.id_deposit AS id_deposit_12, t0.gen_code AS gen_code_13, t0.newspaper AS newspaper_14, t0.siren AS siren_15, t0.ape AS ape_16, t0.trading_registry AS trading_registry_17, t0.internal_tva AS internal_tva_18, t0.rib AS rib_19, t0.general_account AS general_account_20, t0.capital AS capital_21 FROM society t0 WHERE t0.id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.affiliated_society AS affiliated_society_3, t0.address1 AS address1_4, t0.address2 AS address2_5, t0.address3 AS address3_6, t0.zip_code AS zip_code_7, t0.city AS city_8, t0.email AS email_9, t0.phone_number AS phone_number_10, t0.fax AS fax_11, t0.id_deposit AS id_deposit_12, t0.gen_code AS gen_code_13, t0.newspaper AS newspaper_14, t0.siren AS siren_15, t0.ape AS ape_16, t0.trading_registry AS trading_registry_17, t0.internal_tva AS internal_tva_18, t0.rib AS rib_19, t0.general_account AS general_account_20, t0.capital AS capital_21 FROM society t0 WHERE t0.id = 'MOZ' LIMIT 1;
0.92 ms (0.04%)	2	SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.product_id = ? AND t0.price_id = ? LIMIT 1 Parameters: [`80450 "C"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.product_id = ? AND t0.price_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.product_id = 80450 AND t0.price_id = 'C' LIMIT 1;
0.88 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 87250`] 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 (41, 189, 190, 191, 192, 193, 194, 195, 191) AND p0_.is_active = 1 AND p0_.id <> 87250 AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 LIMIT 10;
0.88 ms (0.04%)	2	SELECT p0_.id AS id_0, p0_.label_reduction AS label_reduction_1, p0_.description_reduction AS description_reduction_2, p0_.product_id AS product_id_3, p0_.operation_id AS operation_id_4 FROM product_reduction_label p0_ INNER JOIN operation o1_ ON p0_.operation_id = o1_.id WHERE o1_.is_active = 1 AND o1_.end_date >= ? AND o1_.is_active = 1 AND o1_.view_by LIKE ? AND p0_.product_id = ? Parameters: [`"2025-07-12 07:40:07" "%2%" 80450`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.label_reduction AS label_reduction_1, p0_.description_reduction AS description_reduction_2, p0_.product_id AS product_id_3, p0_.operation_id AS operation_id_4 FROM product_reduction_label p0_ INNER JOIN operation o1_ ON p0_.operation_id = o1_.id WHERE o1_.is_active = 1 AND o1_.end_date >= ? AND o1_.is_active = 1 AND o1_.view_by LIKE ? AND p0_.product_id = ? SELECT p0_.id AS id_0, p0_.label_reduction AS label_reduction_1, p0_.description_reduction AS description_reduction_2, p0_.product_id AS product_id_3, p0_.operation_id AS operation_id_4 FROM product_reduction_label p0_ INNER JOIN operation o1_ ON p0_.operation_id = o1_.id WHERE o1_.is_active = 1 AND o1_.end_date >= '2025-07-12 07:40:07' AND o1_.is_active = 1 AND o1_.view_by LIKE '%2%' AND p0_.product_id = 80450;
0.84 ms (0.03%)	4	SELECT t0.id AS id_1, t0.promotion_id AS promotion_id_2, t0.society_id AS society_id_3 FROM society_promotion t0 WHERE t0.promotion_id = ? Parameters: [`197588`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.promotion_id AS promotion_id_2, t0.society_id AS society_id_3 FROM society_promotion t0 WHERE t0.promotion_id = ? SELECT t0.id AS id_1, t0.promotion_id AS promotion_id_2, t0.society_id AS society_id_3 FROM society_promotion t0 WHERE t0.promotion_id = 197588;
0.82 ms (0.03%)	2	SELECT d0_.quantity AS quantity_0, MIN(d0_.price_ht) AS sclr_1, MIN(d0_.price_ttc) AS sclr_2 FROM decreasing_price d0_ LEFT JOIN product p1_ ON d0_.product_id = p1_.id LEFT JOIN product_price p2_ ON d0_.product_price_id = p2_.id WHERE p1_.id = ? AND p2_.id = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC Parameters: [`80450 9963413`] View formatted query View runnable query Explain query SELECT d0_.quantity AS quantity_0, MIN(d0_.price_ht) AS sclr_1, MIN(d0_.price_ttc) AS sclr_2 FROM decreasing_price d0_ LEFT JOIN product p1_ ON d0_.product_id = p1_.id LEFT JOIN product_price p2_ ON d0_.product_price_id = p2_.id WHERE p1_.id = ? AND p2_.id = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC SELECT d0_.quantity AS quantity_0, MIN(d0_.price_ht) AS sclr_1, MIN(d0_.price_ttc) AS sclr_2 FROM decreasing_price d0_ LEFT JOIN product p1_ ON d0_.product_id = p1_.id LEFT JOIN product_price p2_ ON d0_.product_price_id = p2_.id WHERE p1_.id = 80450 AND p2_.id = 9963413 GROUP BY d0_.quantity ORDER BY d0_.quantity ASC;
0.81 ms (0.03%)	5	SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1 Parameters: [`"C"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1 SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = 'C' LIMIT 1;
0.53 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: [`"72200-cahiers-polypro-violet-n-c-72200-maju"`] 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 = '72200-cahiers-polypro-violet-n-c-72200-maju' LIMIT 1;
0.49 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.47 ms (0.02%)	2	SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.discount AS discount_4, t0.product_id AS product_id_5 FROM promotion t0 WHERE t0.product_id = ? Parameters: [`80450`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.discount AS discount_4, t0.product_id AS product_id_5 FROM promotion t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.discount AS discount_4, t0.product_id AS product_id_5 FROM promotion t0 WHERE t0.product_id = 80450;
0.45 ms (0.02%)	1	SELECT c0_.id AS id_0, c0_.value AS value_1, c1_.id AS id_2, c1_.list_order AS list_order_3, c1_.is_display_site AS is_display_site_4, c1_.is_search_site AS is_search_site_5, c1_.label AS label_6, c0_.product_id AS product_id_7, c0_.characteristic_label_id AS characteristic_label_id_8 FROM characteristic c0_ INNER JOIN characteristic_label c1_ ON c0_.characteristic_label_id = c1_.id WHERE c0_.product_id = ? AND c1_.is_display_site = ? Parameters: [`87250 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 = 87250 AND c1_.is_display_site = 1;
0.45 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: [`"72200-cahiers-polypro-violet-n-c-72200-maju"`] 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 = '72200-cahiers-polypro-violet-n-c-72200-maju';
0.33 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: [`87250`] 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 = 87250;

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.
App\Entity\Pricing\DecreasingPrice	No errors.
App\Entity\Pricing\SocietyPromotion	No errors.
App\Entity\Product\ProductReductionLabel	No errors.

Symfony Profiler

GET https://staging.pgdis.com/produit/72200-cahiers-polypro-violet-n-c-72200-maju

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping