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 = '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 = ?
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 = 1 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
  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 = 1 AND p0_.visible = true AND p2_.visible = true GROUP BY p0_.id) dctrn_result LIMIT 9 OFFSET 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 = 1 AND p0_.visible = true AND p2_.visible = true AND p0_.id IN (407, 10, 258, 35, 45, 216, 395, 387, 406) 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 = 10;

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 = 10 AND p3_.visible = true AND p2_.visible = true AND p2_.id IN (484, 485, 486, 487, 488, 489, 490, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 511, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524) 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 = 10;

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 = 10 AND p1_.visible = true AND p0_.visible = true AND p0_.id IN (484, 485, 486, 487, 488, 489, 490, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 511, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524);

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

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 = 35 AND p3_.visible = true AND p2_.visible = true AND p2_.id IN (2870, 2871, 2872, 2873, 2874, 2875, 2876, 2877, 2878, 2879, 2880, 2881, 2882, 2883, 2884, 11634, 11635, 11636, 11637, 11638) 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 = 35;

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 = 35 AND p1_.visible = true AND p0_.visible = true AND p0_.id IN (2870, 2871, 2872, 2873, 2874, 2875, 2876, 2877, 2878, 2879, 2880, 2881, 2882, 2883, 2884, 11634, 11635, 11636, 11637, 11638);

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

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 = 45 AND p3_.visible = true AND p2_.visible = true AND p2_.id IN (3250, 3251, 3252, 3253, 3254, 3255, 3256, 3257, 3258, 3259, 3260, 3261, 3262, 3263, 3264, 3265, 3266, 3267, 3268, 3269, 3270, 3271, 3272, 3273, 3274, 3275, 3276, 3277, 3278, 3279, 3280, 3281, 3282, 3283, 3284, 3285, 3286, 3287, 3288, 3289, 3290, 3291, 3292, 3293, 3294, 3295, 3296, 3297, 3298, 3299, 3300, 3301, 3302, 3303, 3304, 3305, 3306, 3307, 3308, 3309, 3310, 3311, 3312, 3313, 3314, 3315, 3316, 3317, 3318, 3319, 3320, 3321, 3322, 3323, 3324, 3325, 3326, 3327) 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 = 45;

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 = 45 AND p1_.visible = true AND p0_.visible = true AND p0_.id IN (3250, 3251, 3252, 3253, 3254, 3255, 3256, 3257, 3258, 3259, 3260, 3261, 3262, 3263, 3264, 3265, 3266, 3267, 3268, 3269, 3270, 3271, 3272, 3273, 3274, 3275, 3276, 3277, 3278, 3279, 3280, 3281, 3282, 3283, 3284, 3285, 3286, 3287, 3288, 3289, 3290, 3291, 3292, 3293, 3294, 3295, 3296, 3297, 3298, 3299, 3300, 3301, 3302, 3303, 3304, 3305, 3306, 3307, 3308, 3309, 3310, 3311, 3312, 3313, 3314, 3315, 3316, 3317, 3318, 3319, 3320, 3321, 3322, 3323, 3324, 3325, 3326, 3327);

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