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 = 'pl-PL' 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
  DISTINCT lego_database_parts.id,
  lego_database_parts.part_num,
  lego_database_parts.name,
  lego_database_parts.total_sets,
  lego_database_parts.total_colors,
  lego_database_parts.part_cat_id,
  lego_database_parts.slug,
  lego_database_inventory_parts.ldraw_part_num,
  lego_database_inventory_parts.color_id,
  lego_database_inventory_parts.ld_raw_id,
  lego_database_parts_categories.name AS categoryName,
  color.name AS colorName
FROM
  lego_database_parts
  INNER JOIN lego_database_inventory_parts ON lego_database_parts.part_num = lego_database_inventory_parts.part_num
  INNER JOIN lego_database_parts_categories ON lego_database_parts.part_cat_id = lego_database_parts_categories.category_id
  INNER JOIN color ON color.rebrickable_id = lego_database_inventory_parts.color_id
WHERE
  lego_database_parts.id > 0
  AND part_cat_id = ?
LIMIT
  ?
OFFSET
  ?

SELECT DISTINCT 
                    lego_database_parts.id,                
                    lego_database_parts.part_num,
                    lego_database_parts.name,
                    lego_database_parts.total_sets,
                    lego_database_parts.total_colors,
                    lego_database_parts.part_cat_id,
                    lego_database_parts.slug,
                    lego_database_inventory_parts.ldraw_part_num,
                    lego_database_inventory_parts.color_id,
                    lego_database_inventory_parts.ld_raw_id,
                    lego_database_parts_categories.name AS categoryName,
                    color.name AS colorName
                        FROM lego_database_parts
                        INNER JOIN lego_database_inventory_parts ON lego_database_parts.part_num = lego_database_inventory_parts.part_num
                        INNER JOIN lego_database_parts_categories ON lego_database_parts.part_cat_id = lego_database_parts_categories.category_id
                        INNER JOIN color ON color.rebrickable_id = lego_database_inventory_parts.color_id
                        WHERE lego_database_parts.id > 0
                         AND part_cat_id = 4 LIMIT 24 OFFSET 5016;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          l0_.id AS id_0,
          l0_.part_num AS part_num_1,
          l0_.name AS name_2,
          l0_.part_cat_id AS part_cat_id_3,
          l0_.part_material AS part_material_4,
          l0_.total_sets AS total_sets_5,
          l0_.total_colors AS total_colors_6,
          l0_.slug AS slug_7,
          l0_.has_image AS has_image_8,
          l0_.active AS active_9
        FROM
          lego_database_parts l0_
        WHERE
          l0_.id <> 0
          AND l0_.part_cat_id = ?
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT l0_.id AS id_0, l0_.part_num AS part_num_1, l0_.name AS name_2, l0_.part_cat_id AS part_cat_id_3, l0_.part_material AS part_material_4, l0_.total_sets AS total_sets_5, l0_.total_colors AS total_colors_6, l0_.slug AS slug_7, l0_.has_image AS has_image_8, l0_.active AS active_9 FROM lego_database_parts l0_ WHERE l0_.id <> 0 AND l0_.part_cat_id = 4) dctrn_result) dctrn_table;

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 = 'pl-PL' 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 = 8 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,
  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 = 'pl-PL' LIMIT 1;

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.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 = 8 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 = ?
  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 = 2 AND t0.language_id = 8 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 = ?
  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 = 3 AND t0.language_id = 8 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 = ?
  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 = 4 AND t0.language_id = 8 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.category_id AS category_id_2,
  t0.name AS name_3
FROM
  lego_database_parts_categories t0

SELECT t0.id AS id_1, t0.category_id AS category_id_2, t0.name AS name_3 FROM lego_database_parts_categories t0;