Symfony Profiler

Query Metrics

90 Database Queries

13 Different statements

51.33 ms Query time

0 Invalid entities

940 Managed entities

Queries


SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM label t0 ORDER BY t0.name ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM artist t0 ORDER BY t0.name ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2 FROM style s0_ ORDER BY s0_.name ASC
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 WHERE t0.id = ?
SELECT t0.id AS id_4, t0.ref AS ref_5, t0.designation AS designation_6, t0.created_at AS created_at_7, t0.price AS price_8, t0.updated_at AS updated_at_9, t0.promo AS promo_10, t0.description AS description_11, t0.slug AS slug_12, t0.quantity AS quantity_13, t0.weight AS weight_14, t0.category_id AS category_id_15, t0.category, t1.format AS format_16, t1.year AS year_17, t1.state AS state_18, t1.img AS img_19, t1.nb_items AS nb_items_20, t1.label_id AS label_id_21, t2.year AS year_22, t2.state AS state_23, t2.label_id AS label_id_24, t3.state AS state_25, t3.img AS img_26 FROM product t0 LEFT JOIN vinyl t1 ON t0.id = t1.id LEFT JOIN cd t2 ON t0.id = t2.id LEFT JOIN accessory t3 ON t0.id = t3.id INNER JOIN product_promote ON t0.id = product_promote.product_id WHERE product_promote.promote_id = ? ORDER BY t0.created_at DESC
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_4, t0.ref AS ref_5, t0.designation AS designation_6, t0.created_at AS created_at_7, t0.price AS price_8, t0.updated_at AS updated_at_9, t0.promo AS promo_10, t0.description AS description_11, t0.slug AS slug_12, t0.quantity AS quantity_13, t0.weight AS weight_14, t0.category_id AS category_id_15, t0.category, t1.format AS format_16, t1.year AS year_17, t1.state AS state_18, t1.img AS img_19, t1.nb_items AS nb_items_20, t1.label_id AS label_id_21, t2.year AS year_22, t2.state AS state_23, t2.label_id AS label_id_24, t3.state AS state_25, t3.img AS img_26 FROM product t0 LEFT JOIN vinyl t1 ON t0.id = t1.id LEFT JOIN cd t2 ON t0.id = t2.id LEFT JOIN accessory t3 ON t0.id = t3.id INNER JOIN product_promote ON t0.id = product_promote.product_id WHERE product_promote.promote_id = ? ORDER BY t0.created_at DESC
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_4, t0.ref AS ref_5, t0.designation AS designation_6, t0.created_at AS created_at_7, t0.price AS price_8, t0.updated_at AS updated_at_9, t0.promo AS promo_10, t0.description AS description_11, t0.slug AS slug_12, t0.quantity AS quantity_13, t0.weight AS weight_14, t0.category_id AS category_id_15, t0.category, t1.format AS format_16, t1.year AS year_17, t1.state AS state_18, t1.img AS img_19, t1.nb_items AS nb_items_20, t1.label_id AS label_id_21, t2.year AS year_22, t2.state AS state_23, t2.label_id AS label_id_24, t3.state AS state_25, t3.img AS img_26 FROM product t0 LEFT JOIN vinyl t1 ON t0.id = t1.id LEFT JOIN cd t2 ON t0.id = t2.id LEFT JOIN accessory t3 ON t0.id = t3.id INNER JOIN product_promote ON t0.id = product_promote.product_id WHERE product_promote.promote_id = ? ORDER BY t0.created_at DESC
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 WHERE t0.id = ?
SELECT t0.id AS id_4, t0.ref AS ref_5, t0.designation AS designation_6, t0.created_at AS created_at_7, t0.price AS price_8, t0.updated_at AS updated_at_9, t0.promo AS promo_10, t0.description AS description_11, t0.slug AS slug_12, t0.quantity AS quantity_13, t0.weight AS weight_14, t0.category_id AS category_id_15, t0.category, t1.format AS format_16, t1.year AS year_17, t1.state AS state_18, t1.img AS img_19, t1.nb_items AS nb_items_20, t1.label_id AS label_id_21, t2.year AS year_22, t2.state AS state_23, t2.label_id AS label_id_24, t3.state AS state_25, t3.img AS img_26 FROM product t0 LEFT JOIN vinyl t1 ON t0.id = t1.id LEFT JOIN cd t2 ON t0.id = t2.id LEFT JOIN accessory t3 ON t0.id = t3.id INNER JOIN product_promote ON t0.id = product_promote.product_id WHERE product_promote.promote_id = ? ORDER BY t0.created_at DESC
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_4, t0.ref AS ref_5, t0.designation AS designation_6, t0.created_at AS created_at_7, t0.price AS price_8, t0.updated_at AS updated_at_9, t0.promo AS promo_10, t0.description AS description_11, t0.slug AS slug_12, t0.quantity AS quantity_13, t0.weight AS weight_14, t0.category_id AS category_id_15, t0.category, t1.format AS format_16, t1.year AS year_17, t1.state AS state_18, t1.img AS img_19, t1.nb_items AS nb_items_20, t1.label_id AS label_id_21, t2.year AS year_22, t2.state AS state_23, t2.label_id AS label_id_24, t3.state AS state_25, t3.img AS img_26 FROM product t0 LEFT JOIN vinyl t1 ON t0.id = t1.id LEFT JOIN cd t2 ON t0.id = t2.id LEFT JOIN accessory t3 ON t0.id = t3.id INNER JOIN product_promote ON t0.id = product_promote.product_id WHERE product_promote.promote_id = ? ORDER BY t0.created_at DESC
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ?
SELECT t1.id AS id_2, t1.ref AS ref_3, t1.designation AS designation_4, t1.created_at AS created_at_5, t1.price AS price_6, t1.updated_at AS updated_at_7, t1.promo AS promo_8, t1.description AS description_9, t1.slug AS slug_10, t1.quantity AS quantity_11, t1.weight AS weight_12, t0.state AS state_13, t0.img AS img_14, t1.category_id AS category_id_15, t1.category FROM accessory t0 INNER JOIN product t1 ON t0.id = t1.id ORDER BY t1.updated_at DESC
SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 WHERE t0.name = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.ref AS ref_1, p0_.designation AS designation_2, p0_.created_at AS created_at_3, p0_.price AS price_4, p0_.updated_at AS updated_at_5, p0_.promo AS promo_6, p0_.description AS description_7, p0_.slug AS slug_8, p0_.quantity AS quantity_9, p0_.weight AS weight_10, v1_.format AS format_11, v1_.year AS year_12, v1_.state AS state_13, v1_.img AS img_14, v1_.nb_items AS nb_items_15, s2_.id AS id_16, s2_.name AS name_17, s2_.slug AS slug_18, p0_.category AS category_19, p0_.category_id AS category_id_20, v1_.label_id AS label_id_21 FROM vinyl v1_ INNER JOIN product p0_ ON v1_.id = p0_.id LEFT JOIN vinyl_style v3_ ON v1_.id = v3_.vinyl_id LEFT JOIN style s2_ ON s2_.id = v3_.style_id WHERE NOT EXISTS (SELECT 1 FROM product_promote p4_ WHERE p4_.product_id = v1_.id AND p4_.promote_id IN (?)) ORDER BY p0_.id DESC, s2_.name ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.start_at AS start_at_4, t0.end_at AS end_at_5 FROM params t0
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.slug AS slug_2 FROM label l0_ ORDER BY l0_.name ASC
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2 FROM artist a0_ ORDER BY a0_.name ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM style t0 ORDER BY t0.name ASC

#▲	Time	Info
1	2.47 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM label t0 ORDER BY t0.name ASC Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM label t0 ORDER BY t0.name ASC SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM label t0 ORDER BY t0.name ASC;
2	2.27 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM artist t0 ORDER BY t0.name ASC Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM artist t0 ORDER BY t0.name ASC SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM artist t0 ORDER BY t0.name ASC;
3	1.39 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2 FROM style s0_ ORDER BY s0_.name ASC Parameters: [] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2 FROM style s0_ ORDER BY s0_.name ASC SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2 FROM style s0_ ORDER BY s0_.name ASC;
4	1.27 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 WHERE t0.id = 1;
5	4.21 ms	SELECT t0.id AS id_4, t0.ref AS ref_5, t0.designation AS designation_6, t0.created_at AS created_at_7, t0.price AS price_8, t0.updated_at AS updated_at_9, t0.promo AS promo_10, t0.description AS description_11, t0.slug AS slug_12, t0.quantity AS quantity_13, t0.weight AS weight_14, t0.category_id AS category_id_15, t0.category, t1.format AS format_16, t1.year AS year_17, t1.state AS state_18, t1.img AS img_19, t1.nb_items AS nb_items_20, t1.label_id AS label_id_21, t2.year AS year_22, t2.state AS state_23, t2.label_id AS label_id_24, t3.state AS state_25, t3.img AS img_26 FROM product t0 LEFT JOIN vinyl t1 ON t0.id = t1.id LEFT JOIN cd t2 ON t0.id = t2.id LEFT JOIN accessory t3 ON t0.id = t3.id INNER JOIN product_promote ON t0.id = product_promote.product_id WHERE product_promote.promote_id = ? ORDER BY t0.created_at DESC Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_4, t0.ref AS ref_5, t0.designation AS designation_6, t0.created_at AS created_at_7, t0.price AS price_8, t0.updated_at AS updated_at_9, t0.promo AS promo_10, t0.description AS description_11, t0.slug AS slug_12, t0.quantity AS quantity_13, t0.weight AS weight_14, t0.category_id AS category_id_15, t0.category, t1.format AS format_16, t1.year AS year_17, t1.state AS state_18, t1.img AS img_19, t1.nb_items AS nb_items_20, t1.label_id AS label_id_21, t2.year AS year_22, t2.state AS state_23, t2.label_id AS label_id_24, t3.state AS state_25, t3.img AS img_26 FROM product t0 LEFT JOIN vinyl t1 ON t0.id = t1.id LEFT JOIN cd t2 ON t0.id = t2.id LEFT JOIN accessory t3 ON t0.id = t3.id INNER JOIN product_promote ON t0.id = product_promote.product_id WHERE product_promote.promote_id = ? ORDER BY t0.created_at DESC SELECT t0.id AS id_4, t0.ref AS ref_5, t0.designation AS designation_6, t0.created_at AS created_at_7, t0.price AS price_8, t0.updated_at AS updated_at_9, t0.promo AS promo_10, t0.description AS description_11, t0.slug AS slug_12, t0.quantity AS quantity_13, t0.weight AS weight_14, t0.category_id AS category_id_15, t0.category, t1.format AS format_16, t1.year AS year_17, t1.state AS state_18, t1.img AS img_19, t1.nb_items AS nb_items_20, t1.label_id AS label_id_21, t2.year AS year_22, t2.state AS state_23, t2.label_id AS label_id_24, t3.state AS state_25, t3.img AS img_26 FROM product t0 LEFT JOIN vinyl t1 ON t0.id = t1.id LEFT JOIN cd t2 ON t0.id = t2.id LEFT JOIN accessory t3 ON t0.id = t3.id INNER JOIN product_promote ON t0.id = product_promote.product_id WHERE product_promote.promote_id = 1 ORDER BY t0.created_at DESC;
6	0.61 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`209`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 209;
7	0.42 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`208`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 208;
8	0.41 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`207`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 207;
9	0.44 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`183`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 183;
10	0.40 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`182`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 182;
11	0.39 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`181`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 181;
12	0.39 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`171`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 171;
13	0.46 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`168`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 168;
14	0.43 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`167`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 167;
15	0.48 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`148`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 148;
16	0.48 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`147`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 147;
17	0.46 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`146`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 146;
18	0.40 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`132`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 132;
19	0.44 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`131`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 131;
20	0.43 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`24`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 24;
21	1.12 ms	SELECT t0.id AS id_4, t0.ref AS ref_5, t0.designation AS designation_6, t0.created_at AS created_at_7, t0.price AS price_8, t0.updated_at AS updated_at_9, t0.promo AS promo_10, t0.description AS description_11, t0.slug AS slug_12, t0.quantity AS quantity_13, t0.weight AS weight_14, t0.category_id AS category_id_15, t0.category, t1.format AS format_16, t1.year AS year_17, t1.state AS state_18, t1.img AS img_19, t1.nb_items AS nb_items_20, t1.label_id AS label_id_21, t2.year AS year_22, t2.state AS state_23, t2.label_id AS label_id_24, t3.state AS state_25, t3.img AS img_26 FROM product t0 LEFT JOIN vinyl t1 ON t0.id = t1.id LEFT JOIN cd t2 ON t0.id = t2.id LEFT JOIN accessory t3 ON t0.id = t3.id INNER JOIN product_promote ON t0.id = product_promote.product_id WHERE product_promote.promote_id = ? ORDER BY t0.created_at DESC Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.id AS id_4, t0.ref AS ref_5, t0.designation AS designation_6, t0.created_at AS created_at_7, t0.price AS price_8, t0.updated_at AS updated_at_9, t0.promo AS promo_10, t0.description AS description_11, t0.slug AS slug_12, t0.quantity AS quantity_13, t0.weight AS weight_14, t0.category_id AS category_id_15, t0.category, t1.format AS format_16, t1.year AS year_17, t1.state AS state_18, t1.img AS img_19, t1.nb_items AS nb_items_20, t1.label_id AS label_id_21, t2.year AS year_22, t2.state AS state_23, t2.label_id AS label_id_24, t3.state AS state_25, t3.img AS img_26 FROM product t0 LEFT JOIN vinyl t1 ON t0.id = t1.id LEFT JOIN cd t2 ON t0.id = t2.id LEFT JOIN accessory t3 ON t0.id = t3.id INNER JOIN product_promote ON t0.id = product_promote.product_id WHERE product_promote.promote_id = ? ORDER BY t0.created_at DESC SELECT t0.id AS id_4, t0.ref AS ref_5, t0.designation AS designation_6, t0.created_at AS created_at_7, t0.price AS price_8, t0.updated_at AS updated_at_9, t0.promo AS promo_10, t0.description AS description_11, t0.slug AS slug_12, t0.quantity AS quantity_13, t0.weight AS weight_14, t0.category_id AS category_id_15, t0.category, t1.format AS format_16, t1.year AS year_17, t1.state AS state_18, t1.img AS img_19, t1.nb_items AS nb_items_20, t1.label_id AS label_id_21, t2.year AS year_22, t2.state AS state_23, t2.label_id AS label_id_24, t3.state AS state_25, t3.img AS img_26 FROM product t0 LEFT JOIN vinyl t1 ON t0.id = t1.id LEFT JOIN cd t2 ON t0.id = t2.id LEFT JOIN accessory t3 ON t0.id = t3.id INNER JOIN product_promote ON t0.id = product_promote.product_id WHERE product_promote.promote_id = 2 ORDER BY t0.created_at DESC;
22	0.41 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`211`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 211;
23	0.39 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`205`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 205;
24	0.39 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`203`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 203;
25	0.51 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`188`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 188;
26	0.45 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`176`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 176;
27	0.40 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`173`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 173;
28	0.43 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`159`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 159;
29	0.39 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`155`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 155;
30	0.39 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`149`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 149;
31	0.40 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`145`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 145;
32	0.38 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`15`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 15;
33	0.42 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`14`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 14;
34	0.38 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`11`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 11;
35	0.43 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 8;
36	0.42 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 3;
37	1.22 ms	SELECT t0.id AS id_4, t0.ref AS ref_5, t0.designation AS designation_6, t0.created_at AS created_at_7, t0.price AS price_8, t0.updated_at AS updated_at_9, t0.promo AS promo_10, t0.description AS description_11, t0.slug AS slug_12, t0.quantity AS quantity_13, t0.weight AS weight_14, t0.category_id AS category_id_15, t0.category, t1.format AS format_16, t1.year AS year_17, t1.state AS state_18, t1.img AS img_19, t1.nb_items AS nb_items_20, t1.label_id AS label_id_21, t2.year AS year_22, t2.state AS state_23, t2.label_id AS label_id_24, t3.state AS state_25, t3.img AS img_26 FROM product t0 LEFT JOIN vinyl t1 ON t0.id = t1.id LEFT JOIN cd t2 ON t0.id = t2.id LEFT JOIN accessory t3 ON t0.id = t3.id INNER JOIN product_promote ON t0.id = product_promote.product_id WHERE product_promote.promote_id = ? ORDER BY t0.created_at DESC Parameters: [`3`] View formatted query View runnable query Explain query SELECT t0.id AS id_4, t0.ref AS ref_5, t0.designation AS designation_6, t0.created_at AS created_at_7, t0.price AS price_8, t0.updated_at AS updated_at_9, t0.promo AS promo_10, t0.description AS description_11, t0.slug AS slug_12, t0.quantity AS quantity_13, t0.weight AS weight_14, t0.category_id AS category_id_15, t0.category, t1.format AS format_16, t1.year AS year_17, t1.state AS state_18, t1.img AS img_19, t1.nb_items AS nb_items_20, t1.label_id AS label_id_21, t2.year AS year_22, t2.state AS state_23, t2.label_id AS label_id_24, t3.state AS state_25, t3.img AS img_26 FROM product t0 LEFT JOIN vinyl t1 ON t0.id = t1.id LEFT JOIN cd t2 ON t0.id = t2.id LEFT JOIN accessory t3 ON t0.id = t3.id INNER JOIN product_promote ON t0.id = product_promote.product_id WHERE product_promote.promote_id = ? ORDER BY t0.created_at DESC SELECT t0.id AS id_4, t0.ref AS ref_5, t0.designation AS designation_6, t0.created_at AS created_at_7, t0.price AS price_8, t0.updated_at AS updated_at_9, t0.promo AS promo_10, t0.description AS description_11, t0.slug AS slug_12, t0.quantity AS quantity_13, t0.weight AS weight_14, t0.category_id AS category_id_15, t0.category, t1.format AS format_16, t1.year AS year_17, t1.state AS state_18, t1.img AS img_19, t1.nb_items AS nb_items_20, t1.label_id AS label_id_21, t2.year AS year_22, t2.state AS state_23, t2.label_id AS label_id_24, t3.state AS state_25, t3.img AS img_26 FROM product t0 LEFT JOIN vinyl t1 ON t0.id = t1.id LEFT JOIN cd t2 ON t0.id = t2.id LEFT JOIN accessory t3 ON t0.id = t3.id INNER JOIN product_promote ON t0.id = product_promote.product_id WHERE product_promote.promote_id = 3 ORDER BY t0.created_at DESC;
38	0.55 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`224`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 224;
39	0.40 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`220`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 220;
40	0.40 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`219`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 219;
41	0.40 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`217`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 217;
42	0.40 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`216`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 216;
43	0.44 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`215`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 215;
44	0.49 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`204`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 204;
45	0.46 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`202`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 202;
46	0.45 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`199`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 199;
47	0.39 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`198`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 198;
48	0.36 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`197`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 197;
49	0.34 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`196`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 196;
50	0.36 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`195`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 195;
51	0.35 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`194`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 194;
52	0.34 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`193`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 193;
53	0.38 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`191`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 191;
54	0.34 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`190`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 190;
55	0.35 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`187`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 187;
56	0.35 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`180`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 180;
57	0.35 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`179`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 179;
58	0.35 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`178`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 178;
59	0.35 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`177`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 177;
60	0.35 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`175`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 175;
61	0.34 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`174`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 174;
62	0.34 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`165`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 165;
63	0.39 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`164`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 164;
64	0.36 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`163`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 163;
65	0.35 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`162`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 162;
66	0.37 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`157`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 157;
67	0.34 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`156`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 156;
68	0.33 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`151`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 151;
69	0.34 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`144`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 144;
70	0.34 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`143`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 143;
71	0.34 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`26`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 26;
72	0.33 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`22`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 22;
73	0.35 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`21`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 21;
74	0.35 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`19`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 19;
75	0.32 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`18`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 18;
76	0.33 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`17`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 17;
77	0.33 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`16`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 16;
78	0.28 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 WHERE t0.id = ? Parameters: [`4`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 WHERE t0.id = 4;
79	0.57 ms	SELECT t0.id AS id_4, t0.ref AS ref_5, t0.designation AS designation_6, t0.created_at AS created_at_7, t0.price AS price_8, t0.updated_at AS updated_at_9, t0.promo AS promo_10, t0.description AS description_11, t0.slug AS slug_12, t0.quantity AS quantity_13, t0.weight AS weight_14, t0.category_id AS category_id_15, t0.category, t1.format AS format_16, t1.year AS year_17, t1.state AS state_18, t1.img AS img_19, t1.nb_items AS nb_items_20, t1.label_id AS label_id_21, t2.year AS year_22, t2.state AS state_23, t2.label_id AS label_id_24, t3.state AS state_25, t3.img AS img_26 FROM product t0 LEFT JOIN vinyl t1 ON t0.id = t1.id LEFT JOIN cd t2 ON t0.id = t2.id LEFT JOIN accessory t3 ON t0.id = t3.id INNER JOIN product_promote ON t0.id = product_promote.product_id WHERE product_promote.promote_id = ? ORDER BY t0.created_at DESC Parameters: [`4`] View formatted query View runnable query Explain query SELECT t0.id AS id_4, t0.ref AS ref_5, t0.designation AS designation_6, t0.created_at AS created_at_7, t0.price AS price_8, t0.updated_at AS updated_at_9, t0.promo AS promo_10, t0.description AS description_11, t0.slug AS slug_12, t0.quantity AS quantity_13, t0.weight AS weight_14, t0.category_id AS category_id_15, t0.category, t1.format AS format_16, t1.year AS year_17, t1.state AS state_18, t1.img AS img_19, t1.nb_items AS nb_items_20, t1.label_id AS label_id_21, t2.year AS year_22, t2.state AS state_23, t2.label_id AS label_id_24, t3.state AS state_25, t3.img AS img_26 FROM product t0 LEFT JOIN vinyl t1 ON t0.id = t1.id LEFT JOIN cd t2 ON t0.id = t2.id LEFT JOIN accessory t3 ON t0.id = t3.id INNER JOIN product_promote ON t0.id = product_promote.product_id WHERE product_promote.promote_id = ? ORDER BY t0.created_at DESC SELECT t0.id AS id_4, t0.ref AS ref_5, t0.designation AS designation_6, t0.created_at AS created_at_7, t0.price AS price_8, t0.updated_at AS updated_at_9, t0.promo AS promo_10, t0.description AS description_11, t0.slug AS slug_12, t0.quantity AS quantity_13, t0.weight AS weight_14, t0.category_id AS category_id_15, t0.category, t1.format AS format_16, t1.year AS year_17, t1.state AS state_18, t1.img AS img_19, t1.nb_items AS nb_items_20, t1.label_id AS label_id_21, t2.year AS year_22, t2.state AS state_23, t2.label_id AS label_id_24, t3.state AS state_25, t3.img AS img_26 FROM product t0 LEFT JOIN vinyl t1 ON t0.id = t1.id LEFT JOIN cd t2 ON t0.id = t2.id LEFT JOIN accessory t3 ON t0.id = t3.id INNER JOIN product_promote ON t0.id = product_promote.product_id WHERE product_promote.promote_id = 4 ORDER BY t0.created_at DESC;
80	0.35 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`222`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 222;
81	0.70 ms	SELECT t0.id AS id_4, t0.ref AS ref_5, t0.designation AS designation_6, t0.created_at AS created_at_7, t0.price AS price_8, t0.updated_at AS updated_at_9, t0.promo AS promo_10, t0.description AS description_11, t0.slug AS slug_12, t0.quantity AS quantity_13, t0.weight AS weight_14, t0.category_id AS category_id_15, t0.category, t1.format AS format_16, t1.year AS year_17, t1.state AS state_18, t1.img AS img_19, t1.nb_items AS nb_items_20, t1.label_id AS label_id_21, t2.year AS year_22, t2.state AS state_23, t2.label_id AS label_id_24, t3.state AS state_25, t3.img AS img_26 FROM product t0 LEFT JOIN vinyl t1 ON t0.id = t1.id LEFT JOIN cd t2 ON t0.id = t2.id LEFT JOIN accessory t3 ON t0.id = t3.id INNER JOIN product_promote ON t0.id = product_promote.product_id WHERE product_promote.promote_id = ? ORDER BY t0.created_at DESC Parameters: [`6`] View formatted query View runnable query Explain query SELECT t0.id AS id_4, t0.ref AS ref_5, t0.designation AS designation_6, t0.created_at AS created_at_7, t0.price AS price_8, t0.updated_at AS updated_at_9, t0.promo AS promo_10, t0.description AS description_11, t0.slug AS slug_12, t0.quantity AS quantity_13, t0.weight AS weight_14, t0.category_id AS category_id_15, t0.category, t1.format AS format_16, t1.year AS year_17, t1.state AS state_18, t1.img AS img_19, t1.nb_items AS nb_items_20, t1.label_id AS label_id_21, t2.year AS year_22, t2.state AS state_23, t2.label_id AS label_id_24, t3.state AS state_25, t3.img AS img_26 FROM product t0 LEFT JOIN vinyl t1 ON t0.id = t1.id LEFT JOIN cd t2 ON t0.id = t2.id LEFT JOIN accessory t3 ON t0.id = t3.id INNER JOIN product_promote ON t0.id = product_promote.product_id WHERE product_promote.promote_id = ? ORDER BY t0.created_at DESC SELECT t0.id AS id_4, t0.ref AS ref_5, t0.designation AS designation_6, t0.created_at AS created_at_7, t0.price AS price_8, t0.updated_at AS updated_at_9, t0.promo AS promo_10, t0.description AS description_11, t0.slug AS slug_12, t0.quantity AS quantity_13, t0.weight AS weight_14, t0.category_id AS category_id_15, t0.category, t1.format AS format_16, t1.year AS year_17, t1.state AS state_18, t1.img AS img_19, t1.nb_items AS nb_items_20, t1.label_id AS label_id_21, t2.year AS year_22, t2.state AS state_23, t2.label_id AS label_id_24, t3.state AS state_25, t3.img AS img_26 FROM product t0 LEFT JOIN vinyl t1 ON t0.id = t1.id LEFT JOIN cd t2 ON t0.id = t2.id LEFT JOIN accessory t3 ON t0.id = t3.id INNER JOIN product_promote ON t0.id = product_promote.product_id WHERE product_promote.promote_id = 6 ORDER BY t0.created_at DESC;
82	0.37 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`226`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 226;
83	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? Parameters: [`189`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 INNER JOIN product_promote ON t0.id = product_promote.promote_id WHERE product_promote.product_id = 189;
84	0.33 ms	SELECT t1.id AS id_2, t1.ref AS ref_3, t1.designation AS designation_4, t1.created_at AS created_at_5, t1.price AS price_6, t1.updated_at AS updated_at_7, t1.promo AS promo_8, t1.description AS description_9, t1.slug AS slug_10, t1.quantity AS quantity_11, t1.weight AS weight_12, t0.state AS state_13, t0.img AS img_14, t1.category_id AS category_id_15, t1.category FROM accessory t0 INNER JOIN product t1 ON t0.id = t1.id ORDER BY t1.updated_at DESC Parameters: [] View formatted query View runnable query Explain query SELECT t1.id AS id_2, t1.ref AS ref_3, t1.designation AS designation_4, t1.created_at AS created_at_5, t1.price AS price_6, t1.updated_at AS updated_at_7, t1.promo AS promo_8, t1.description AS description_9, t1.slug AS slug_10, t1.quantity AS quantity_11, t1.weight AS weight_12, t0.state AS state_13, t0.img AS img_14, t1.category_id AS category_id_15, t1.category FROM accessory t0 INNER JOIN product t1 ON t0.id = t1.id ORDER BY t1.updated_at DESC SELECT t1.id AS id_2, t1.ref AS ref_3, t1.designation AS designation_4, t1.created_at AS created_at_5, t1.price AS price_6, t1.updated_at AS updated_at_7, t1.promo AS promo_8, t1.description AS description_9, t1.slug AS slug_10, t1.quantity AS quantity_11, t1.weight AS weight_12, t0.state AS state_13, t0.img AS img_14, t1.category_id AS category_id_15, t1.category FROM accessory t0 INNER JOIN product t1 ON t0.id = t1.id ORDER BY t1.updated_at DESC;
85	0.29 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"pre-order"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2 FROM promote t0 WHERE t0.name = 'pre-order' LIMIT 1;
86	4.04 ms	SELECT p0_.id AS id_0, p0_.ref AS ref_1, p0_.designation AS designation_2, p0_.created_at AS created_at_3, p0_.price AS price_4, p0_.updated_at AS updated_at_5, p0_.promo AS promo_6, p0_.description AS description_7, p0_.slug AS slug_8, p0_.quantity AS quantity_9, p0_.weight AS weight_10, v1_.format AS format_11, v1_.year AS year_12, v1_.state AS state_13, v1_.img AS img_14, v1_.nb_items AS nb_items_15, s2_.id AS id_16, s2_.name AS name_17, s2_.slug AS slug_18, p0_.category AS category_19, p0_.category_id AS category_id_20, v1_.label_id AS label_id_21 FROM vinyl v1_ INNER JOIN product p0_ ON v1_.id = p0_.id LEFT JOIN vinyl_style v3_ ON v1_.id = v3_.vinyl_id LEFT JOIN style s2_ ON s2_.id = v3_.style_id WHERE NOT EXISTS (SELECT 1 FROM product_promote p4_ WHERE p4_.product_id = v1_.id AND p4_.promote_id IN (?)) ORDER BY p0_.id DESC, s2_.name ASC Parameters: [`7`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.ref AS ref_1, p0_.designation AS designation_2, p0_.created_at AS created_at_3, p0_.price AS price_4, p0_.updated_at AS updated_at_5, p0_.promo AS promo_6, p0_.description AS description_7, p0_.slug AS slug_8, p0_.quantity AS quantity_9, p0_.weight AS weight_10, v1_.format AS format_11, v1_.year AS year_12, v1_.state AS state_13, v1_.img AS img_14, v1_.nb_items AS nb_items_15, s2_.id AS id_16, s2_.name AS name_17, s2_.slug AS slug_18, p0_.category AS category_19, p0_.category_id AS category_id_20, v1_.label_id AS label_id_21 FROM vinyl v1_ INNER JOIN product p0_ ON v1_.id = p0_.id LEFT JOIN vinyl_style v3_ ON v1_.id = v3_.vinyl_id LEFT JOIN style s2_ ON s2_.id = v3_.style_id WHERE NOT EXISTS ( SELECT 1 FROM product_promote p4_ WHERE p4_.product_id = v1_.id AND p4_.promote_id IN (?) ) ORDER BY p0_.id DESC, s2_.name ASC SELECT p0_.id AS id_0, p0_.ref AS ref_1, p0_.designation AS designation_2, p0_.created_at AS created_at_3, p0_.price AS price_4, p0_.updated_at AS updated_at_5, p0_.promo AS promo_6, p0_.description AS description_7, p0_.slug AS slug_8, p0_.quantity AS quantity_9, p0_.weight AS weight_10, v1_.format AS format_11, v1_.year AS year_12, v1_.state AS state_13, v1_.img AS img_14, v1_.nb_items AS nb_items_15, s2_.id AS id_16, s2_.name AS name_17, s2_.slug AS slug_18, p0_.category AS category_19, p0_.category_id AS category_id_20, v1_.label_id AS label_id_21 FROM vinyl v1_ INNER JOIN product p0_ ON v1_.id = p0_.id LEFT JOIN vinyl_style v3_ ON v1_.id = v3_.vinyl_id LEFT JOIN style s2_ ON s2_.id = v3_.style_id WHERE NOT EXISTS (SELECT 1 FROM product_promote p4_ WHERE p4_.product_id = v1_.id AND p4_.promote_id IN (7)) ORDER BY p0_.id DESC, s2_.name ASC;
87	0.86 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.start_at AS start_at_4, t0.end_at AS end_at_5 FROM params t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.start_at AS start_at_4, t0.end_at AS end_at_5 FROM params t0 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.start_at AS start_at_4, t0.end_at AS end_at_5 FROM params t0;
88	0.55 ms	SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.slug AS slug_2 FROM label l0_ ORDER BY l0_.name ASC Parameters: [] View formatted query View runnable query Explain query SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.slug AS slug_2 FROM label l0_ ORDER BY l0_.name ASC SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.slug AS slug_2 FROM label l0_ ORDER BY l0_.name ASC;
89	0.76 ms	SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2 FROM artist a0_ ORDER BY a0_.name ASC Parameters: [] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2 FROM artist a0_ ORDER BY a0_.name ASC SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2 FROM artist a0_ ORDER BY a0_.name ASC;
90	0.37 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM style t0 ORDER BY t0.name ASC Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM style t0 ORDER BY t0.name ASC SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM style t0 ORDER BY t0.name ASC;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Artist	463
App\Entity\Label	221
App\Entity\Product	221
App\Entity\Style	22
App\Entity\Promote	7
App\Entity\Params	4
App\Entity\Category	2

Entities Mapping

Class	Mapping errors
App\Entity\Label	No errors.
App\Entity\Product	No errors.
App\Entity\Vinyl	No errors.
App\Entity\Cd	No errors.
App\Entity\Artist	No errors.
App\Entity\Track	No errors.
App\Entity\Style	No errors.
App\Entity\Promote	No errors.
App\Entity\Accessory	No errors.
App\Entity\Category	No errors.
App\Entity\Detail	No errors.
App\Entity\VinylPreOrder	No errors.
App\Entity\Params	No errors.

Symfony Profiler

GET https://dev.mazykkavinyles.fr/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping