Symfony Profiler

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.format AS format_13,
  t0.year AS year_14,
  t0.state AS state_15,
  t0.img AS img_16,
  t0.nb_items AS nb_items_17,
  t1.category_id AS category_id_18,
  t0.label_id AS label_id_19,
  t1.category
FROM
  vinyl t0
  INNER JOIN product t1 ON t0.id = t1.id
WHERE
  t1.slug = ?
LIMIT
  1

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.format AS format_13, t0.year AS year_14, t0.state AS state_15, t0.img AS img_16, t0.nb_items AS nb_items_17, t1.category_id AS category_id_18, t0.label_id AS label_id_19, t1.category FROM vinyl t0 INNER JOIN product t1 ON t0.id = t1.id WHERE t1.slug = 'dtrake-06' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.piste AS piste_3,
  t0.title AS title_4,
  t0.vinyl_id AS vinyl_id_5
FROM
  track t0
WHERE
  t0.vinyl_id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.piste AS piste_3, t0.title AS title_4, t0.vinyl_id AS vinyl_id_5 FROM track t0 WHERE t0.vinyl_id = 75;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  artist t0
  INNER JOIN track_artist ON t0.id = track_artist.artist_id
WHERE
  track_artist.track_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM artist t0 INNER JOIN track_artist ON t0.id = track_artist.artist_id WHERE track_artist.track_id = 272 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  artist t0
  INNER JOIN track_artist ON t0.id = track_artist.artist_id
WHERE
  track_artist.track_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM artist t0 INNER JOIN track_artist ON t0.id = track_artist.artist_id WHERE track_artist.track_id = 273 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  artist t0
  INNER JOIN track_artist ON t0.id = track_artist.artist_id
WHERE
  track_artist.track_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM artist t0 INNER JOIN track_artist ON t0.id = track_artist.artist_id WHERE track_artist.track_id = 274 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  artist t0
  INNER JOIN track_artist ON t0.id = track_artist.artist_id
WHERE
  track_artist.track_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM artist t0 INNER JOIN track_artist ON t0.id = track_artist.artist_id WHERE track_artist.track_id = 275 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 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_1, t0.name AS name_2 FROM promote t0 WHERE t0.id = 1;

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
  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 = 2;

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 = 3;

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;

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,
  t3_.id AS id_19,
  t3_.filename AS filename_20,
  t3_.piste AS piste_21,
  t3_.title AS title_22,
  p0_.category AS category_23,
  p0_.category_id AS category_id_24,
  v1_.label_id AS label_id_25,
  t3_.vinyl_id AS vinyl_id_26
FROM
  vinyl v1_
  INNER JOIN product p0_ ON v1_.id = p0_.id
  LEFT JOIN vinyl_style v4_ ON v1_.id = v4_.vinyl_id
  LEFT JOIN style s2_ ON s2_.id = v4_.style_id
  LEFT JOIN track t3_ ON v1_.id = t3_.vinyl_id
WHERE
  p0_.promo > 0
ORDER BY
  p0_.updated_at 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, t3_.id AS id_19, t3_.filename AS filename_20, t3_.piste AS piste_21, t3_.title AS title_22, p0_.category AS category_23, p0_.category_id AS category_id_24, v1_.label_id AS label_id_25, t3_.vinyl_id AS vinyl_id_26 FROM vinyl v1_ INNER JOIN product p0_ ON v1_.id = p0_.id LEFT JOIN vinyl_style v4_ ON v1_.id = v4_.vinyl_id LEFT JOIN style s2_ ON s2_.id = v4_.style_id LEFT JOIN track t3_ ON v1_.id = t3_.vinyl_id WHERE p0_.promo > 0 ORDER BY p0_.updated_at DESC, s2_.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 = 6;

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
  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;

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
  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
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 = 75;

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;

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;

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;

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;