Symfony Profiler

SELECT
  c0_.code AS code_0,
  c0_.name AS name_1,
  c0_.rate AS rate_2,
  c0_.created_at AS created_at_3,
  c0_.updated_at AS updated_at_4,
  c0_.synced_at AS synced_at_5,
  c0_.index_at AS index_at_6
FROM
  currency c0_
WHERE
  c0_.code = ?

SELECT c0_.code AS code_0, c0_.name AS name_1, c0_.rate AS rate_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.synced_at AS synced_at_5, c0_.index_at AS index_at_6 FROM currency c0_ WHERE c0_.code = 'RSD';

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.sorting_priority AS sorting_priority_2,
  p0_.created_at AS created_at_3,
  p0_.updated_at AS updated_at_4,
  p0_.synced_at AS synced_at_5,
  p0_.index_at AS index_at_6,
  p0_.remote_id AS remote_id_7
FROM
  product_manufacturer p0_
WHERE
  EXISTS (
    SELECT
      1 AS sclr_8
    FROM
      product p1_
    WHERE
      p1_.manufacturer = p0_.id
  )

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.sorting_priority AS sorting_priority_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.synced_at AS synced_at_5, p0_.index_at AS index_at_6, p0_.remote_id AS remote_id_7 FROM product_manufacturer p0_ WHERE EXISTS (SELECT 1 AS sclr_8 FROM product p1_ WHERE p1_.manufacturer = p0_.id);

SELECT
  p0_.id AS id_0,
  p0_.remote_id AS remote_id_1,
  p0_.created_at AS created_at_2,
  p0_.updated_at AS updated_at_3,
  p0_.synced_at AS synced_at_4,
  p0_.index_at AS index_at_5
FROM
  product_category p0_
  INNER JOIN product_category_translation p1_ ON p0_.id = p1_.translatable_id
  AND (p1_.locale = ?)
WHERE
  EXISTS (
    SELECT
      1 AS sclr_6
    FROM
      product p2_
    WHERE
      p2_.sub_category = p0_.id
  )

SELECT p0_.id AS id_0, p0_.remote_id AS remote_id_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.synced_at AS synced_at_4, p0_.index_at AS index_at_5 FROM product_category p0_ INNER JOIN product_category_translation p1_ ON p0_.id = p1_.translatable_id AND (p1_.locale = 'ba') WHERE EXISTS (SELECT 1 AS sclr_6 FROM product p2_ WHERE p2_.sub_category = p0_.id);

SELECT
  p0_.id AS id_0,
  p0_.remote_id AS remote_id_1,
  p0_.created_at AS created_at_2,
  p0_.updated_at AS updated_at_3,
  p0_.synced_at AS synced_at_4,
  p0_.index_at AS index_at_5
FROM
  product_category p0_
  INNER JOIN product_category_translation p1_ ON p0_.id = p1_.translatable_id
  AND (p1_.locale = ?)
WHERE
  EXISTS (
    SELECT
      1 AS sclr_6
    FROM
      product p2_
    WHERE
      p2_.sub_category = p0_.id
  )

SELECT p0_.id AS id_0, p0_.remote_id AS remote_id_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.synced_at AS synced_at_4, p0_.index_at AS index_at_5 FROM product_category p0_ INNER JOIN product_category_translation p1_ ON p0_.id = p1_.translatable_id AND (p1_.locale = 'ba') WHERE EXISTS (SELECT 1 AS sclr_6 FROM product p2_ WHERE p2_.sub_category = p0_.id);

SELECT
  p0_.id AS id_0,
  p0_.remote_id AS remote_id_1,
  p0_.code AS code_2,
  p0_.name AS name_3,
  p0_.created_at AS created_at_4,
  p0_.updated_at AS updated_at_5,
  p0_.synced_at AS synced_at_6,
  p0_.index_at AS index_at_7,
  p0_.product_category AS product_category_8
FROM
  product_sub_category p0_
WHERE
  EXISTS (
    SELECT
      1 AS sclr_9
    FROM
      product p1_
    WHERE
      p1_.sub_category = p0_.id
  )

SELECT p0_.id AS id_0, p0_.remote_id AS remote_id_1, p0_.code AS code_2, p0_.name AS name_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.synced_at AS synced_at_6, p0_.index_at AS index_at_7, p0_.product_category AS product_category_8 FROM product_sub_category p0_ WHERE EXISTS (SELECT 1 AS sclr_9 FROM product p1_ WHERE p1_.sub_category = p0_.id);

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.sorting_priority AS sorting_priority_2,
  p0_.created_at AS created_at_3,
  p0_.updated_at AS updated_at_4,
  p0_.synced_at AS synced_at_5,
  p0_.index_at AS index_at_6,
  p0_.remote_id AS remote_id_7
FROM
  product_manufacturer p0_
WHERE
  EXISTS (
    SELECT
      p1_.id
    FROM
      product p1_
    WHERE
      (
        p1_.disabled IS NULL
        OR p1_.disabled = false
      )
      AND (
        EXISTS (
          SELECT
            1 AS sclr_8
          FROM
            depot_product d2_
          WHERE
            d2_.product = p1_.id
            AND d2_.quantity > 0
        )
      )
      AND p1_.category IN (?)
      AND p1_.manufacturer = p0_.id
  )

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.sorting_priority AS sorting_priority_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.synced_at AS synced_at_5, p0_.index_at AS index_at_6, p0_.remote_id AS remote_id_7 FROM product_manufacturer p0_ WHERE EXISTS (SELECT p1_.id FROM product p1_ WHERE (p1_.disabled IS NULL OR p1_.disabled = false) AND (EXISTS (SELECT 1 AS sclr_8 FROM depot_product d2_ WHERE d2_.product = p1_.id AND d2_.quantity > 0)) AND p1_.category IN ('6') AND p1_.manufacturer = p0_.id);

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.country AS country_2,
  d0_.colors AS colors_3,
  d0_.deliver_at AS deliver_at_4,
  d0_.created_at AS created_at_5,
  d0_.updated_at AS updated_at_6,
  d0_.synced_at AS synced_at_7,
  d0_.index_at AS index_at_8,
  d0_.currency AS currency_9
FROM
  depot d0_
ORDER BY
  d0_.id ASC
LIMIT
  1

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.country AS country_2, d0_.colors AS colors_3, d0_.deliver_at AS deliver_at_4, d0_.created_at AS created_at_5, d0_.updated_at AS updated_at_6, d0_.synced_at AS synced_at_7, d0_.index_at AS index_at_8, d0_.currency AS currency_9 FROM depot d0_ ORDER BY d0_.id ASC LIMIT 1;

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  product p0_
  LEFT JOIN depot_product d1_ ON p0_.id = d1_.product
  LEFT JOIN depot d2_ ON d1_.depot = d2_.id
WHERE
  (
    p0_.disabled IS NULL
    OR p0_.disabled = false
  )
  AND (
    EXISTS (
      SELECT
        1 AS sclr_1
      FROM
        depot_product d3_
      WHERE
        d3_.product = p0_.id
        AND d3_.quantity > 0
        AND d3_.price > 0
    )
  )

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN depot_product d1_ ON p0_.id = d1_.product LEFT JOIN depot d2_ ON d1_.depot = d2_.id WHERE (p0_.disabled IS NULL OR p0_.disabled = false) AND (EXISTS (SELECT 1 AS sclr_1 FROM depot_product d3_ WHERE d3_.product = p0_.id AND d3_.quantity > 0 AND d3_.price > 0));

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.file_name AS file_name_3,
  t0.tries AS tries_4,
  t0.error AS error_5,
  t0.original AS original_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.synced_at AS synced_at_9,
  t0.index_at AS index_at_10,
  t0.product AS product_11
FROM
  product_photo t0
WHERE
  t0.product IN (?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.title AS title_2, t0.file_name AS file_name_3, t0.tries AS tries_4, t0.error AS error_5, t0.original AS original_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.synced_at AS synced_at_9, t0.index_at AS index_at_10, t0.product AS product_11 FROM product_photo t0 WHERE t0.product IN (2048, 1904, 1896, 1699, 2103, 2354);

SELECT
  MAX(d0_.price * ?) AS sclr_0
FROM
  product p1_
  LEFT JOIN depot_product d0_ ON p1_.id = d0_.product
WHERE
  d0_.quantity > 0

SELECT MAX(d0_.price * 120.0000000048) AS sclr_0 FROM product p1_ LEFT JOIN depot_product d0_ ON p1_.id = d0_.product WHERE d0_.quantity > 0;

SELECT
  MAX(d0_.price * ?) AS sclr_0
FROM
  product p1_
  LEFT JOIN depot_product d0_ ON p1_.id = d0_.product
WHERE
  d0_.quantity > 0

SELECT MAX(d0_.price * 120.0000000048) AS sclr_0 FROM product p1_ LEFT JOIN depot_product d0_ ON p1_.id = d0_.product WHERE d0_.quantity > 0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.synced_at AS synced_at_5,
  t0.index_at AS index_at_6,
  t0.locale AS locale_7,
  t0.translatable_id AS translatable_id_8
FROM
  product_category_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.synced_at AS synced_at_5, t0.index_at AS index_at_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM product_category_translation t0 WHERE t0.translatable_id = 19;

SELECT
  t0.id AS id_1,
  t0.remote_id AS remote_id_2,
  t0.title AS title_3,
  t0.search_title AS search_title_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.synced_at AS synced_at_7,
  t0.index_at AS index_at_8,
  t0.product AS product_9
FROM
  product_alternative t0
WHERE
  t0.product = ?
ORDER BY
  t0.title ASC

SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.title AS title_3, t0.search_title AS search_title_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.synced_at AS synced_at_7, t0.index_at AS index_at_8, t0.product AS product_9 FROM product_alternative t0 WHERE t0.product = 2048 ORDER BY t0.title ASC;

SELECT
  t0.id AS id_1,
  t0.remote_id AS remote_id_2,
  t0.title AS title_3,
  t0.search_title AS search_title_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.synced_at AS synced_at_7,
  t0.index_at AS index_at_8,
  t0.product AS product_9
FROM
  product_alternative t0
WHERE
  t0.product = ?
ORDER BY
  t0.title ASC

SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.title AS title_3, t0.search_title AS search_title_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.synced_at AS synced_at_7, t0.index_at AS index_at_8, t0.product AS product_9 FROM product_alternative t0 WHERE t0.product = 1904 ORDER BY t0.title ASC;

SELECT
  t0.id AS id_1,
  t0.remote_id AS remote_id_2,
  t0.title AS title_3,
  t0.search_title AS search_title_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.synced_at AS synced_at_7,
  t0.index_at AS index_at_8,
  t0.product AS product_9
FROM
  product_alternative t0
WHERE
  t0.product = ?
ORDER BY
  t0.title ASC

SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.title AS title_3, t0.search_title AS search_title_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.synced_at AS synced_at_7, t0.index_at AS index_at_8, t0.product AS product_9 FROM product_alternative t0 WHERE t0.product = 1896 ORDER BY t0.title ASC;

SELECT
  t0.id AS id_1,
  t0.remote_id AS remote_id_2,
  t0.title AS title_3,
  t0.search_title AS search_title_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.synced_at AS synced_at_7,
  t0.index_at AS index_at_8,
  t0.product AS product_9
FROM
  product_alternative t0
WHERE
  t0.product = ?
ORDER BY
  t0.title ASC

SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.title AS title_3, t0.search_title AS search_title_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.synced_at AS synced_at_7, t0.index_at AS index_at_8, t0.product AS product_9 FROM product_alternative t0 WHERE t0.product = 1699 ORDER BY t0.title ASC;

SELECT
  t0.id AS id_1,
  t0.remote_id AS remote_id_2,
  t0.title AS title_3,
  t0.search_title AS search_title_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.synced_at AS synced_at_7,
  t0.index_at AS index_at_8,
  t0.product AS product_9
FROM
  product_alternative t0
WHERE
  t0.product = ?
ORDER BY
  t0.title ASC

SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.title AS title_3, t0.search_title AS search_title_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.synced_at AS synced_at_7, t0.index_at AS index_at_8, t0.product AS product_9 FROM product_alternative t0 WHERE t0.product = 2103 ORDER BY t0.title ASC;

SELECT
  t0.id AS id_1,
  t0.remote_id AS remote_id_2,
  t0.title AS title_3,
  t0.search_title AS search_title_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.synced_at AS synced_at_7,
  t0.index_at AS index_at_8,
  t0.product AS product_9
FROM
  product_alternative t0
WHERE
  t0.product = ?
ORDER BY
  t0.title ASC

SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.title AS title_3, t0.search_title AS search_title_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.synced_at AS synced_at_7, t0.index_at AS index_at_8, t0.product AS product_9 FROM product_alternative t0 WHERE t0.product = 2354 ORDER BY t0.title ASC;