Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.locale AS locale_4,
  t0.sorting AS sorting_5
FROM
  language t0
WHERE
  t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.locale AS locale_4, t0.sorting AS sorting_5 FROM language t0 WHERE t0.locale = 'en-EN' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.locale AS locale_4,
  t0.sorting AS sorting_5
FROM
  language t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.locale AS locale_4, t0.sorting AS sorting_5 FROM language t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.locale AS locale_4,
  t0.sorting AS sorting_5
FROM
  language t0
WHERE
  t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.locale AS locale_4, t0.sorting AS sorting_5 FROM language t0 WHERE t0.locale = 'en-EN' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.thema_id AS thema_id_5,
  t0.language_id AS language_id_6
FROM
  thema_translation t0
WHERE
  t0.slug = ?
  AND t0.language_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.thema_id AS thema_id_5, t0.language_id AS language_id_6 FROM thema_translation t0 WHERE t0.slug = 'harry-potter' AND t0.language_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.thema_id AS thema_id_5,
  t0.language_id AS language_id_6
FROM
  thema_translation t0

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.thema_id AS thema_id_5, t0.language_id AS language_id_6 FROM thema_translation t0;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      p0_.id AS id_0,
      p0_.name AS name_1,
      p0_.slug AS slug_2,
      p0_.description AS description_3,
      p0_.description_short AS description_short_4,
      p0_.title AS title_5
    FROM
      product_translation p0_
      INNER JOIN product p1_ ON p0_.product_id = p1_.id
      INNER JOIN thema t2_ ON p1_.thema_id = t2_.id
    WHERE
      p0_.language_id = ?
      AND t2_.id = ?
  ) dctrn_result
LIMIT
  24

SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.description_short AS description_short_4, p0_.title AS title_5 FROM product_translation p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id INNER JOIN thema t2_ ON p1_.thema_id = t2_.id WHERE p0_.language_id = 1 AND t2_.id = 4) dctrn_result LIMIT 24;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.description AS description_3,
  p0_.description_short AS description_short_4,
  p0_.title AS title_5,
  p0_.language_id AS language_id_6,
  p0_.product_id AS product_id_7
FROM
  product_translation p0_
  INNER JOIN product p1_ ON p0_.product_id = p1_.id
  INNER JOIN thema t2_ ON p1_.thema_id = t2_.id
WHERE
  p0_.language_id = ?
  AND t2_.id = ?
  AND p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.description_short AS description_short_4, p0_.title AS title_5, p0_.language_id AS language_id_6, p0_.product_id AS product_id_7 FROM product_translation p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id INNER JOIN thema t2_ ON p1_.thema_id = t2_.id WHERE p0_.language_id = 1 AND t2_.id = 4 AND p0_.id IN (9, 17, 25, 33, 41, 49, 57, 65, 89, 73, 81, 97, 105, 121, 113, 129, 137, 145);

SELECT
  s0_.product_id AS sclr_0,
  AVG(s0_.rating) AS sclr_1
FROM
  stars s0_
WHERE
  s0_.product_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )
GROUP BY
  s0_.product_id

SELECT s0_.product_id AS sclr_0, AVG(s0_.rating) AS sclr_1 FROM stars s0_ WHERE s0_.product_id IN (2, 3, 4, 5, 6, 7, 8, 9, 11, 12, 10, 13, 14, 16, 15, 17, 18, 19) GROUP BY s0_.product_id;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.locale AS locale_4,
  t0.sorting AS sorting_5
FROM
  language t0
WHERE
  t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.locale AS locale_4, t0.sorting AS sorting_5 FROM language t0 WHERE t0.locale = 'en-EN' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.description AS description_3,
  p0_.description_short AS description_short_4,
  p0_.title AS title_5,
  p0_.language_id AS language_id_6,
  p0_.product_id AS product_id_7
FROM
  product_translation p0_
  INNER JOIN product p1_ ON p0_.product_id = p1_.id
WHERE
  p0_.language_id = ?
  AND p1_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.description_short AS description_short_4, p0_.title AS title_5, p0_.language_id AS language_id_6, p0_.product_id AS product_id_7 FROM product_translation p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id WHERE p0_.language_id = 1 AND p1_.id IN (2, 3, 4, 5, 6, 7, 8, 9, 11, 12, 10, 13, 14, 16, 15, 17, 18, 19);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.ean AS ean_4,
  t0.published_at AS published_at_5,
  t0.active AS active_6,
  t0.mpn AS mpn_7,
  t0.bol_product_id AS bol_product_id_8,
  t0.total_parts AS total_parts_9,
  t0.total_minifigs AS total_minifigs_10,
  t0.instructions_download_url AS instructions_download_url_11,
  t0.bol_url AS bol_url_12,
  t0.seo_text_1 AS seo_text_1_13,
  t0.seo_text_2 AS seo_text_2_14,
  t0.final_seo_description_short AS final_seo_description_short_15,
  t0.final_seo_title AS final_seo_title_16,
  t0.final_seo_description AS final_seo_description_17,
  t0.ai_processed AS ai_processed_18,
  t0.ai_translated AS ai_translated_19,
  t0.slug AS slug_20,
  t0.lego_images_downloaded AS lego_images_downloaded_21,
  t0.lego_detail_url AS lego_detail_url_22,
  t0.lego_bltnummer AS lego_bltnummer_23,
  t24.id AS id_25,
  t24.package_width AS package_width_26,
  t24.package_length AS package_length_27,
  t24.package_height AS package_height_28,
  t24.product_width AS product_width_29,
  t24.product_length AS product_length_30,
  t24.product_height AS product_height_31,
  t24.weight AS weight_32,
  t24.product_id AS product_id_33,
  t34.id AS id_35,
  t34.year AS year_36,
  t34.month AS month_37,
  t34.product_id AS product_id_38,
  t0.thema_id AS thema_id_39
FROM
  product t0
  LEFT JOIN product_dimensions t24 ON t24.product_id = t0.id
  LEFT JOIN product_release_data t34 ON t34.product_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.ean AS ean_4, t0.published_at AS published_at_5, t0.active AS active_6, t0.mpn AS mpn_7, t0.bol_product_id AS bol_product_id_8, t0.total_parts AS total_parts_9, t0.total_minifigs AS total_minifigs_10, t0.instructions_download_url AS instructions_download_url_11, t0.bol_url AS bol_url_12, t0.seo_text_1 AS seo_text_1_13, t0.seo_text_2 AS seo_text_2_14, t0.final_seo_description_short AS final_seo_description_short_15, t0.final_seo_title AS final_seo_title_16, t0.final_seo_description AS final_seo_description_17, t0.ai_processed AS ai_processed_18, t0.ai_translated AS ai_translated_19, t0.slug AS slug_20, t0.lego_images_downloaded AS lego_images_downloaded_21, t0.lego_detail_url AS lego_detail_url_22, t0.lego_bltnummer AS lego_bltnummer_23, t24.id AS id_25, t24.package_width AS package_width_26, t24.package_length AS package_length_27, t24.package_height AS package_height_28, t24.product_width AS product_width_29, t24.product_length AS product_length_30, t24.product_height AS product_height_31, t24.weight AS weight_32, t24.product_id AS product_id_33, t34.id AS id_35, t34.year AS year_36, t34.month AS month_37, t34.product_id AS product_id_38, t0.thema_id AS thema_id_39 FROM product t0 LEFT JOIN product_dimensions t24 ON t24.product_id = t0.id LEFT JOIN product_release_data t34 ON t34.product_id = t0.id WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.file AS file_3,
  t0.alt_text AS alt_text_4,
  t0.title AS title_5,
  t0.priority AS priority_6,
  t0.updated_at AS updated_at_7,
  t0.lego_afbeelding_id AS lego_afbeelding_id_8,
  t0.product_id AS product_id_9
FROM
  product_images t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.file AS file_3, t0.alt_text AS alt_text_4, t0.title AS title_5, t0.priority AS priority_6, t0.updated_at AS updated_at_7, t0.lego_afbeelding_id AS lego_afbeelding_id_8, t0.product_id AS product_id_9 FROM product_images t0 WHERE t0.product_id = 2;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.discount_price AS discount_price_3,
  t0.valid_until AS valid_until_4,
  t0.is_visible AS is_visible_5,
  t0.product_id AS product_id_6,
  t0.retailer_id AS retailer_id_7
FROM
  product_price t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.discount_price AS discount_price_3, t0.valid_until AS valid_until_4, t0.is_visible AS is_visible_5, t0.product_id AS product_id_6, t0.retailer_id AS retailer_id_7 FROM product_price t0 WHERE t0.product_id = 2;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.thema_id AS thema_id_5,
  t0.language_id AS language_id_6
FROM
  thema_translation t0
WHERE
  t0.language_id = ?
  AND t0.thema_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.thema_id AS thema_id_5, t0.language_id AS language_id_6 FROM thema_translation t0 WHERE t0.language_id = 1 AND t0.thema_id = 4 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.rating AS rating_2,
  t0.create_at AS create_at_3,
  t0.product_id AS product_id_4,
  t0.user_id AS user_id_5
FROM
  stars t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.rating AS rating_2, t0.create_at AS create_at_3, t0.product_id AS product_id_4, t0.user_id AS user_id_5 FROM stars t0 WHERE t0.product_id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.ean AS ean_4,
  t0.published_at AS published_at_5,
  t0.active AS active_6,
  t0.mpn AS mpn_7,
  t0.bol_product_id AS bol_product_id_8,
  t0.total_parts AS total_parts_9,
  t0.total_minifigs AS total_minifigs_10,
  t0.instructions_download_url AS instructions_download_url_11,
  t0.bol_url AS bol_url_12,
  t0.seo_text_1 AS seo_text_1_13,
  t0.seo_text_2 AS seo_text_2_14,
  t0.final_seo_description_short AS final_seo_description_short_15,
  t0.final_seo_title AS final_seo_title_16,
  t0.final_seo_description AS final_seo_description_17,
  t0.ai_processed AS ai_processed_18,
  t0.ai_translated AS ai_translated_19,
  t0.slug AS slug_20,
  t0.lego_images_downloaded AS lego_images_downloaded_21,
  t0.lego_detail_url AS lego_detail_url_22,
  t0.lego_bltnummer AS lego_bltnummer_23,
  t24.id AS id_25,
  t24.package_width AS package_width_26,
  t24.package_length AS package_length_27,
  t24.package_height AS package_height_28,
  t24.product_width AS product_width_29,
  t24.product_length AS product_length_30,
  t24.product_height AS product_height_31,
  t24.weight AS weight_32,
  t24.product_id AS product_id_33,
  t34.id AS id_35,
  t34.year AS year_36,
  t34.month AS month_37,
  t34.product_id AS product_id_38,
  t0.thema_id AS thema_id_39
FROM
  product t0
  LEFT JOIN product_dimensions t24 ON t24.product_id = t0.id
  LEFT JOIN product_release_data t34 ON t34.product_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.ean AS ean_4, t0.published_at AS published_at_5, t0.active AS active_6, t0.mpn AS mpn_7, t0.bol_product_id AS bol_product_id_8, t0.total_parts AS total_parts_9, t0.total_minifigs AS total_minifigs_10, t0.instructions_download_url AS instructions_download_url_11, t0.bol_url AS bol_url_12, t0.seo_text_1 AS seo_text_1_13, t0.seo_text_2 AS seo_text_2_14, t0.final_seo_description_short AS final_seo_description_short_15, t0.final_seo_title AS final_seo_title_16, t0.final_seo_description AS final_seo_description_17, t0.ai_processed AS ai_processed_18, t0.ai_translated AS ai_translated_19, t0.slug AS slug_20, t0.lego_images_downloaded AS lego_images_downloaded_21, t0.lego_detail_url AS lego_detail_url_22, t0.lego_bltnummer AS lego_bltnummer_23, t24.id AS id_25, t24.package_width AS package_width_26, t24.package_length AS package_length_27, t24.package_height AS package_height_28, t24.product_width AS product_width_29, t24.product_length AS product_length_30, t24.product_height AS product_height_31, t24.weight AS weight_32, t24.product_id AS product_id_33, t34.id AS id_35, t34.year AS year_36, t34.month AS month_37, t34.product_id AS product_id_38, t0.thema_id AS thema_id_39 FROM product t0 LEFT JOIN product_dimensions t24 ON t24.product_id = t0.id LEFT JOIN product_release_data t34 ON t34.product_id = t0.id WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.file AS file_3,
  t0.alt_text AS alt_text_4,
  t0.title AS title_5,
  t0.priority AS priority_6,
  t0.updated_at AS updated_at_7,
  t0.lego_afbeelding_id AS lego_afbeelding_id_8,
  t0.product_id AS product_id_9
FROM
  product_images t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.file AS file_3, t0.alt_text AS alt_text_4, t0.title AS title_5, t0.priority AS priority_6, t0.updated_at AS updated_at_7, t0.lego_afbeelding_id AS lego_afbeelding_id_8, t0.product_id AS product_id_9 FROM product_images t0 WHERE t0.product_id = 3;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.discount_price AS discount_price_3,
  t0.valid_until AS valid_until_4,
  t0.is_visible AS is_visible_5,
  t0.product_id AS product_id_6,
  t0.retailer_id AS retailer_id_7
FROM
  product_price t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.discount_price AS discount_price_3, t0.valid_until AS valid_until_4, t0.is_visible AS is_visible_5, t0.product_id AS product_id_6, t0.retailer_id AS retailer_id_7 FROM product_price t0 WHERE t0.product_id = 3;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.thema_id AS thema_id_5,
  t0.language_id AS language_id_6
FROM
  thema_translation t0
WHERE
  t0.language_id = ?
  AND t0.thema_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.thema_id AS thema_id_5, t0.language_id AS language_id_6 FROM thema_translation t0 WHERE t0.language_id = 1 AND t0.thema_id = 4 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.rating AS rating_2,
  t0.create_at AS create_at_3,
  t0.product_id AS product_id_4,
  t0.user_id AS user_id_5
FROM
  stars t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.rating AS rating_2, t0.create_at AS create_at_3, t0.product_id AS product_id_4, t0.user_id AS user_id_5 FROM stars t0 WHERE t0.product_id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.ean AS ean_4,
  t0.published_at AS published_at_5,
  t0.active AS active_6,
  t0.mpn AS mpn_7,
  t0.bol_product_id AS bol_product_id_8,
  t0.total_parts AS total_parts_9,
  t0.total_minifigs AS total_minifigs_10,
  t0.instructions_download_url AS instructions_download_url_11,
  t0.bol_url AS bol_url_12,
  t0.seo_text_1 AS seo_text_1_13,
  t0.seo_text_2 AS seo_text_2_14,
  t0.final_seo_description_short AS final_seo_description_short_15,
  t0.final_seo_title AS final_seo_title_16,
  t0.final_seo_description AS final_seo_description_17,
  t0.ai_processed AS ai_processed_18,
  t0.ai_translated AS ai_translated_19,
  t0.slug AS slug_20,
  t0.lego_images_downloaded AS lego_images_downloaded_21,
  t0.lego_detail_url AS lego_detail_url_22,
  t0.lego_bltnummer AS lego_bltnummer_23,
  t24.id AS id_25,
  t24.package_width AS package_width_26,
  t24.package_length AS package_length_27,
  t24.package_height AS package_height_28,
  t24.product_width AS product_width_29,
  t24.product_length AS product_length_30,
  t24.product_height AS product_height_31,
  t24.weight AS weight_32,
  t24.product_id AS product_id_33,
  t34.id AS id_35,
  t34.year AS year_36,
  t34.month AS month_37,
  t34.product_id AS product_id_38,
  t0.thema_id AS thema_id_39
FROM
  product t0
  LEFT JOIN product_dimensions t24 ON t24.product_id = t0.id
  LEFT JOIN product_release_data t34 ON t34.product_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.ean AS ean_4, t0.published_at AS published_at_5, t0.active AS active_6, t0.mpn AS mpn_7, t0.bol_product_id AS bol_product_id_8, t0.total_parts AS total_parts_9, t0.total_minifigs AS total_minifigs_10, t0.instructions_download_url AS instructions_download_url_11, t0.bol_url AS bol_url_12, t0.seo_text_1 AS seo_text_1_13, t0.seo_text_2 AS seo_text_2_14, t0.final_seo_description_short AS final_seo_description_short_15, t0.final_seo_title AS final_seo_title_16, t0.final_seo_description AS final_seo_description_17, t0.ai_processed AS ai_processed_18, t0.ai_translated AS ai_translated_19, t0.slug AS slug_20, t0.lego_images_downloaded AS lego_images_downloaded_21, t0.lego_detail_url AS lego_detail_url_22, t0.lego_bltnummer AS lego_bltnummer_23, t24.id AS id_25, t24.package_width AS package_width_26, t24.package_length AS package_length_27, t24.package_height AS package_height_28, t24.product_width AS product_width_29, t24.product_length AS product_length_30, t24.product_height AS product_height_31, t24.weight AS weight_32, t24.product_id AS product_id_33, t34.id AS id_35, t34.year AS year_36, t34.month AS month_37, t34.product_id AS product_id_38, t0.thema_id AS thema_id_39 FROM product t0 LEFT JOIN product_dimensions t24 ON t24.product_id = t0.id LEFT JOIN product_release_data t34 ON t34.product_id = t0.id WHERE t0.id = 4;