Symfony Profiler

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,
  p1_.id AS id_6,
  p1_.name AS name_7,
  p1_.description AS description_8,
  p1_.ean AS ean_9,
  p1_.published_at AS published_at_10,
  p1_.active AS active_11,
  p1_.mpn AS mpn_12,
  p1_.bol_product_id AS bol_product_id_13,
  p1_.total_parts AS total_parts_14,
  p1_.total_minifigs AS total_minifigs_15,
  p1_.instructions_download_url AS instructions_download_url_16,
  p1_.bol_url AS bol_url_17,
  p1_.seo_text_1 AS seo_text_1_18,
  p1_.seo_text_2 AS seo_text_2_19,
  p1_.final_seo_description_short AS final_seo_description_short_20,
  p1_.final_seo_title AS final_seo_title_21,
  p1_.final_seo_description AS final_seo_description_22,
  p1_.ai_processed AS ai_processed_23,
  p1_.ai_translated AS ai_translated_24,
  p1_.slug AS slug_25,
  p1_.lego_images_downloaded AS lego_images_downloaded_26,
  p1_.lego_detail_url AS lego_detail_url_27,
  p1_.lego_bltnummer AS lego_bltnummer_28,
  t2_.id AS id_29,
  t2_.name AS name_30,
  t2_.description AS description_31,
  t2_.slug AS slug_32,
  t2_.position AS position_33,
  t2_.image AS image_34,
  t3_.id AS id_35,
  t3_.slug AS slug_36,
  t3_.name AS name_37,
  t3_.description AS description_38,
  p0_.language_id AS language_id_39,
  p0_.product_id AS product_id_40,
  p1_.thema_id AS thema_id_41,
  t3_.thema_id AS thema_id_42,
  t3_.language_id AS language_id_43
FROM
  product_translation p0_
  INNER JOIN product p1_ ON p0_.product_id = p1_.id
  INNER JOIN thema t2_ ON p1_.thema_id = t2_.id
  INNER JOIN thema_translation t3_ ON t2_.id = t3_.thema_id
  AND (t3_.language_id = ?)
WHERE
  p0_.language_id = ?
ORDER BY
  p0_.id ASC
LIMIT
  9

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, p1_.id AS id_6, p1_.name AS name_7, p1_.description AS description_8, p1_.ean AS ean_9, p1_.published_at AS published_at_10, p1_.active AS active_11, p1_.mpn AS mpn_12, p1_.bol_product_id AS bol_product_id_13, p1_.total_parts AS total_parts_14, p1_.total_minifigs AS total_minifigs_15, p1_.instructions_download_url AS instructions_download_url_16, p1_.bol_url AS bol_url_17, p1_.seo_text_1 AS seo_text_1_18, p1_.seo_text_2 AS seo_text_2_19, p1_.final_seo_description_short AS final_seo_description_short_20, p1_.final_seo_title AS final_seo_title_21, p1_.final_seo_description AS final_seo_description_22, p1_.ai_processed AS ai_processed_23, p1_.ai_translated AS ai_translated_24, p1_.slug AS slug_25, p1_.lego_images_downloaded AS lego_images_downloaded_26, p1_.lego_detail_url AS lego_detail_url_27, p1_.lego_bltnummer AS lego_bltnummer_28, t2_.id AS id_29, t2_.name AS name_30, t2_.description AS description_31, t2_.slug AS slug_32, t2_.position AS position_33, t2_.image AS image_34, t3_.id AS id_35, t3_.slug AS slug_36, t3_.name AS name_37, t3_.description AS description_38, p0_.language_id AS language_id_39, p0_.product_id AS product_id_40, p1_.thema_id AS thema_id_41, t3_.thema_id AS thema_id_42, t3_.language_id AS language_id_43 FROM product_translation p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id INNER JOIN thema t2_ ON p1_.thema_id = t2_.id INNER JOIN thema_translation t3_ ON t2_.id = t3_.thema_id AND (t3_.language_id = 2) WHERE p0_.language_id = 2 ORDER BY p0_.id ASC LIMIT 9;

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

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 = 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 = ?
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 = 'nl-NL' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.package_width AS package_width_2,
  t0.package_length AS package_length_3,
  t0.package_height AS package_height_4,
  t0.product_width AS product_width_5,
  t0.product_length AS product_length_6,
  t0.product_height AS product_height_7,
  t0.weight AS weight_8,
  t0.product_id AS product_id_9
FROM
  product_dimensions t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.package_width AS package_width_2, t0.package_length AS package_length_3, t0.package_height AS package_height_4, t0.product_width AS product_width_5, t0.product_length AS product_length_6, t0.product_height AS product_height_7, t0.weight AS weight_8, t0.product_id AS product_id_9 FROM product_dimensions t0 WHERE t0.product_id = 1;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.slug AS slug_2,
  b0_.meta_description AS meta_description_3,
  b0_.content AS content_4,
  b0_.short_description AS short_description_5,
  b0_.language_id AS language_id_6,
  b0_.article_id AS article_id_7
FROM
  blog_article_translation b0_
  INNER JOIN blog_article b1_ ON b0_.article_id = b1_.id
WHERE
  b0_.language_id = ?
ORDER BY
  b1_.published_at DESC
LIMIT
  3

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, b0_.meta_description AS meta_description_3, b0_.content AS content_4, b0_.short_description AS short_description_5, b0_.language_id AS language_id_6, b0_.article_id AS article_id_7 FROM blog_article_translation b0_ INNER JOIN blog_article b1_ ON b0_.article_id = b1_.id WHERE b0_.language_id = 2 ORDER BY b1_.published_at DESC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.year AS year_2,
  t0.month AS month_3,
  t0.product_id AS product_id_4
FROM
  product_release_data t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.year AS year_2, t0.month AS month_3, t0.product_id AS product_id_4 FROM product_release_data t0 WHERE t0.product_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.text AS text_4,
  t0.language_id AS language_id_5,
  t0.content_page_id AS content_page_id_6
FROM
  content_page_translation t0
WHERE
  t0.content_page_id = ?
  AND t0.language_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.text AS text_4, t0.language_id AS language_id_5, t0.content_page_id AS content_page_id_6 FROM content_page_translation t0 WHERE t0.content_page_id = 1 AND t0.language_id = 2 LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_.slug AS slug_1,
  t0_.name AS name_2,
  t0_.description AS description_3,
  t0_.thema_id AS thema_id_4,
  t0_.language_id AS language_id_5
FROM
  thema_translation t0_
WHERE
  t0_.language_id = ?
  AND t0_.slug IS NOT NULL
ORDER BY
  t0_.name ASC

SELECT t0_.id AS id_0, t0_.slug AS slug_1, t0_.name AS name_2, t0_.description AS description_3, t0_.thema_id AS thema_id_4, t0_.language_id AS language_id_5 FROM thema_translation t0_ WHERE t0_.language_id = 2 AND t0_.slug IS NOT NULL ORDER BY t0_.name ASC;

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
FROM
  content_page t0
WHERE
  t0.name IN (?, ?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2 FROM content_page t0 WHERE t0.name IN ('algemene voorwaarden', 'privacy', 'contact', 'overons');

SELECT
  t0.id AS id_1,
  t0.internal_name AS internal_name_2,
  t0.published_at AS published_at_3,
  t0.featured_image AS featured_image_4,
  t0.product_ids AS product_ids_5,
  t0.product_id AS product_id_6
FROM
  blog_article t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.internal_name AS internal_name_2, t0.published_at AS published_at_3, t0.featured_image AS featured_image_4, t0.product_ids AS product_ids_5, t0.product_id AS product_id_6 FROM blog_article t0 WHERE t0.id = 1;