Symfony Profiler

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;

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
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 ORDER BY p0_.id DESC, s2_.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 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
  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;

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;

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;

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;

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;

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;

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;