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

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
  COUNT(*) AS dctrn_count
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_table

SELECT COUNT(*) AS dctrn_count 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 = 3 AND p0_.visible = true AND p2_.visible = true GROUP BY p0_.id) dctrn_table;

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
OFFSET
  36

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 = 3 AND p0_.visible = true AND p2_.visible = true GROUP BY p0_.id) dctrn_result LIMIT 9 OFFSET 36;

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 = 3 AND p0_.visible = true AND p2_.visible = true AND p0_.id IN (292, 60, 253, 66, 263, 271, 59, 290, 356) 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 = 59;

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 = 59 AND p3_.visible = true AND p2_.visible = true AND p2_.id IN (4646, 4647, 4648, 4649, 4650, 4651, 4652, 4653, 4654, 4655, 4656, 4657, 4658, 4659, 4660, 4661, 4662, 4663, 4664, 4665, 4666, 4667, 4668, 4669, 4670, 4671, 4672, 4673, 4674, 4675, 4676, 4677, 4678, 4679, 4680, 4681, 4682, 4683, 4684, 4685, 4686, 4687, 4688, 4689, 4690, 4691, 4692, 4693, 4694, 4695, 4696, 4697, 4698, 4699, 4700, 4701, 4702, 4703, 4704, 4705, 4706, 4707, 4708, 4709, 4710, 4711, 4712, 4713, 4714, 16850, 16851, 16852, 16853, 16854, 16955, 16956, 16957, 16958, 16959, 17569, 17570, 17571, 17572, 17573, 18252, 18253, 18254, 18255, 18256, 18383, 18384, 18385, 18386, 18387, 18388, 18389, 18390, 18391, 18392, 18597, 18598, 18599, 18600, 18601) 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 = 59;

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 = 59 AND p1_.visible = true AND p0_.visible = true AND p0_.id IN (4646, 4647, 4648, 4649, 4650, 4651, 4652, 4653, 4654, 4655, 4656, 4657, 4658, 4659, 4660, 4661, 4662, 4663, 4664, 4665, 4666, 4667, 4668, 4669, 4670, 4671, 4672, 4673, 4674, 4675, 4676, 4677, 4678, 4679, 4680, 4681, 4682, 4683, 4684, 4685, 4686, 4687, 4688, 4689, 4690, 4691, 4692, 4693, 4694, 4695, 4696, 4697, 4698, 4699, 4700, 4701, 4702, 4703, 4704, 4705, 4706, 4707, 4708, 4709, 4710, 4711, 4712, 4713, 4714, 16850, 16851, 16852, 16853, 16854, 16955, 16956, 16957, 16958, 16959, 17569, 17570, 17571, 17572, 17573, 18252, 18253, 18254, 18255, 18256, 18383, 18384, 18385, 18386, 18387, 18388, 18389, 18390, 18391, 18392, 18597, 18598, 18599, 18600, 18601);

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

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 = 60 AND p3_.visible = true AND p2_.visible = true AND p2_.id IN (4715, 4716, 4717, 4718, 4719, 4720, 4721, 4722, 4723, 4724, 4725, 4726, 4727, 4728, 4729, 4730, 4731, 4732, 4733, 4734, 4735, 4736, 4737, 4738, 4739, 4740, 4741, 4742, 4743, 4744, 4745, 4746, 4747, 4748, 4749, 4750, 4751, 4752, 4753, 4754, 4755, 4756, 4757, 4758, 4759, 4760, 4761, 4762, 4763, 4764, 4765, 4766, 4767, 4768, 4769, 4770, 4771, 4772, 4773, 4774, 4775, 4776, 4777, 4778, 4779, 4780, 4781, 4782, 4783, 4784, 4785, 4786, 4787, 4788, 4789, 4790, 4791, 4792, 4793, 4794, 4795, 4796, 4797, 4798) 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 = 60;

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 = 60 AND p1_.visible = true AND p0_.visible = true AND p0_.id IN (4715, 4716, 4717, 4718, 4719, 4720, 4721, 4722, 4723, 4724, 4725, 4726, 4727, 4728, 4729, 4730, 4731, 4732, 4733, 4734, 4735, 4736, 4737, 4738, 4739, 4740, 4741, 4742, 4743, 4744, 4745, 4746, 4747, 4748, 4749, 4750, 4751, 4752, 4753, 4754, 4755, 4756, 4757, 4758, 4759, 4760, 4761, 4762, 4763, 4764, 4765, 4766, 4767, 4768, 4769, 4770, 4771, 4772, 4773, 4774, 4775, 4776, 4777, 4778, 4779, 4780, 4781, 4782, 4783, 4784, 4785, 4786, 4787, 4788, 4789, 4790, 4791, 4792, 4793, 4794, 4795, 4796, 4797, 4798);

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

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 = 66 AND p3_.visible = true AND p2_.visible = true AND p2_.id IN (5082, 5083, 5084, 5085, 5086, 5087, 5088, 5089, 5090, 5091, 5092, 5093, 5094, 5095, 5096, 5097, 5098, 5099, 5100, 5101, 5102, 5103, 5104, 5105, 5106, 5107, 5108, 5109, 5110, 5111, 5112, 5113, 5114, 5115, 5116, 5117, 5118, 5119, 5120, 5121, 5122, 5123, 5124, 5125, 5126, 5127, 5128, 5129, 5130, 5131, 5132, 5133, 18082, 18083, 18084, 18085, 18189, 18190, 18191, 18192, 18505, 18506, 18507, 18508) GROUP BY i0_.id, i0_.url, i0_.path, i0_.filename, i0_.hash ORDER BY i0_.path ASC LIMIT 1;