Symfony Profiler

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;

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,
  v1_.expected_arrival_date AS expected_arrival_date_16,
  v1_.pre_order_max_quantity AS pre_order_max_quantity_17,
  p0_.category AS category_18,
  p0_.category_id AS category_id_19,
  v1_.label_id AS label_id_20
FROM
  vinyl v1_
  INNER JOIN product p0_ ON v1_.id = p0_.id
WHERE
  v1_.state = ?
  AND NOT EXISTS (
    SELECT
      1
    FROM
      product_promote p2_
    WHERE
      p2_.product_id = v1_.id
      AND p2_.promote_id IN (?)
  )
ORDER BY
  p0_.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, v1_.expected_arrival_date AS expected_arrival_date_16, v1_.pre_order_max_quantity AS pre_order_max_quantity_17, p0_.category AS category_18, p0_.category_id AS category_id_19, v1_.label_id AS label_id_20 FROM vinyl v1_ INNER JOIN product p0_ ON v1_.id = p0_.id WHERE v1_.state = 'neuf' AND NOT EXISTS (SELECT 1 FROM product_promote p2_ WHERE p2_.product_id = v1_.id AND p2_.promote_id IN (7)) ORDER BY p0_.created_at DESC;

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.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,
  t0.slug AS slug_3
FROM
  style t0
  INNER JOIN vinyl_style ON t0.id = vinyl_style.style_id
WHERE
  vinyl_style.vinyl_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM style t0 INNER JOIN vinyl_style ON t0.id = vinyl_style.style_id WHERE vinyl_style.vinyl_id = 59 ORDER BY t0.name ASC;

SELECT
  COALESCE(
    SUM(v0_.quantity),
    0
  ) AS sclr_0
FROM
  vinyl_pre_order v0_
WHERE
  v0_.vinyl_id = ?
  AND v0_.status = ?

SELECT COALESCE(SUM(v0_.quantity), 0) AS sclr_0 FROM vinyl_pre_order v0_ WHERE v0_.vinyl_id = 59 AND v0_.status = 'fulfilled';

SELECT
  t0.id AS id_1,
  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 = 59;

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

SELECT
  COALESCE(
    SUM(v0_.quantity),
    0
  ) AS sclr_0
FROM
  vinyl_pre_order v0_
WHERE
  v0_.vinyl_id = ?
  AND v0_.status = ?

SELECT COALESCE(SUM(v0_.quantity), 0) AS sclr_0 FROM vinyl_pre_order v0_ WHERE v0_.vinyl_id = 59 AND v0_.status = 'fulfilled';

SELECT
  COALESCE(
    SUM(v0_.quantity),
    0
  ) AS sclr_0
FROM
  vinyl_pre_order v0_
WHERE
  v0_.vinyl_id = ?
  AND v0_.status = ?

SELECT COALESCE(SUM(v0_.quantity), 0) AS sclr_0 FROM vinyl_pre_order v0_ WHERE v0_.vinyl_id = 58 AND v0_.status = 'fulfilled';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  style t0
  INNER JOIN vinyl_style ON t0.id = vinyl_style.style_id
WHERE
  vinyl_style.vinyl_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM style t0 INNER JOIN vinyl_style ON t0.id = vinyl_style.style_id WHERE vinyl_style.vinyl_id = 58 ORDER BY t0.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 = 58;

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

SELECT
  COALESCE(
    SUM(v0_.quantity),
    0
  ) AS sclr_0
FROM
  vinyl_pre_order v0_
WHERE
  v0_.vinyl_id = ?
  AND v0_.status = ?

SELECT COALESCE(SUM(v0_.quantity), 0) AS sclr_0 FROM vinyl_pre_order v0_ WHERE v0_.vinyl_id = 58 AND v0_.status = 'fulfilled';

SELECT
  COALESCE(
    SUM(v0_.quantity),
    0
  ) AS sclr_0
FROM
  vinyl_pre_order v0_
WHERE
  v0_.vinyl_id = ?
  AND v0_.status = ?

SELECT COALESCE(SUM(v0_.quantity), 0) AS sclr_0 FROM vinyl_pre_order v0_ WHERE v0_.vinyl_id = 57 AND v0_.status = 'fulfilled';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  style t0
  INNER JOIN vinyl_style ON t0.id = vinyl_style.style_id
WHERE
  vinyl_style.vinyl_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM style t0 INNER JOIN vinyl_style ON t0.id = vinyl_style.style_id WHERE vinyl_style.vinyl_id = 57 ORDER BY t0.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 = 57;

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

SELECT
  COALESCE(
    SUM(v0_.quantity),
    0
  ) AS sclr_0
FROM
  vinyl_pre_order v0_
WHERE
  v0_.vinyl_id = ?
  AND v0_.status = ?

SELECT COALESCE(SUM(v0_.quantity), 0) AS sclr_0 FROM vinyl_pre_order v0_ WHERE v0_.vinyl_id = 57 AND v0_.status = 'fulfilled';

SELECT
  COALESCE(
    SUM(v0_.quantity),
    0
  ) AS sclr_0
FROM
  vinyl_pre_order v0_
WHERE
  v0_.vinyl_id = ?
  AND v0_.status = ?

SELECT COALESCE(SUM(v0_.quantity), 0) AS sclr_0 FROM vinyl_pre_order v0_ WHERE v0_.vinyl_id = 56 AND v0_.status = 'fulfilled';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  style t0
  INNER JOIN vinyl_style ON t0.id = vinyl_style.style_id
WHERE
  vinyl_style.vinyl_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM style t0 INNER JOIN vinyl_style ON t0.id = vinyl_style.style_id WHERE vinyl_style.vinyl_id = 56 ORDER BY t0.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 = 56;

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

SELECT
  COALESCE(
    SUM(v0_.quantity),
    0
  ) AS sclr_0
FROM
  vinyl_pre_order v0_
WHERE
  v0_.vinyl_id = ?
  AND v0_.status = ?

SELECT COALESCE(SUM(v0_.quantity), 0) AS sclr_0 FROM vinyl_pre_order v0_ WHERE v0_.vinyl_id = 56 AND v0_.status = 'fulfilled';

SELECT
  COALESCE(
    SUM(v0_.quantity),
    0
  ) AS sclr_0
FROM
  vinyl_pre_order v0_
WHERE
  v0_.vinyl_id = ?
  AND v0_.status = ?

SELECT COALESCE(SUM(v0_.quantity), 0) AS sclr_0 FROM vinyl_pre_order v0_ WHERE v0_.vinyl_id = 55 AND v0_.status = 'fulfilled';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  style t0
  INNER JOIN vinyl_style ON t0.id = vinyl_style.style_id
WHERE
  vinyl_style.vinyl_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM style t0 INNER JOIN vinyl_style ON t0.id = vinyl_style.style_id WHERE vinyl_style.vinyl_id = 55 ORDER BY t0.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 = 55;

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

SELECT
  COALESCE(
    SUM(v0_.quantity),
    0
  ) AS sclr_0
FROM
  vinyl_pre_order v0_
WHERE
  v0_.vinyl_id = ?
  AND v0_.status = ?

SELECT COALESCE(SUM(v0_.quantity), 0) AS sclr_0 FROM vinyl_pre_order v0_ WHERE v0_.vinyl_id = 55 AND v0_.status = 'fulfilled';

SELECT
  COALESCE(
    SUM(v0_.quantity),
    0
  ) AS sclr_0
FROM
  vinyl_pre_order v0_
WHERE
  v0_.vinyl_id = ?
  AND v0_.status = ?

SELECT COALESCE(SUM(v0_.quantity), 0) AS sclr_0 FROM vinyl_pre_order v0_ WHERE v0_.vinyl_id = 54 AND v0_.status = 'fulfilled';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  style t0
  INNER JOIN vinyl_style ON t0.id = vinyl_style.style_id
WHERE
  vinyl_style.vinyl_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM style t0 INNER JOIN vinyl_style ON t0.id = vinyl_style.style_id WHERE vinyl_style.vinyl_id = 54 ORDER BY t0.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 = 54;

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

SELECT
  COALESCE(
    SUM(v0_.quantity),
    0
  ) AS sclr_0
FROM
  vinyl_pre_order v0_
WHERE
  v0_.vinyl_id = ?
  AND v0_.status = ?

SELECT COALESCE(SUM(v0_.quantity), 0) AS sclr_0 FROM vinyl_pre_order v0_ WHERE v0_.vinyl_id = 54 AND v0_.status = 'fulfilled';

SELECT
  COALESCE(
    SUM(v0_.quantity),
    0
  ) AS sclr_0
FROM
  vinyl_pre_order v0_
WHERE
  v0_.vinyl_id = ?
  AND v0_.status = ?

SELECT COALESCE(SUM(v0_.quantity), 0) AS sclr_0 FROM vinyl_pre_order v0_ WHERE v0_.vinyl_id = 53 AND v0_.status = 'fulfilled';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  style t0
  INNER JOIN vinyl_style ON t0.id = vinyl_style.style_id
WHERE
  vinyl_style.vinyl_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM style t0 INNER JOIN vinyl_style ON t0.id = vinyl_style.style_id WHERE vinyl_style.vinyl_id = 53 ORDER BY t0.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 = 53;

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

SELECT
  COALESCE(
    SUM(v0_.quantity),
    0
  ) AS sclr_0
FROM
  vinyl_pre_order v0_
WHERE
  v0_.vinyl_id = ?
  AND v0_.status = ?

SELECT COALESCE(SUM(v0_.quantity), 0) AS sclr_0 FROM vinyl_pre_order v0_ WHERE v0_.vinyl_id = 53 AND v0_.status = 'fulfilled';

SELECT
  COALESCE(
    SUM(v0_.quantity),
    0
  ) AS sclr_0
FROM
  vinyl_pre_order v0_
WHERE
  v0_.vinyl_id = ?
  AND v0_.status = ?

SELECT COALESCE(SUM(v0_.quantity), 0) AS sclr_0 FROM vinyl_pre_order v0_ WHERE v0_.vinyl_id = 52 AND v0_.status = 'fulfilled';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  style t0
  INNER JOIN vinyl_style ON t0.id = vinyl_style.style_id
WHERE
  vinyl_style.vinyl_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM style t0 INNER JOIN vinyl_style ON t0.id = vinyl_style.style_id WHERE vinyl_style.vinyl_id = 52 ORDER BY t0.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 = 52;

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

SELECT
  COALESCE(
    SUM(v0_.quantity),
    0
  ) AS sclr_0
FROM
  vinyl_pre_order v0_
WHERE
  v0_.vinyl_id = ?
  AND v0_.status = ?

SELECT COALESCE(SUM(v0_.quantity), 0) AS sclr_0 FROM vinyl_pre_order v0_ WHERE v0_.vinyl_id = 52 AND v0_.status = 'fulfilled';

SELECT
  COALESCE(
    SUM(v0_.quantity),
    0
  ) AS sclr_0
FROM
  vinyl_pre_order v0_
WHERE
  v0_.vinyl_id = ?
  AND v0_.status = ?

SELECT COALESCE(SUM(v0_.quantity), 0) AS sclr_0 FROM vinyl_pre_order v0_ WHERE v0_.vinyl_id = 51 AND v0_.status = 'fulfilled';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  style t0
  INNER JOIN vinyl_style ON t0.id = vinyl_style.style_id
WHERE
  vinyl_style.vinyl_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM style t0 INNER JOIN vinyl_style ON t0.id = vinyl_style.style_id WHERE vinyl_style.vinyl_id = 51 ORDER BY t0.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 = 51;

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

SELECT
  COALESCE(
    SUM(v0_.quantity),
    0
  ) AS sclr_0
FROM
  vinyl_pre_order v0_
WHERE
  v0_.vinyl_id = ?
  AND v0_.status = ?

SELECT COALESCE(SUM(v0_.quantity), 0) AS sclr_0 FROM vinyl_pre_order v0_ WHERE v0_.vinyl_id = 51 AND v0_.status = 'fulfilled';

SELECT
  COALESCE(
    SUM(v0_.quantity),
    0
  ) AS sclr_0
FROM
  vinyl_pre_order v0_
WHERE
  v0_.vinyl_id = ?
  AND v0_.status = ?

SELECT COALESCE(SUM(v0_.quantity), 0) AS sclr_0 FROM vinyl_pre_order v0_ WHERE v0_.vinyl_id = 50 AND v0_.status = 'fulfilled';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  style t0
  INNER JOIN vinyl_style ON t0.id = vinyl_style.style_id
WHERE
  vinyl_style.vinyl_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM style t0 INNER JOIN vinyl_style ON t0.id = vinyl_style.style_id WHERE vinyl_style.vinyl_id = 50 ORDER BY t0.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 = 50;

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

SELECT
  COALESCE(
    SUM(v0_.quantity),
    0
  ) AS sclr_0
FROM
  vinyl_pre_order v0_
WHERE
  v0_.vinyl_id = ?
  AND v0_.status = ?

SELECT COALESCE(SUM(v0_.quantity), 0) AS sclr_0 FROM vinyl_pre_order v0_ WHERE v0_.vinyl_id = 50 AND v0_.status = 'fulfilled';

SELECT
  COALESCE(
    SUM(v0_.quantity),
    0
  ) AS sclr_0
FROM
  vinyl_pre_order v0_
WHERE
  v0_.vinyl_id = ?
  AND v0_.status = ?

SELECT COALESCE(SUM(v0_.quantity), 0) AS sclr_0 FROM vinyl_pre_order v0_ WHERE v0_.vinyl_id = 49 AND v0_.status = 'fulfilled';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  style t0
  INNER JOIN vinyl_style ON t0.id = vinyl_style.style_id
WHERE
  vinyl_style.vinyl_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM style t0 INNER JOIN vinyl_style ON t0.id = vinyl_style.style_id WHERE vinyl_style.vinyl_id = 49 ORDER BY t0.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 = 49;

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 = ?