Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.visible AS visible_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.position AS position_6,
  t0.depth AS depth_7,
  t0.sort_path AS sort_path_8,
  t0.parent_id AS parent_id_9
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.visible AS visible_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.position AS position_6, t0.depth AS depth_7, t0.sort_path AS sort_path_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.id = '4';

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.visible AS visible_4,
  t0.position AS position_5,
  t0.depth AS depth_6,
  t0.sort_path AS sort_path_7,
  t0.parent_id AS parent_id_8
FROM
  attribute t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.visible AS visible_4, t0.position AS position_5, t0.depth AS depth_6, t0.sort_path AS sort_path_7, t0.parent_id AS parent_id_8 FROM attribute t0 WHERE t0.code = 'page' LIMIT 1;

SELECT
  p0_.id AS id_0
FROM
  product_variant p0_
WHERE
  p0_.product_id = ?

SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = NULL;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      p0_.id AS id_0,
      p0_.remote_id AS remote_id_1,
      p0_.name AS name_2,
      p0_.title AS title_3,
      p0_.specification AS specification_4,
      p0_.description AS description_5,
      p0_.visible AS visible_6
    FROM
      product p0_
      INNER JOIN remote_category r1_ ON p0_.remote_category_id = r1_.id
      INNER JOIN product_variant p2_ ON p0_.id = p2_.product_id
    WHERE
      r1_.category_id = ?
      AND p0_.visible = true
      AND p2_.visible = true
    GROUP BY
      p0_.id
  ) dctrn_result
LIMIT
  9

SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.remote_id AS remote_id_1, p0_.name AS name_2, p0_.title AS title_3, p0_.specification AS specification_4, p0_.description AS description_5, p0_.visible AS visible_6 FROM product p0_ INNER JOIN remote_category r1_ ON p0_.remote_category_id = r1_.id INNER JOIN product_variant p2_ ON p0_.id = p2_.product_id WHERE r1_.category_id = 4 AND p0_.visible = true AND p2_.visible = true GROUP BY p0_.id) dctrn_result LIMIT 9;

SELECT
  p0_.id AS id_0,
  p0_.remote_id AS remote_id_1,
  p0_.name AS name_2,
  p0_.title AS title_3,
  p0_.specification AS specification_4,
  p0_.description AS description_5,
  p0_.visible AS visible_6,
  p0_.source_id AS source_id_7,
  p0_.manufacturer_id AS manufacturer_id_8,
  p0_.remote_category_id AS remote_category_id_9
FROM
  product p0_
  INNER JOIN remote_category r1_ ON p0_.remote_category_id = r1_.id
  INNER JOIN product_variant p2_ ON p0_.id = p2_.product_id
WHERE
  r1_.category_id = ?
  AND p0_.visible = true
  AND p2_.visible = true
  AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
GROUP BY
  p0_.id

SELECT p0_.id AS id_0, p0_.remote_id AS remote_id_1, p0_.name AS name_2, p0_.title AS title_3, p0_.specification AS specification_4, p0_.description AS description_5, p0_.visible AS visible_6, p0_.source_id AS source_id_7, p0_.manufacturer_id AS manufacturer_id_8, p0_.remote_category_id AS remote_category_id_9 FROM product p0_ INNER JOIN remote_category r1_ ON p0_.remote_category_id = r1_.id INNER JOIN product_variant p2_ ON p0_.id = p2_.product_id WHERE r1_.category_id = 4 AND p0_.visible = true AND p2_.visible = true AND p0_.id IN (96, 396, 105, 101, 102, 97, 108, 109, 98) GROUP BY p0_.id;

SELECT
  p0_.id AS id_0
FROM
  product_variant p0_
WHERE
  p0_.product_id = ?

SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = 96;

SELECT
  i0_.id AS id_0,
  i0_.url AS url_1,
  i0_.path AS path_2,
  i0_.filename AS filename_3,
  i0_.hash AS hash_4
FROM
  image i0_
  INNER JOIN product_variant_image p1_ ON i0_.id = p1_.image_id
  INNER JOIN product_variant p2_ ON p1_.variant_id = p2_.id
  INNER JOIN product p3_ ON p2_.product_id = p3_.id
WHERE
  p3_.id = ?
  AND p3_.visible = true
  AND p2_.visible = true
  AND p2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
GROUP BY
  i0_.id,
  i0_.url,
  i0_.path,
  i0_.filename,
  i0_.hash
ORDER BY
  i0_.path ASC
LIMIT
  1

SELECT i0_.id AS id_0, i0_.url AS url_1, i0_.path AS path_2, i0_.filename AS filename_3, i0_.hash AS hash_4 FROM image i0_ INNER JOIN product_variant_image p1_ ON i0_.id = p1_.image_id INNER JOIN product_variant p2_ ON p1_.variant_id = p2_.id INNER JOIN product p3_ ON p2_.product_id = p3_.id WHERE p3_.id = 96 AND p3_.visible = true AND p2_.visible = true AND p2_.id IN (5537, 5538, 5539, 5540, 5541, 5542, 5543, 5544, 5545, 5546, 5547, 5548) GROUP BY i0_.id, i0_.url, i0_.path, i0_.filename, i0_.hash ORDER BY i0_.path ASC LIMIT 1;

SELECT
  p0_.id AS id_0
FROM
  product_variant p0_
WHERE
  p0_.product_id = ?

SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = 96;

SELECT
  MIN(p0_.price) AS sclr_0,
  MAX(p0_.price) AS sclr_1
FROM
  product_variant p0_
  INNER JOIN product p1_ ON p0_.product_id = p1_.id
WHERE
  p1_.id = ?
  AND p1_.visible = true
  AND p0_.visible = true
  AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT MIN(p0_.price) AS sclr_0, MAX(p0_.price) AS sclr_1 FROM product_variant p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id WHERE p1_.id = 96 AND p1_.visible = true AND p0_.visible = true AND p0_.id IN (5537, 5538, 5539, 5540, 5541, 5542, 5543, 5544, 5545, 5546, 5547, 5548);

SELECT
  p0_.id AS id_0
FROM
  product_variant p0_
WHERE
  p0_.product_id = ?

SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = 97;

SELECT
  i0_.id AS id_0,
  i0_.url AS url_1,
  i0_.path AS path_2,
  i0_.filename AS filename_3,
  i0_.hash AS hash_4
FROM
  image i0_
  INNER JOIN product_variant_image p1_ ON i0_.id = p1_.image_id
  INNER JOIN product_variant p2_ ON p1_.variant_id = p2_.id
  INNER JOIN product p3_ ON p2_.product_id = p3_.id
WHERE
  p3_.id = ?
  AND p3_.visible = true
  AND p2_.visible = true
  AND p2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
GROUP BY
  i0_.id,
  i0_.url,
  i0_.path,
  i0_.filename,
  i0_.hash
ORDER BY
  i0_.path ASC
LIMIT
  1

SELECT i0_.id AS id_0, i0_.url AS url_1, i0_.path AS path_2, i0_.filename AS filename_3, i0_.hash AS hash_4 FROM image i0_ INNER JOIN product_variant_image p1_ ON i0_.id = p1_.image_id INNER JOIN product_variant p2_ ON p1_.variant_id = p2_.id INNER JOIN product p3_ ON p2_.product_id = p3_.id WHERE p3_.id = 97 AND p3_.visible = true AND p2_.visible = true AND p2_.id IN (5549, 5550, 5551, 5552, 5553, 5554, 5555, 5556, 5557, 5558, 5559, 5560) GROUP BY i0_.id, i0_.url, i0_.path, i0_.filename, i0_.hash ORDER BY i0_.path ASC LIMIT 1;

SELECT
  p0_.id AS id_0
FROM
  product_variant p0_
WHERE
  p0_.product_id = ?

SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = 97;

SELECT
  MIN(p0_.price) AS sclr_0,
  MAX(p0_.price) AS sclr_1
FROM
  product_variant p0_
  INNER JOIN product p1_ ON p0_.product_id = p1_.id
WHERE
  p1_.id = ?
  AND p1_.visible = true
  AND p0_.visible = true
  AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT MIN(p0_.price) AS sclr_0, MAX(p0_.price) AS sclr_1 FROM product_variant p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id WHERE p1_.id = 97 AND p1_.visible = true AND p0_.visible = true AND p0_.id IN (5549, 5550, 5551, 5552, 5553, 5554, 5555, 5556, 5557, 5558, 5559, 5560);

SELECT
  p0_.id AS id_0
FROM
  product_variant p0_
WHERE
  p0_.product_id = ?

SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = 98;

SELECT
  i0_.id AS id_0,
  i0_.url AS url_1,
  i0_.path AS path_2,
  i0_.filename AS filename_3,
  i0_.hash AS hash_4
FROM
  image i0_
  INNER JOIN product_variant_image p1_ ON i0_.id = p1_.image_id
  INNER JOIN product_variant p2_ ON p1_.variant_id = p2_.id
  INNER JOIN product p3_ ON p2_.product_id = p3_.id
WHERE
  p3_.id = ?
  AND p3_.visible = true
  AND p2_.visible = true
  AND p2_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
GROUP BY
  i0_.id,
  i0_.url,
  i0_.path,
  i0_.filename,
  i0_.hash
ORDER BY
  i0_.path ASC
LIMIT
  1

SELECT i0_.id AS id_0, i0_.url AS url_1, i0_.path AS path_2, i0_.filename AS filename_3, i0_.hash AS hash_4 FROM image i0_ INNER JOIN product_variant_image p1_ ON i0_.id = p1_.image_id INNER JOIN product_variant p2_ ON p1_.variant_id = p2_.id INNER JOIN product p3_ ON p2_.product_id = p3_.id WHERE p3_.id = 98 AND p3_.visible = true AND p2_.visible = true AND p2_.id IN (5561, 5562, 5563, 5564, 5565, 5566, 5567, 5568) GROUP BY i0_.id, i0_.url, i0_.path, i0_.filename, i0_.hash ORDER BY i0_.path ASC LIMIT 1;

SELECT
  p0_.id AS id_0
FROM
  product_variant p0_
WHERE
  p0_.product_id = ?

SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = 98;

SELECT
  MIN(p0_.price) AS sclr_0,
  MAX(p0_.price) AS sclr_1
FROM
  product_variant p0_
  INNER JOIN product p1_ ON p0_.product_id = p1_.id
WHERE
  p1_.id = ?
  AND p1_.visible = true
  AND p0_.visible = true
  AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)

SELECT MIN(p0_.price) AS sclr_0, MAX(p0_.price) AS sclr_1 FROM product_variant p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id WHERE p1_.id = 98 AND p1_.visible = true AND p0_.visible = true AND p0_.id IN (5561, 5562, 5563, 5564, 5565, 5566, 5567, 5568);

SELECT
  p0_.id AS id_0
FROM
  product_variant p0_
WHERE
  p0_.product_id = ?

SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = 101;

SELECT
  i0_.id AS id_0,
  i0_.url AS url_1,
  i0_.path AS path_2,
  i0_.filename AS filename_3,
  i0_.hash AS hash_4
FROM
  image i0_
  INNER JOIN product_variant_image p1_ ON i0_.id = p1_.image_id
  INNER JOIN product_variant p2_ ON p1_.variant_id = p2_.id
  INNER JOIN product p3_ ON p2_.product_id = p3_.id
WHERE
  p3_.id = ?
  AND p3_.visible = true
  AND p2_.visible = true
  AND p2_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )
GROUP BY
  i0_.id,
  i0_.url,
  i0_.path,
  i0_.filename,
  i0_.hash
ORDER BY
  i0_.path ASC
LIMIT
  1

SELECT i0_.id AS id_0, i0_.url AS url_1, i0_.path AS path_2, i0_.filename AS filename_3, i0_.hash AS hash_4 FROM image i0_ INNER JOIN product_variant_image p1_ ON i0_.id = p1_.image_id INNER JOIN product_variant p2_ ON p1_.variant_id = p2_.id INNER JOIN product p3_ ON p2_.product_id = p3_.id WHERE p3_.id = 101 AND p3_.visible = true AND p2_.visible = true AND p2_.id IN (5599, 5600, 5601, 5602, 5603, 5604, 5605, 5606, 5607, 10162, 10163, 10164, 10165, 10166, 10167, 14823, 14943) GROUP BY i0_.id, i0_.url, i0_.path, i0_.filename, i0_.hash ORDER BY i0_.path ASC LIMIT 1;

SELECT
  p0_.id AS id_0
FROM
  product_variant p0_
WHERE
  p0_.product_id = ?

SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = 101;

SELECT
  MIN(p0_.price) AS sclr_0,
  MAX(p0_.price) AS sclr_1
FROM
  product_variant p0_
  INNER JOIN product p1_ ON p0_.product_id = p1_.id
WHERE
  p1_.id = ?
  AND p1_.visible = true
  AND p0_.visible = true
  AND p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )

SELECT MIN(p0_.price) AS sclr_0, MAX(p0_.price) AS sclr_1 FROM product_variant p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id WHERE p1_.id = 101 AND p1_.visible = true AND p0_.visible = true AND p0_.id IN (5599, 5600, 5601, 5602, 5603, 5604, 5605, 5606, 5607, 10162, 10163, 10164, 10165, 10166, 10167, 14823, 14943);

SELECT
  p0_.id AS id_0
FROM
  product_variant p0_
WHERE
  p0_.product_id = ?

SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = 102;

SELECT
  i0_.id AS id_0,
  i0_.url AS url_1,
  i0_.path AS path_2,
  i0_.filename AS filename_3,
  i0_.hash AS hash_4
FROM
  image i0_
  INNER JOIN product_variant_image p1_ ON i0_.id = p1_.image_id
  INNER JOIN product_variant p2_ ON p1_.variant_id = p2_.id
  INNER JOIN product p3_ ON p2_.product_id = p3_.id
WHERE
  p3_.id = ?
  AND p3_.visible = true
  AND p2_.visible = true
  AND p2_.id IN (?, ?, ?, ?, ?, ?)
GROUP BY
  i0_.id,
  i0_.url,
  i0_.path,
  i0_.filename,
  i0_.hash
ORDER BY
  i0_.path ASC
LIMIT
  1

SELECT i0_.id AS id_0, i0_.url AS url_1, i0_.path AS path_2, i0_.filename AS filename_3, i0_.hash AS hash_4 FROM image i0_ INNER JOIN product_variant_image p1_ ON i0_.id = p1_.image_id INNER JOIN product_variant p2_ ON p1_.variant_id = p2_.id INNER JOIN product p3_ ON p2_.product_id = p3_.id WHERE p3_.id = 102 AND p3_.visible = true AND p2_.visible = true AND p2_.id IN (5608, 5609, 5610, 5611, 5612, 5613) GROUP BY i0_.id, i0_.url, i0_.path, i0_.filename, i0_.hash ORDER BY i0_.path ASC LIMIT 1;

SELECT
  p0_.id AS id_0
FROM
  product_variant p0_
WHERE
  p0_.product_id = ?

SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = 102;

SELECT
  MIN(p0_.price) AS sclr_0,
  MAX(p0_.price) AS sclr_1
FROM
  product_variant p0_
  INNER JOIN product p1_ ON p0_.product_id = p1_.id
WHERE
  p1_.id = ?
  AND p1_.visible = true
  AND p0_.visible = true
  AND p0_.id IN (?, ?, ?, ?, ?, ?)

SELECT MIN(p0_.price) AS sclr_0, MAX(p0_.price) AS sclr_1 FROM product_variant p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id WHERE p1_.id = 102 AND p1_.visible = true AND p0_.visible = true AND p0_.id IN (5608, 5609, 5610, 5611, 5612, 5613);

SELECT
  p0_.id AS id_0
FROM
  product_variant p0_
WHERE
  p0_.product_id = ?