Query Metrics
113
Database Queries
23
Different statements
3512.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1829.34 ms (52.08%) |
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:
[ 6309933 6332006 6337676 6337682 6337686 6337753 6337839 6337976 6338031 6338300 6338304 6338380 6336344 6338479 6338622 6338791 6338851 6338938 6339397 6340224 6339983 6340541 6340674 6318402 6332088 6326102 6331308 6340813 6340874 6340978 6340990 6340999 6341009 6341011 6341018 6341045 6341195 6341245 6341731 6341806 6341948 6342115 6333903 6342531 6342733 6342839 6342973 6343326 6342924 6343676 6343846 6343892 6343899 6344144 6344348 6344457 6342320 6322521 6333749 6334984 6335467 6335484 6335507 6335543 6335621 6335735 6335785 6336680 6336681 6336700 6336796 6337245 6337249 6337251 6337891 6337930 6338779 6344739 6344812 6344842 6344843 6344886 6325195 6345295 6345410 6345508 6345510 6345515 6345593 6345600 6345601 6345605 6345655 6345692 6345693 6345709 6345721 6345723 6345735 6345813 6346036 6346140 6346159 6346206 6346924 6347394 6347397 6347452 6347697 6348002 6348018 6348067 6348284 6348441 6348522 6348843 6348900 6349008 6349215 6349224 6349286 6349288 6349408 6349450 6349452 6349597 6349755 6349819 6349840 6349849 6349850 6349851 6349852 6349854 6349856 6349862 6349871 6349874 6349875 6349876 6349878 6349884 6349890 6349896 6349901 6349903 6349911 6350133 6350140 6350411 6350415 6350417 6350448 6350496 6350498 6350500 6350548 6350550 6350556 6350720 6346374 6350629 6350816 6350855 6351046 6351113 6351122 6351154 6351171 6351172 6351182 6351191 6351200 6351213 6351218 6351359 6351444 6351446 6351447 6351448 6351532 6351568 6340325 6340406 6345566 6351672 6351673 6351675 6351681 6351745 6351751 6351862 6351879 6337101 6352373 6352416 6352419 6352462 6352552 6352560 6352582 6352633 6352687 6352797 6352981 6353258 6353263 6353277 6353335 6353571 6353749 6353883 6353927 6354093 6352729 6341254 6354443 6354444 6354471 6354563 6354564 6354569 6354593 6354608 6353429 6354819 6355139 6355502 6353464 6355771 6355789 6355822 6355845 6355856 6355724 6355924 6356026 6356166 6356222 6356297 6356460 6355727 6355381 6356609 6357011 6357404 6357487 6357705 6357862 6358112 6358124 6358121 6358210 6358230 6358423 6359290 6359295 6359304 6359325 6357254 6358382 6358177 6358304 6359230 6358363 6359807 6359957 6359968 6361183 6361370 6360913 6359250 6361858 6361979 6361980 6361983 6361989 6361994 6361995 6361997 6361998 6362000 6362003 6362005 6362010 6362018 6362020 6362085 6362086 6362090 6362091 6362689 6363030 6361740 6352688 6342762 6363186 6363532 6363598 6363602 6363741 6363747 6363790 6363824 6364027 6364253 6364426 6364524 6364598 6365023 6365821 6366006 6362858 6366657 6321817 6366841 6366873 6366968 6366333 6367037 6367111 6367320 6367457 6367459 6367460 6367461 6367473 6367474 6367476 6367479 6367509 6367864 6368086 6368183 6368403 6368409 6368625 6368774 6369018 6369329 6369843 6369983 6370297 6370393 6370449 6370503 6370568 6370673 6370739 6370749 6370862 6371161 6371409 6371487 6371522 6371524 6371674 6371919 6371922 6371923 6371924 6372096 6372607 6372612 6372626 6372635 6372638 6372639 6372641 6372651 6372662 6372666 6372669 6372673 6372836 6372904 6372996 6373030 6373060 6373140 6373176 6373199 6373210 6373251 6373254 6373260 6373380 6373406 6373421 6373574 6373613 6373618 6373621 6373630 6373633 6373634 6373637 6373650 6373652 6373660 6373663 6373681 6373691 6373715 6373718 6373720 6373990 6374039 6374170 6374289 6374319 6374671 6374854 6375484 6375856 6375976 6375982 6376170 6376183 6376184 6376196 6376201 6376211 6376222 6376226 6376267 6376269 6376309 6376320 6376330 6376338 6376346 6376365 6376464 6376484 6376565 6376584 6376664 6376674 6376819 6376862 6376935 6376936 6376940 6377077 6377108 6377135 6377425 6377479 6377573 6375107 6356253 6377609 6377743 6377804 6377881 6377900 6377914 6377956 6377997 6378095 6378136 6378151 6378322 6378340 6378470 6378675 6378722 6378831 6378873 6378944 6379055 6379056 6379421 6379447 6377698 6368368 6365620 6359494 6380469 6380537 6380608 6381195 6381666 6381780 6381879 6381881 6382054 6382061 6382226 6382356 6382497 6382815 6383203 6380930 6383481 6382480 6383845 6383887 6383892 6383926 6358020 6384499 6384696 6384817 6381725 6374810 6382373 6385482 6366688 6385575 6385709 6385744 6386086 6386127 6386148 6386368 6385476 6386433 6384494 6382413 6381645 6380827 6374159 6364049 6386565 6386698 6386506 6386531 6386620 6382407 6387068 6387069 6387213 6387208 6387230 6387223 6387400 6387415 6387445 6387511 6387519 6387539 6387554 6387569 6387572 6387619 6387867 6387889 6388193 6388250 6388253 6382839 6384442 6384680 6385485 6388379 6385890 6388410 6388465 6386755 6388639 6388642 6388702 6388759 6389093 6389112 6389264 6390153 6390210 6390217 6390309 6390353 6390679 6390684 6391179 6389858 6390986 6391234 6391365 6391377 6391543 6391673 6391926 6392098 6392145 6392181 6392204 6392254 6392350 6392360 6392548 6392596 6392616 6393095 6393224 6393239 6393363 6393365 6393407 6393346 6393909 6394196 6394541 6394633 6394849 6394902 6395119 6395240 6395436 6395519 6395813 6395817 6395818 6395819 6395823 6395871 6395938 6396414 6396570 6396639 6396655 6396771 6397651 6397662 6397706 6398037 6398041 6398044 6398050 6398236 6398240 6398495 6398574 6398686 6398891 6398904 6398906 6398913 6398914 6398918 6398919 6398921 6398927 6398929 6398932 6398934 6398939 6398941 6398960 6398967 6398968 6398972 6399019 6399046 6399076 6399161 6399215 6399400 6399549 6399566 6399583 6399665 6399699 6399878 6400013 6400049 6400050 6400059 6400060 6400061 6400087 6400094 6400098 6400100 6400104 6400120 6400122 6400132 6400147 6400449 6400500 6401057 6401172 6401176 6401179 6401187 6401197 6401200 6401231 6401245 6401315 6401290 6401320 6401339 6401351 6401363 6401366 6401361 6401368 6401401 6401403 6401476 6401484 6401485 6401486 6401506 6401531 6401532 6401550 6401577 6401578 6401579 6401612 6401678 6401679 6401706 6402057 6402134 6402320 6402321 6402326 6402328 6402692 6403084 6403372 6403711 6404014 6404122 6404417 6404456 6404467 6404474 6404880 6404896 6405072 6405388 6405563 6405582 6405912 6405935 6406073 6406082 6406120 6406129 6406313 6406426 6406482 6406631 6406755 6406853 6406919 6407454 6408159 6408162 6408226 6408478 6408480 6408555 6408614 6408779 6408894 6409573 6410886 6410922 6411163 6411718 6411719 6411752 6411810 6411938 6411930 6411981 6412554 6412629 6412671 6412682 6412742 6412756 6412989 6413043 6413046 6413542 6413566 6413626 6413648 6413949 6414089 6414248 6414267 6414286 6414298 6414300 6414553 6414764 6414780 6415004 6415023 6415079 6415125 6415176 6415507 6415682 6415891 6415892 6416148 6416159 6416313 6416322 6416547 6416882 6416886 6416894 6416921 6416925 6416929 6416933 6417193 6417225 6417450 6417481 6417770 6417791 6417830 6418085 6418171 6418393 6418515 6418724 6418741 6418742 6418746 6418750 6418752 6418804 6418822 6418893 6418956 6419024 6419109 6419306 6419374 6419449 6419551 6419599 6419607 6419610 6419611 6419615 6419616 6419620 6419625 6419626 6419637 6419640 6419641 6419646 6419651 6419655 6419656 6419658 6419661 6419789 6420037 6420057 6420499 6420507 6420514 6420516 6420532 6420621 6420622 6420633 6420636 6420637 6420647 6420649 6420857 6420903 6421046 6421581 6421661 6421690 6421701 6421755 6421884 6422022 6422189 6422395 6422435 6422495 6422755 6422788 6422835 6422948 6422981 6423128 6423126 6423137 6423144 6423151 6423176 6423203 6423230 6423365 6423543 6423597 6423603 6423636 6423642 6423654 6423686 6423950 6423951 6423952 6423962 6423985 6424006 6424009 6424225 6424309 6424326 6424339 6424687 6424795 6424967 6425051 6425063 6425076 6425088 6425091 6425121 6425129 6425164 6425197 6425199 6425234 6425242 6425250 6425255 6425280 6425443 6425471 6425561 6425575 6425729 6425795 6425992 6426134 6426166 6426174 6426221 6426324 6426385 6426408 6426429 6426566 6421740 6426685 6426838 6426868 6426897 6426938 6426960 6426983 6427271 6427351 6427426 6427433 6427437 6427446 6427580 6427673 6427777 6427802 6427805 6427822 6427994 6427998 6428177 6428234 6428238 6428244 6428246 6428258 6428266 6428389 6428428 6428443 6428494 6428590 6428778 6428824 6428836 6428869 6428896 6428901 6429082 6429498 6429502 6429528 6429529 6429589 6429619 6429648 6430124 6430486 6430594 6430943 6430951 6431116 6431244 6431322 6431476 6431494 6431537 6431543 6431570 6431921 6431935 6431945 6432308 6432505 6433371 6433455 6433585 6433595 6433626 6433647 6433807 6433815 6433945 6434201 6434334 6434406 6434450 6434624 6434662 6434669 6434684 6434697 6434895 6434917 6434928 6434940 6434942 6434982 6434984 6435102 6435109 6435116 6435121 6435252 6435275 6435294 6435429 6435454 6435547 6435634 6435776 6435920 6435974 6436018 6436295 6436357 6436490 6436755 6437187 6437210 6437215 6437217 6437236 6437239 6437583 6437601 6437714 6437726 6437737 6437793 6437884 6438113 6438118 6438149 6438667 6438674 6438688 6438797 6438823 6438870 6438931 6439242 6439521 6439615 6439620 6439768 6439800 6440049 6440055 6440100 6440739 6440839 6440843 6440845 6440910 6441314 6441410 6441436 6441585 6441715 6442055 6442161 6442346 6442860 6442936 6443142 6443204 6443241 6443464 6443547 6443572 6443658 6443676 6443740 6443742 6443773 6443776 6443929 6443971 6444066 6444129 6444277 6444300 6444302 6444327 6444367 6444370 6444481 6444551 6444582 6444633 6444887 6445255 6445536 6445628 6445683 6445835 6446119 6446128 6446146 6446200 6446244 6446307 6446309 6446467 6446515 6446523 6446612 6446663 6446667 6446900 6447224 6447257 6447288 6447322 6447372 6447378 6447489 6447577 6447661 6447699 6447765 6448273 6448291 6448633 6448952 6449010 6449065 6449058 6449047 6449431 6449470 6449499 6449717 6449728 6449870 6449894 6449954 6450018 6450032 6450036 6450098 6450104 6450167 6450170 6450173 6450174 6450182 6450183 6450186 6450188 6450189 6450192 6450195 6450198 6450234 6450253 6450278 6450500 6450517 6450603 6450609 6450613 6450625 6450765 6450768 6450791 6450849 6450870 6450896 6451072 6451074 6451081 6451151 6451163 6451204 6451210 6451225 6451229 6451236 6451271 6451283 6451294 6451299 6451324 6451358 6451418 6451439 6451526 6451564 6451631 6451773 6451788 6451926 6452219 6452321 6452335 6452378 6452393 6452402 6452410 6452539 6452594 6452614 6452722 6453145 6453259 6453327 6453407 6453474 6453498 6453517 6453521 6453528 6453532 6453540 6453835 6453909 6453950 6454025 6454189 6454346 6454455 6454457 6454463 6454464 6454512 6454549 6454554 6454605 6454619 6454622 6454718 6454822 6454826 6454832 6454852 6454862 6454903 6454926 6454945 6454962 6455036 6455040 6455063 6455122 6455136 6455171 6455238 6455239 6455253 6455297 6455307 6455337 6455361 6455463 6455465 6455475 6455479 6455490 6455501 6455526 6455528 6455531 6455533 6455535 6455557 6455561 6455598 6455732 6455736 6455807 6455852 6455873 6455884 6456085 6456106 6456110 6456138 6456145 6456147 6456150 6456154 6456155 6456160 6456164 6456165 6456172 6456178 6456180 6456187 6456194 6456208 6456250 6456329 6456358 6456718 6456750 6456792 6456837 6456872 6456953 6456979 6456986 6456987 6457044 6457047 6457229 6457232 6457257 6457272 6457278 6457345 6457379 6457382 6457383 6457384 6457385 6457386 6457387 6457388 6457392 6457394 6457396 6457400 6457401 6457402 6457431 6457436 6457441 6457645 6457646 6457735 6457758 6457777 6457939 6458809 6458977 6458994 6459200 6459227 6459271 6459294 6459420 6459534 6459612 6459638 6459715 6459752 6459760 6459887 6459909 6459916 6459952 6459956 6460046 6460061 6460187 6460228 6460234 6460281 6460289 6460327 6460337 6460358 6460467 6460493 6460498 6460629 6460921 6460927 6460974 6461208 6461215 6461324 6461340 6461356 6461357 1000013771 6461444 6461568 6461613 6461621 6461664 6461710 6461761 6461838 6461848 6461869 6461915 6462204 6462229 6462273 6462316 6462573 6462660 6462715 6462805 6462856 6462886 6462905 6462948 6462956 6462969 6462971 6462987 6463035 6463046 6463075 6463150 6463400 6463491 6463512 6463558 6463559 6464204 6464224 6464308 6464317 6464353 6464399 6464681 6464708 6464801 6464826 6465176 6465374 6465610 6465791 6465863 6465919 6465933 6465935 6466348 6466359 6466360 6466379 6466388 6466409 6466447 6466528 6466531 6466626 6466746 6466810 6466952 6466964 6466972 6466997 6467075 6467182 6467224 6467447 6467786 6467983 6468023 6468117 6468149 6468156 6468523 1000000877 1000000922 6393754 1000001269 1000001415 1000001550 1000001551 1000001552 1000001553 1000001767 1000001873 1000001899 1000001904 1000001912 1000002269 1000002494 1000002603 1000002669 1000001338 1000001554 6387849 1000001923 1000003214 1000003291 1000003295 1000003426 1000003614 1000003635 1000003787 1000003789 1000002327 1000002536 6314803 1000004048 1000004049 1000004164 1000004129 1000004262 1000004315 1000004393 1000004394 1000004441 1000004512 1000004406 1000004166 1000004260 1000004573 1000004806 1000005447 1000004795 1000005219 1000005424 1000006105 1000006207 1000006953 1000006974 1000007032 1000008157 1000008203 1000008228 1000008237 1000008264 6393161 1000002507 1000004824 1000008893 1000001202 1000008922 1000008586 1000008229 6366269 6386802 1000006281 1000004574 1000009627 1000009647 1000009822 1000009823 1000009824 1000009825 1000009829 1000009830 1000009831 1000004794 1000010023 6379221 1000009833 1000010066 1000010122 1000010123 1000005988 1000010207 1000006182 1000010300 1000010149 1000010410 1000010411 1000010412 1000010413 1000010414 1000010415 1000010416 1000010419 1000010420 1000010437 1000007963 1000010665 1000009972 1000010417 1000010553 1000010741 1000010786 1000005932 1000002170 1000007651 1000010837 1000010537 1000010772 1000011034 1000011863 1000009062 1000007988 1000012157 1000006955 1000008540 1000008710 1000012401 6376695 1000012562 1000012563 1000009901 1000012601 1000012817 1000009891 1000012887 1000012991 1000012308 1000013100 1000013102 1000005855 1000011085 1000010709 1000013294 1000013295 1000013296 1000013297 1000013298 1000013299 1000013300 1000013301 1000013302 1000013303 1000013304 1000013305 1000013307 1000013308 1000013309 1000013312 1000013313 1000013314 1000011022 1000009753 1000013434 1000013498 1000013563 1000013577 1000013591 1000001015 1000009912 1000012566 1000013650 1000010746 1000013725 1000013792 1000013376 1000012743 1000012712 1000014018 1000014153 1000014197 1000014203 1000013909 1000006505 1000014433 1000014542 1000014710 1000014849 1000012293 6337933 1000010092 1000005279 1000014283 1000013374 1000010177 1000009463 1000008701 1000005850 1000015218 1000011070 1000015315 1000015316 6394164 6394154 1000015412 1000015424 1000015479 1000015539 1000013268 1000015655 1000015675 1000015695 1000015697 1000015771 1000015851 1000015327 1000015886 1000015888 1000014922 1000009957 1000015802 1000016131 1000016251 1000016474 1000016507 1000016629 1000016640 1000016644 1000014161 1000016811 1000012465 1000017062 1000017064 1000017067 1000017068 1000017069 1000017070 1000012570 1000017123 1000017237 1000017238 1000017239 1000017444 1000010715 1000009423 1000017763 1000017868 1000017870 1000017891 1000017892 1000017897 1000017898 1000017904 1000017905 1000017906 1000017907 1000017908 1000017909 1000017910 1000017911 1000017912 1000017913 1000017914 1000017915 1000017916 1000017917 1000017918 1000017919 1000017920 1000017921 1000017922 1000017923 1000017924 1000017925 1000017926 1000017931 1000017960 1000017961 1000017962 1000017963 1000017965 1000017970 1000017977 1000017978 1000017988 1000017989 1000017990 1000017991 1000017992 1000016262 1000018118 1000010608 1000015871 1000016035 1000018509 1000018632 1000018508 1000018652 1000018467 1000018264 1000006098 1000017394 1000018908 1000018909 1000018912 1000018913 1000018977 1000018978 1000018979 1000018980 1000018981 1000018982 1000018983 1000018984 1000018985 1000018986 1000018991 1000018993 1000018995 1000019001 1000019002 1000019004 1000019006 1000019008 1000019010 1000019011 1000019013 1000019014 1000019070 1000019075 1000019082 1000019103 1000019215 1000019271 1000019283 1000019295 1000019098 1000019511 1000019514 1000019520 1000019521 1000019523 1000002286 1000012927 1000019931 1000019949 1000019950 1000020096 1000020097 1000020099 1000020100 1000020110 1000020111 1000020136 1000020137 1000020157 1000020158 1000020281 1000019664 1000020454 1000020489 1000014659 1000020763 1000020895 1000020929 1000020930 1000020931 1000020932 1000020933 1000020935 1000006972 1000014712 1000021052 1000021054 1000021055 1000021056 1000021061 1000021062 1000021063 1000021064 1000020998 1000016529 1000014769 1000021217 1000021531 6375799 1000021693 1000021721 1000021722 1000021772 1000021774 1000021775 1000021777 1000021779 1000021781 1000021782 1000021783 1000021790 1000021791 1000021792 1000021796 1000021797 1000021798 1000021799 1000021802 1000014078 1000002290 1000002046 1000001497 1000022062 1000000909 1000022123 1000022162 1000022166 1000022167 1000012427 1000022191 1000022293 1000022298 1000022303 1000022315 1000012074 1000022345 1000022347 1000022355 1000022356 1000022470 1000021118 1000022617 1000012612 1000022621 1000022623 1000022626 1000022656 1000022658 1000022659 1000019402 1000019651 1000022629 1000014851 1000022868 1000023038 1000023039 1000023040 1000023041 1000023042 1000023043 1000023044 1000023046 1000023047 1000023048 1000023049 1000023050 1000023051 1000023052 1000023053 1000023054 1000023056 1000023057 1000023058 1000023059 1000023060 1000023061 1000023062 1000023063 1000023065 1000023066 1000023067 1000023068 1000023069 1000023070 1000023071 1000023072 1000023073 1000023074 1000023075 1000023076 1000023177 1000023178 1000023179 1000023180 1000023181 1000023182 1000023183 1000023184 1000023185 1000023186 1000023216 1000023220 1000023223 1000023225 1000023226 1000023568 1000023671 1000023724 1000023729 1000023730 1000023731 1000023732 1000023733 1000023757 1000023786 1000023787 1000023902 1000023926 1000024004 1000024005 1000024006 1000024007 1000024008 1000024009 1000024031 1000024033 1000024038 1000024044 1000024046 1000024148 1000024160 1000024163 1000024168 1000024169 1000024183 1000024184 1000024198 1000024199 1000024201 1000024203 1000024204 1000024205 1000024207 1000024208 1000024209 1000024210 1000024211 1000024212 1000024213 1000024214 1000024215 1000024216 1000024217 1000024218 1000024219 1000024221 1000024222 1000024223 1000024224 1000024225 1000024243 1000024244 1000024247 1000024249 1000024250 1000024251 1000024252 1000024253 1000024255 1000024256 1000024257 1000024258 1000024259 1000024260 1000024261 1000024262 1000024263 1000024264 1000024265 1000024266 1000024267 1000024268 1000024269 1000024300 1000024301 1000024302 1000024303 1000024304 1000024308 1000024311 1000024312 1000024316 1000024317 1000024321 1000024325 1000024326 1000024327 1000024328 1000024329 1000024330 1000024331 1000024332 1000024333 1000024334 1000024353 1000018852 1000021979 1000024511 1000024512 1000024522 1000024523 1000024524 1000024525 1000024526 1000024527 1000024528 1000024529 1000024533 1000024535 1000024537 1000021863 1000024538 1000024563 1000024724 1000024725 1000024726 1000025163 1000025166 1000025171 1000025292 1000025293 1000025295 1000025307 1000025309 1000025313 1000025314 1000025318 1000025319 1000025320 1000025321 1000025322 1000025323 1000025324 1000025325 1000025326 1000025327 1000025328 1000025329 1000025330 1000025331 1000025332 1000025333 1000025334 1000025335 1000025336 1000025337 1000025338 1000025339 1000025340 1000025341 1000025342 1000025343 1000025344 1000025345 1000025346 1000025347 1000025348 1000025349 1000025350 1000025352 1000025353 1000025354 1000025647 1000021695 1000022794 1000026331 1000026334 1000026438 1000026440 1000014572 1000014791 1000026503 1000026513 1000016230 1000026614 1000020800 1000026641 1000026673 1000026676 1000026680 1000026842 1000022192 1000027059 1000027119 1000027132 1000027298 1000027300 1000027301 1000027302 1000027304 1000027306 1000027309 1000027310 1000027312 1000027315 1000027316 1000027317 1000027319 1000027320 1000027321 1000027322 1000027323 1000027324 1000027325 1000027326 1000027328 1000027330 1000027331 1000027333 1000027334 1000027335 1000027336 1000027338 1000027339 1000027341 1000027342 1000027343 1000013802 1000027369 1000027375 1000027377 1000027382 1000027384 1000027811 1000027812 1000027813 1000027814 1000027816 1000027817 1000027818 1000027819 1000027820 1000027821 1000027822 1000027936 1000028088 1000028144 1000028149 1000028150 1000028151 1000028153 1000028154 1000028161 1000028162 1000028163 1000028164 1000028165 1000028166 1000028167 1000028168 1000028169 1000028170 1000028171 1000028172 1000028173 1000028175 1000028176 1000028177 1000028179 1000028180 1000028181 1000028182 1000028183 1000028184 1000028186 1000028187 1000028188 1000028189 1000028190 1000028194 1000028196 1000028197 1000028200 1000028201 1000028202 1000028203 1000028204 1000028205 1000028206 1000028224 1000028391 1000028392 1000028394 1000028407 1000028408 1000028409 1000028410 1000028411 1000028412 1000028414 1000028417 1000028429 1000028430 1000028432 1000028454 1000028456 1000028458 1000028460 1000028461 1000028462 1000028463 1000028464 1000028465 1000028494 1000028495 1000028496 1000028497 1000028498 1000028499 1000028500 1000028501 1000028502 1000028503 1000028504 1000014537 1000020070 6375487 1000028821 1000028824 1000021125 1000028872 1000028873 1000028875 1000028876 1000028877 1000028878 1000028879 1000024727 1000028880 1000028881 1000028882 1000028883 1000028884 1000028886 1000028887 1000029011 1000029012 1000029013 1000029014 1000029015 1000029016 1000029017 1000029018 1000029019 1000029020 1000029021 1000029022 1000029023 1000029057 1000029058 1000029059 1000029060 1000029061 1000029062 1000029063 1000029064 1000029065 1000029066 1000029067 1000029068 1000029069 1000029070 1000021551 1000029211 1000029212 1000029213 1000029214 1000029215 1000029216 1000029217 1000029218 1000029220 1000029221 1000029223 1000029224 1000029226 1000029227 1000029290 1000029292 1000029295 1000029320 1000029322 1000022278 1000029438 1000029460 1000029481 1000029482 1000029498 1000029634 1000029659 1000029707 1000029708 1000029709 1000029710 1000029758 1000029759 1000028090 1000029897 1000029898 1000026665 1000029927 1000029902 1000029952 1000029959 1000029962 1000029963 1000029964 1000029965 1000029966 1000029968 1000029969 1000029971 1000029972 1000029974 1000029975 1000029976 1000029978 1000029981 1000029986 1000030071 1000030072 1000030073 1000030074 1000030075 1000030076 1000030077 1000030078 1000030079 1000030080 1000030081 1000030082 1000030083 1000030084 1000030086 1000030089 1000030137 1000030287 1000030288 1000030289 1000030293 1000030294 1000030295 1000030296 1000030297 1000030298 1000030299 1000030300 1000030301 1000030302 1000030353 1000030354 1000030355 1000030357 1000030358 1000024088 1000030488 1000030489 1000030490 1000030491 1000030492 1000030493 1000030494 1000030495 1000030496 1000030497 1000030498 1000030499 1000030500 1000030501 1000030502 1000030503 1000030504 1000030528 1000030529 1000030530 1000030531 1000030532 1000030533 1000030534 1000030535 1000030536 1000030537 1000030538 1000030539 1000030540 1000030541 1000030542 1000030543 1000030544 1000030546 1000030636 1000030638 1000030639 1000030640 1000030641 1000030643 1000030644 1000030645 1000030646 1000030647 1000030648 1000030649 1000030651 1000030656 1000030658 1000030660 1000030665 1000030666 1000030667 1000030668 1000030672 1000030685 1000030687 1000030688 1000030740 1000030741 1000030742 1000030745 1000030746 1000030749 1000030750 1000030753 1000030756 1000030758 1000030759 1000031115 1000031116 1000031117 1000031118 1000031119 1000031120 1000031121 1000031122 1000031158 1000031159 1000031160 1000031161 1000031162 1000031163 1000031164 1000031165 1000031166 1000031167 1000031184 1000031185 1000031186 1000031187 1000031188 1000031189 1000031190 1000031191 1000031192 1000031193 1000031194 1000031195 1000031196 1000031197 1000031198 1000031199 1000031200 1000031201 1000031202 1000031203 1000031204 1000031205 1000031206 1000031207 1000031208 1000031209 1000031210 1000031211 1000031212 1000031213 1000031214 1000031215 1000031216 1000031217 1000031240 1000031246 1000026663 1000031280 1000031281 1000031283 1000031284 1000031285 1000031286 1000031287 1000031288 1000031289 1000031290 1000031304 1000031305 1000031306 1000031307 1000031332 1000031361 1000031365 1000031366 1000031377 1000031378 1000031379 1000031381 1000031382 1000031383 1000031385 1000031386 1000031389 1000031391 1000031392 1000031394 1000031395 1000031398 1000031399 1000031400 1000031402 1000031404 1000031406 1000031407 1000031409 1000031411 1000031412 1000031414 1000031415 1000031416 1000031417 1000031418 1000031419 1000031420 1000031421 1000031424 1000031428 1000031430 1000031433 1000031436 1000031438 1000031439 1000031442 1000031443 1000031446 1000031451 1000031457 1000031467 1000031468 1000031472 1000031475 1000031476 1000031477 1000031478 1000031480 1000031486 1000031502 1000031504 1000031506 1000031509 1000031526 1000031531 1000031532 1000031533 1000031546 1000031553 1000031558 1000031566 1000031567 1000010182 1000031583 1000031585 1000031591 1000031681 1000031718 1000031722 1000031748 1000031943 1000031944 1000031945 1000031942 1000032031 1000017146 1000032089 1000023685 1000032206 1000010159 1000032376 1000032426 1000015682 1000016890 1000028397 1000030690 1000032660 1000032848 1000032849 1000033015 1000033037 1000033038 1000033039 1000033041 1000033042 1000033058 1000033059 1000033061 1000033194 1000033195 1000033200 1000033201 1000033202 1000033295 1000033304 1000033307 1000033516 1000033517 1000033518 1000033523 1000026225 1000033567 1000033568 1000033607 1000027138 1000033851 1000033852 1000033853 1000026315 1000033986 1000034001 1000034003 1000034004 1000030443 1000030059 1000034092 1000027768 1000025771 1000034201 1000033526 1000034353 1000034368 1000034375 1000034379 1000034387 1000034388 1000034389 1000034390 1000034391 1000034392 1000034394 1000034395 1000034505 1000034555 1000034579 1000034595 1000034600 1000034608 1000034635 1000034664 1000001795 1000034691 1000034695 1000034705 1000034723 1000034887 1000035021 1000035022 1000035023 1000035025 1000035026 1000035027 1000035028 1000035029 1000035030 1000035031 1000035032 1000035033 1000035034 1000035035 1000035036 1000035037 1000035038 1000035039 1000035040 1000035041 1000035042 1000035043 1000035136 1000035137 1000035138 1000035143 1000035144 1000035147 1000035148 1000035149 1000035150 1000035151 1000035152 1000035156 1000035410 1000035413 1000002590 1000035432 1000035433 1000035434 1000035435 1000035436 1000035437 1000035438 1000035443 1000035444 1000035445 1000035446 1000035447 1000035448 1000035449 1000035450 1000035451 1000035453 1000033569 1000035699 1000015163 1000035804 1000035833 1000035897 1000035900 1000035908 1000035911 1000035915 1000035964 1000035966 1000035970 1000035981 1000035969 1000035903 1000036111 1000036112 1000036113 1000036114 1000036115 1000036116 1000036117 1000036132 1000036133 1000036134 1000036135 1000036136 1000036137 1000036140 1000036271 1000036273 1000035536 1000036308 1000036311 1000036312 1000036313 1000036314 1000036315 1000036319 1000036321 1000036373 1000036449 1000036467 1000036452 1000036478 1000036480 1000036481 1000036482 1000036483 1000036491 1000036492 1000036507 1000036536 1000036538 1000036542 1000036543 1000036544 1000036551 1000036484 1000036496 1000036599 1000036600 1000036613 1000036669 1000036670 1000036672 1000036673 1000036674 1000036675 1000036680 1000036684 1000036697 1000036704 1000036705 1000036706 1000036708 1000036709 1000036710 1000036711 1000036712 1000036713 1000036715 1000036716 1000036717 1000036719 1000036724 1000036726 1000036727 1000036728 1000036729 1000036730 1000036731 1000036732 1000036739 1000036743 1000036746 1000012245 1000036968 1000036969 1000036970 1000036971 1000037196 1000037197 1000037198 1000037199 1000037200 1000037201 1000037202 1000037203 1000037204 1000037205 1000037206 1000037207 1000037208 1000037209 1000037210 1000037211 1000037212 1000037213 1000037277 1000037502 1000037578 1000037583 1000037591 1000037605 1000037606 1000037616 1000037618 1000037619 1000037645 1000037907 1000037908 1000037909 1000037910 1000037935 1000037936 1000037937 1000037938 1000037939 1000037940 1000037941 1000037942 1000037943 1000037945 1000037946 1000037947 1000037948 1000037949 1000037950 1000037952 1000037953 1000037955 1000037956 1000037957 1000037958 1000037959 1000037960 1000037961 1000037962 1000037963 1000037964 1000038041 1000038043 1000038045 1000038047 1000038048 1000038049 1000038050 1000038051 1000038052 1000038055 1000038057 1000038058 1000038059 1000038060 1000038063 1000038064 1000038065 1000038067 1000038068 1000038069 1000038071 1000038072 1000038077 1000038078 1000032550 1000038084 1000038088 1000038110 1000038121 1000038122 1000038123 1000038129 1000038139 1000038152 1000038343 1000038399 1000038411 1000038760 1000038766 1000020159 1000022802 1000038893 1000038894 1000038895 1000038896 1000038897 1000038898 1000038899 1000038900 1000038901 1000038902 1000038904 1000038905 1000038906 1000038907 1000038908 1000038910 1000038911 1000038912 1000038913 1000038914 1000038915 1000038916 1000038917 1000038919 1000038920 1000038921 1000038922 1000038923 1000038924 1000038925 1000039201 1000039275 1000039278 1000039283 1000039845 1000039847 1000039849 1000040116 1000040203 1000040204 1000040208 1000040210 1000040211 1000040212 1000040229 1000040230 1000040231 1000040233 1000032511 1000037756 1000040330 1000040333 1000040335 1000040439 1000040440 1000040441 1000040442 1000040443 1000040444 1000040445 1000040448 1000040449 1000040450 1000040451 1000040503 1000040504 1000040505 1000040506 1000040507 1000040508 1000040509 1000040510 1000040511 1000040512 1000040513 1000040514 1000040515 1000040516 1000040519 1000040520 1000040521 1000040522 1000040523 1000040524 1000040527 1000040530 1000040535 1000040551 1000040552 1000040553 1000040554 1000040709 1000040895 1000040949 1000040958 1000040959 1000040960 1000041032 1000041038 1000041041 1000041042 1000041069 1000041070 1000041200 1000041203 1000040952 1000041247 1000041336 1000016436 1000041369 1000041370 1000041371 1000041394 1000041396 1000040095 1000041507 1000041590 1000041591 1000041592 1000041593 1000041595 1000041596 1000041602 1000041603 1000041667 1000041668 1000041669 1000041670 1000041671 1000041672 1000041673 1000041674 1000041675 1000041676 1000041677 1000041678 1000041679 1000041680 1000041681 1000041682 1000041683 1000041684 1000041685 1000018854 1000041767 1000041769 1000041770 1000041771 1000041772 1000041927 1000041939 1000041942 1000041947 1000041956 1000041978 1000041981 1000042032 1000022240 1000042220 1000042222 1000042252 1000042284 1000042296 1000042305 1000042320 1000042360 1000042381 1000042490 1000042626 1000042627 1000040903 1000042841 1000042842 1000042843 1000042854 1000042857 1000042858 1000042860 1000042861 1000042862 1000042485 1000042904 1000042907 1000043017 1000043023 1000034845 1000043281 1000043293 1000043294 1000043332 1000043333 1000043337 1000043683 1000043684 1000043685 1000043686 1000043689 1000043690 1000043691 1000043692 1000043693 1000043694 1000043695 1000043696 1000043697 1000043698 1000043700 1000043701 1000043702 1000043771 1000043812 1000043813 1000043814 1000043818 1000043824 1000043825 1000043832 1000043843 1000043850 1000043852 1000043862 1000043872 1000043875 1000002861 1000017588 1000043706 1000043990 1000044004 1000044005 1000044006 1000044010 1000032021 1000044018 1000044022 1000044023 1000044030 1000044031 1000044032 1000044033 1000018425 1000044151 1000044152 1000044155 1000044163 1000044164 1000044166 1000044167 1000044168 1000044169 1000044170 1000044171 1000044172 1000044173 1000044174 1000044176 1000044178 1000044185 1000044186 1000044187 1000044189 1000044190 1000044193 1000044194 1000044196 1000044206 1000044208 1000044209 1000044243 1000044244 1000044245 1000044246 1000044259 1000044260 1000044261 1000044262 1000044263 1000044264 1000044265 1000044266 1000044268 1000044271 1000044272 1000044273 1000044274 1000044276 1000044277 1000044278 1000044279 1000044292 1000044318 1000044337 1000044344 1000044373 1000044374 1000044375 1000044377 1000044378 1000044379 1000044381 1000044395 1000025621 1000041611 1000044489 1000044490 1000044491 1000044494 1000044496 1000044505 1000044510 1000044527 1000044537 1000044541 1000044561 1000044562 1000038566 1000044598 1000019315 1000044554 1000028844 1000044720 1000044769 1000009620 1000045345 1000045346 1000043055 1000045390 1000045543 1000045544 1000045545 1000045546 1000045547 1000045548 1000045549 1000045550 1000045589 1000045590 1000045591 1000045592 1000045593 1000045594 1000045595 1000045596 1000045597 1000045598 1000045599 1000045600 1000045601 1000045602 1000045603 1000045604 1000045605 1000045606 1000045609 1000045624 1000045625 1000045626 1000045628 1000045632 1000045635 1000010963 1000046055 1000017941 1000037448 1000042538 1000046211 1000046213 1000046215 1000046246 1000046278 1000046350 1000046375 1000040964 1000046880 1000046900 1000047158 1000047424 1000047422 1000044971 1000047277 1000047514 1000047524 1000040096 1000043611 1000047571 1000026446 1000047609 1000047610 1000046911 1000047779 1000047749 1000042407 1000045634 1000042922 1000045364 1000023316 1000047952 1000047978 1000047979 1000048010 1000048064 1000048065 1000048091 1000025959 1000048106 1000048107 1000047265 1000048291 1000048292 1000048298 1000048312 1000048326 1000048368 1000035758 1000044034 1000048172 1000028254 1000036186 1000018910 1000015384 1000048512 1000038606 1000048545 1000048556 1000048558 1000006317 1000048290 1000026647 1000048531 1000047904 1000029876 1000030104 1000034670 1000048698 1000026762 1000048702 1000048469 1000024047 1000048720 1000048787 1000048788 1000031969 1000048179 1000048936 1000048937 1000032416 1000049024 1000048827 1000048493 1000014925 1000049105 1000049110 1000024541 1000049161 1000048647 1000048836 1000042304 1000049244 1000049254 1000049256 1000047888 1000049347 1000049399 1000026844 1000036973 1000048911 1000049488 1000049486 1000049512 1000046549 1000049522 1000049523 1000049540 1000049546 1000049548 1000042321 1000048887 1000049624 1000045610 1000049828 1000049838 1000049877 1000048126 1000049967 1000049968 1000049635 1000049991 1000048253 1000050065 1000017399 1000042940 1000050196 1000050272 1000050273 1000050327 1000050336 1000050373 1000048934 1000050302 1000050543 1000050550 1000050569 1000050590 1000050593 1000050501 1000029246 1000050198 1000047804 1000015302 1000050565 1000034770 1000034783 1000050875 1000050881 1000050889 1000050955 1000051083 1000051087 1000047735 1000035862 1000051117 1000051128 1000035896 1000051130 1000051132 1000051133 1000039012 1000035834 1000050951 1000051223 1000037063 1000050724 1000006785 1000048587 1000050835 1000051289 1000050891 1000051224 1000051375 1000051376 1000050620 1000024451 1000051422 1000051450 1000034616 1000047564 1000051568 1000051569 1000050807 1000051607 1000051627 1000050514 1000051656 1000050919 1000051733 1000051816 1000051817 1000051837 1000051065 1000051903 1000051931 1000051959 1000051989 1000049911 1000048804 1000052138 1000052143 1000017264 1000052131 1000051215 1000052241 1000052292 1000052293 1000036683 1000048930 1000052330 1000052352 1000052353 1000052358 1000052359 1000052385 1000052401 1000038839 1000041510 1000043879 1000051433 1000052424 1000048104 1000052454 1000052458 1000052479 1000052493 1000052496 1000050290 1000051490 1000052655 1000052672 1000052728 1000052729 1000052765 1000052766 1000052778 1000052794 1000052801 1000052808 1000052811 1000050598 1000052044 1000052859 1000052887 1000052941 1000048850 1000053011 1000053115 1000052742 1000047046 1000049668 1000053241 1000049647 1000053239 1000052414 1000003912 1000053332 1000053340 1000053342 1000051988 1000052810 1000053467 1000053180 1000053321 1000053495 284814 ] |
|
1510.17 ms (42.99%) |
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:
[ 284814 "2025-02-12 09:14:18" ] |
|
124.63 ms (3.55%) |
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:
[
"89661-rollers-de-correction-couleur-n-c-896616"
]
|
|
14.80 ms (0.42%) |
10 |
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" 9616 ] |
|
5.51 ms (0.16%) |
4 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_id AS product_id_3, t0.characteristic_label_id AS characteristic_label_id_4 FROM characteristic t0 WHERE t0.product_id = ? AND t0.characteristic_label_id = ? LIMIT 1
Parameters:
[ 9616 7 ] |
|
3.76 ms (0.11%) |
17 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value1 AS value1_3, t0.value2 AS value2_4, t0.value3 AS value3_5 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"ourClientsAlsoBoughtMonths"
]
|
|
3.46 ms (0.10%) |
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:
[ 284814 1 ] |
|
2.92 ms (0.08%) |
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
]
|
|
2.39 ms (0.07%) |
5 |
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:
[ 9616 0 ] |
|
2.37 ms (0.07%) |
10 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.affiliated_society AS affiliated_society_3, t0.address1 AS address1_4, t0.address2 AS address2_5, t0.address3 AS address3_6, t0.zip_code AS zip_code_7, t0.city AS city_8, t0.email AS email_9, t0.phone_number AS phone_number_10, t0.fax AS fax_11, t0.id_deposit AS id_deposit_12, t0.gen_code AS gen_code_13, t0.newspaper AS newspaper_14, t0.siren AS siren_15, t0.ape AS ape_16, t0.trading_registry AS trading_registry_17, t0.internal_tva AS internal_tva_18, t0.rib AS rib_19, t0.general_account AS general_account_20, t0.capital AS capital_21 FROM society t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"MOZ"
]
|
|
2.16 ms (0.06%) |
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:
[ 57 270 271 272 273 274 274 284814 ] |
|
1.82 ms (0.05%) |
11 |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
|
1.59 ms (0.05%) |
5 |
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:
[ 9616 "C" ] |
|
1.41 ms (0.04%) |
5 |
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 09:14:22" "%2%" 9616 ] |
|
1.35 ms (0.04%) |
5 |
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:
[
9616
]
|
|
1.04 ms (0.03%) |
5 |
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:
[
9616
]
|
|
0.91 ms (0.03%) |
3 |
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:
[ 9616 9960313 ] |
|
0.79 ms (0.02%) |
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:
[
198012
]
|
|
0.76 ms (0.02%) |
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 = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC
Parameters:
[
54453
]
|
|
0.59 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:
[
"89661-rollers-de-correction-couleur-n-c-896616"
]
|
|
0.47 ms (0.01%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
|
0.38 ms (0.01%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.displayed_order AS displayed_order_2, c0_.is_in_footer AS is_in_footer_3, c0_.slug AS slug_4, c1_.id AS id_5, c1_.name AS name_6, c1_.displayed_order AS displayed_order_7, c1_.is_in_footer AS is_in_footer_8, c1_.slug AS slug_9, c2_.id AS id_10, c2_.name AS name_11, c2_.displayed_order AS displayed_order_12, c2_.is_in_footer AS is_in_footer_13, c2_.slug AS slug_14, c0_.category_parent_id AS category_parent_id_15, c1_.category_parent_id AS category_parent_id_16, c2_.category_parent_id AS category_parent_id_17 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.category_parent_id LEFT JOIN category c2_ ON c1_.id = c2_.category_parent_id WHERE c0_.slug = ?
Parameters:
[
"89661-rollers-de-correction-couleur-n-c-896616"
]
|
|
0.25 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:
[
284814
]
|
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.