Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.remote_id AS remote_id_2,
  t0.name AS name_3,
  t0.title AS title_4,
  t0.specification AS specification_5,
  t0.description AS description_6,
  t0.visible AS visible_7,
  t0.source_id AS source_id_8,
  t0.manufacturer_id AS manufacturer_id_9,
  t0.remote_category_id AS remote_category_id_10
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.name AS name_3, t0.title AS title_4, t0.specification AS specification_5, t0.description AS description_6, t0.visible AS visible_7, t0.source_id AS source_id_8, t0.manufacturer_id AS manufacturer_id_9, t0.remote_category_id AS remote_category_id_10 FROM product t0 WHERE t0.id = '304';

SELECT
  a0_.id AS id_0,
  a0_.code AS code_1,
  a0_.name AS name_2,
  a0_.visible AS visible_3,
  a0_.position AS position_4,
  a0_.depth AS depth_5,
  a0_.sort_path AS sort_path_6,
  a0_.parent_id AS parent_id_7
FROM
  attribute a0_
  INNER JOIN attribute_value a1_ ON a0_.id = a1_.attribute_id
  INNER JOIN product_variant_attribute_value p2_ ON a1_.id = p2_.attribute_value_id
  INNER JOIN product_variant p3_ ON p2_.variant_id = p3_.id
  INNER JOIN product p4_ ON p3_.product_id = p4_.id
WHERE
  p4_.id = ?
  AND p4_.visible = true
  AND p3_.visible = true
  AND a0_.visible = true
GROUP BY
  a0_.id
ORDER BY
  a0_.sort_path ASC

SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.name AS name_2, a0_.visible AS visible_3, a0_.position AS position_4, a0_.depth AS depth_5, a0_.sort_path AS sort_path_6, a0_.parent_id AS parent_id_7 FROM attribute a0_ INNER JOIN attribute_value a1_ ON a0_.id = a1_.attribute_id INNER JOIN product_variant_attribute_value p2_ ON a1_.id = p2_.attribute_value_id INNER JOIN product_variant p3_ ON p2_.variant_id = p3_.id INNER JOIN product p4_ ON p3_.product_id = p4_.id WHERE p4_.id = 304 AND p4_.visible = true AND p3_.visible = true AND a0_.visible = true GROUP BY a0_.id ORDER BY a0_.sort_path ASC;

SELECT
  a0_.id AS id_0,
  a0_.value AS value_1,
  a0_.value_float AS value_float_2,
  a0_.attribute_id AS attribute_id_3
FROM
  attribute_value a0_
  INNER JOIN attribute a1_ ON a0_.attribute_id = a1_.id
  INNER JOIN product_variant_attribute_value p2_ ON a0_.id = p2_.attribute_value_id
  INNER JOIN product_variant p3_ ON p2_.variant_id = p3_.id
  INNER JOIN product p4_ ON p3_.product_id = p4_.id
WHERE
  p4_.id = ?
  AND p4_.visible = true
  AND p3_.visible = true
  AND a1_.id = ?
GROUP BY
  a0_.id,
  a0_.value,
  a0_.value_float,
  a0_.attribute_id

SELECT a0_.id AS id_0, a0_.value AS value_1, a0_.value_float AS value_float_2, a0_.attribute_id AS attribute_id_3 FROM attribute_value a0_ INNER JOIN attribute a1_ ON a0_.attribute_id = a1_.id INNER JOIN product_variant_attribute_value p2_ ON a0_.id = p2_.attribute_value_id INNER JOIN product_variant p3_ ON p2_.variant_id = p3_.id INNER JOIN product p4_ ON p3_.product_id = p4_.id WHERE p4_.id = 304 AND p4_.visible = true AND p3_.visible = true AND a1_.id = 1 GROUP BY a0_.id, a0_.value, a0_.value_float, a0_.attribute_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 = 304;

SELECT
  a0_.id AS id_0,
  a0_.value AS value_1,
  a0_.value_float AS value_float_2,
  a0_.attribute_id AS attribute_id_3
FROM
  attribute_value a0_
  INNER JOIN attribute a1_ ON a0_.attribute_id = a1_.id
  INNER JOIN product_variant_attribute_value p2_ ON a0_.id = p2_.attribute_value_id
  INNER JOIN product_variant p3_ ON p2_.variant_id = p3_.id
  INNER JOIN product p4_ ON p3_.product_id = p4_.id
WHERE
  p4_.id = ?
  AND p4_.visible = true
  AND p3_.visible = true
  AND a1_.id = ?
  AND p3_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )

SELECT a0_.id AS id_0, a0_.value AS value_1, a0_.value_float AS value_float_2, a0_.attribute_id AS attribute_id_3 FROM attribute_value a0_ INNER JOIN attribute a1_ ON a0_.attribute_id = a1_.id INNER JOIN product_variant_attribute_value p2_ ON a0_.id = p2_.attribute_value_id INNER JOIN product_variant p3_ ON p2_.variant_id = p3_.id INNER JOIN product p4_ ON p3_.product_id = p4_.id WHERE p4_.id = 304 AND p4_.visible = true AND p3_.visible = true AND a1_.id = 1 AND p3_.id IN (11717, 11718, 11719, 11720, 11721, 11722, 11723, 11724, 11725, 11726, 11727, 11728, 11729, 11730, 11731, 11732, 11774, 11775, 11776, 11777, 11778, 11779, 11780, 11781, 11782, 11783, 11784, 11785, 11786, 11787, 11788, 11789);

SELECT
  a0_.id AS id_0,
  a0_.value AS value_1,
  a0_.value_float AS value_float_2,
  a0_.attribute_id AS attribute_id_3
FROM
  attribute_value a0_
  INNER JOIN attribute a1_ ON a0_.attribute_id = a1_.id
  INNER JOIN product_variant_attribute_value p2_ ON a0_.id = p2_.attribute_value_id
  INNER JOIN product_variant p3_ ON p2_.variant_id = p3_.id
  INNER JOIN product p4_ ON p3_.product_id = p4_.id
WHERE
  p4_.id = ?
  AND p4_.visible = true
  AND p3_.visible = true
  AND a1_.id = ?
GROUP BY
  a0_.id,
  a0_.value,
  a0_.value_float,
  a0_.attribute_id
ORDER BY
  a0_.value ASC

SELECT a0_.id AS id_0, a0_.value AS value_1, a0_.value_float AS value_float_2, a0_.attribute_id AS attribute_id_3 FROM attribute_value a0_ INNER JOIN attribute a1_ ON a0_.attribute_id = a1_.id INNER JOIN product_variant_attribute_value p2_ ON a0_.id = p2_.attribute_value_id INNER JOIN product_variant p3_ ON p2_.variant_id = p3_.id INNER JOIN product p4_ ON p3_.product_id = p4_.id WHERE p4_.id = 304 AND p4_.visible = true AND p3_.visible = true AND a1_.id = 10 GROUP BY a0_.id, a0_.value, a0_.value_float, a0_.attribute_id ORDER BY a0_.value ASC;

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

SELECT
  a0_.id AS id_0,
  a0_.value AS value_1,
  a0_.value_float AS value_float_2,
  a0_.attribute_id AS attribute_id_3
FROM
  attribute_value a0_
  INNER JOIN attribute a1_ ON a0_.attribute_id = a1_.id
  INNER JOIN product_variant_attribute_value p2_ ON a0_.id = p2_.attribute_value_id
  INNER JOIN product_variant p3_ ON p2_.variant_id = p3_.id
  INNER JOIN product p4_ ON p3_.product_id = p4_.id
WHERE
  p4_.id = ?
  AND p4_.visible = true
  AND p3_.visible = true
  AND a1_.id = ?
  AND p3_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )
ORDER BY
  a0_.value ASC

SELECT a0_.id AS id_0, a0_.value AS value_1, a0_.value_float AS value_float_2, a0_.attribute_id AS attribute_id_3 FROM attribute_value a0_ INNER JOIN attribute a1_ ON a0_.attribute_id = a1_.id INNER JOIN product_variant_attribute_value p2_ ON a0_.id = p2_.attribute_value_id INNER JOIN product_variant p3_ ON p2_.variant_id = p3_.id INNER JOIN product p4_ ON p3_.product_id = p4_.id WHERE p4_.id = 304 AND p4_.visible = true AND p3_.visible = true AND a1_.id = 10 AND p3_.id IN (11717, 11718, 11719, 11720, 11721, 11722, 11723, 11724, 11725, 11726, 11727, 11728, 11729, 11730, 11731, 11732, 11774, 11775, 11776, 11777, 11778, 11779, 11780, 11781, 11782, 11783, 11784, 11785, 11786, 11787, 11788, 11789) ORDER BY a0_.value ASC;

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

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

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

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 = 304 AND p3_.visible = true AND p2_.visible = true AND p2_.id IN (11717, 11718, 11719, 11720, 11721, 11722, 11723, 11724, 11725, 11726, 11727, 11728, 11729, 11730, 11731, 11732, 11774, 11775, 11776, 11777, 11778, 11779, 11780, 11781, 11782, 11783, 11784, 11785, 11786, 11787, 11788, 11789) GROUP BY i0_.id, i0_.url, i0_.path, i0_.filename, i0_.hash ORDER BY i0_.path ASC;

SELECT
  a0_.id AS id_0,
  a0_.code AS code_1,
  a0_.name AS name_2,
  a0_.visible AS visible_3,
  a0_.position AS position_4,
  a0_.depth AS depth_5,
  a0_.sort_path AS sort_path_6,
  a1_.id AS id_7,
  a1_.value AS value_8,
  a1_.value_float AS value_float_9,
  a0_.parent_id AS parent_id_10,
  a1_.attribute_id AS attribute_id_11
FROM
  attribute a0_
  INNER JOIN attribute_value a1_ ON a0_.id = a1_.attribute_id
  INNER JOIN product_attribute_value p2_ ON a1_.id = p2_.attribute_value_id
  INNER JOIN product p3_ ON p2_.product_id = p3_.id
WHERE
  p3_.id = ?
  AND p3_.visible = true
  AND a0_.visible = true
GROUP BY
  a0_.id,
  a0_.code,
  a0_.name,
  a0_.visible,
  a0_.position,
  a0_.depth,
  a0_.sort_path,
  a0_.parent_id,
  a1_.id,
  a1_.value,
  a1_.value_float,
  a1_.attribute_id
ORDER BY
  a0_.sort_path ASC

SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.name AS name_2, a0_.visible AS visible_3, a0_.position AS position_4, a0_.depth AS depth_5, a0_.sort_path AS sort_path_6, a1_.id AS id_7, a1_.value AS value_8, a1_.value_float AS value_float_9, a0_.parent_id AS parent_id_10, a1_.attribute_id AS attribute_id_11 FROM attribute a0_ INNER JOIN attribute_value a1_ ON a0_.id = a1_.attribute_id INNER JOIN product_attribute_value p2_ ON a1_.id = p2_.attribute_value_id INNER JOIN product p3_ ON p2_.product_id = p3_.id WHERE p3_.id = 304 AND p3_.visible = true AND a0_.visible = true GROUP BY a0_.id, a0_.code, a0_.name, a0_.visible, a0_.position, a0_.depth, a0_.sort_path, a0_.parent_id, a1_.id, a1_.value, a1_.value_float, a1_.attribute_id ORDER BY a0_.sort_path ASC;

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

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 = 304 AND p1_.visible = true AND p0_.visible = true AND p0_.id IN (11717, 11718, 11719, 11720, 11721, 11722, 11723, 11724, 11725, 11726, 11727, 11728, 11729, 11730, 11731, 11732, 11774, 11775, 11776, 11777, 11778, 11779, 11780, 11781, 11782, 11783, 11784, 11785, 11786, 11787, 11788, 11789);

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.visible AS visible_2,
  c0_.created_at AS created_at_3,
  c0_.updated_at AS updated_at_4,
  c0_.position AS position_5,
  c0_.depth AS depth_6,
  c0_.sort_path AS sort_path_7,
  c0_.parent_id AS parent_id_8
FROM
  category c0_
WHERE
  c0_.parent_id IS NULL
  AND c0_.visible = true
ORDER BY
  c0_.sort_path ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.visible AS visible_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.position AS position_5, c0_.depth AS depth_6, c0_.sort_path AS sort_path_7, c0_.parent_id AS parent_id_8 FROM category c0_ WHERE c0_.parent_id IS NULL AND c0_.visible = true ORDER BY c0_.sort_path ASC;

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2,
  t0.attachment_image_id AS attachment_image_id_3
FROM
  product_attachment_image t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.attachment_image_id AS attachment_image_id_3 FROM product_attachment_image t0 WHERE t0.product_id = 304;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.path AS path_3,
  t0.filename AS filename_4,
  t0.hash AS hash_5,
  t0.attachment_id AS attachment_id_6
FROM
  attachment_image t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.path AS path_3, t0.filename AS filename_4, t0.hash AS hash_5, t0.attachment_id AS attachment_id_6 FROM attachment_image t0 WHERE t0.id = 598;

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
  attachment t0
WHERE
  t0.id = ?

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 attachment t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.path AS path_3,
  t0.filename AS filename_4,
  t0.hash AS hash_5,
  t0.attachment_id AS attachment_id_6
FROM
  attachment_image t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.path AS path_3, t0.filename AS filename_4, t0.hash AS hash_5, t0.attachment_id AS attachment_id_6 FROM attachment_image t0 WHERE t0.id = 599;

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
  attachment t0
WHERE
  t0.id = ?

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 attachment t0 WHERE t0.id = 2;