Symfony Profiler

SELECT
  child_part_num
FROM
  lego_database_part_relationships
WHERE
  parent_part_num = ?

SELECT child_part_num 
                    FROM lego_database_part_relationships 
                    WHERE parent_part_num = '18277pr0005';

SELECT
  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_inventory_parts.ldraw_part_num,
  lego_database_inventory_parts.color_id,
  lego_database_parts_categories.name AS categoryName,
  lego_database_colors.name AS colorName,
  lego_database_colors.is_trans,
  lego_database_colors.y1,
  lego_database_colors.y2
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 lego_database_colors ON lego_database_colors.color_id = lego_database_inventory_parts.color_id
WHERE
  lego_database_parts.part_num = ?
  AND lego_database_inventory_parts.color_id = ?

SELECT 
                    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_inventory_parts.ldraw_part_num,
                    lego_database_inventory_parts.color_id,
                    lego_database_parts_categories.name AS categoryName,
                    lego_database_colors.name AS colorName,
                    lego_database_colors.is_trans,
                    lego_database_colors.y1,
                    lego_database_colors.y2
                        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 lego_database_colors ON lego_database_colors.color_id = lego_database_inventory_parts.color_id
                        WHERE lego_database_parts.part_num = '18277pr0005'
                        AND lego_database_inventory_parts.color_id = '25'
                        ;

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 = 3 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 = ?
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 = 'de-DE' LIMIT 1;

SELECT
  lego_database_inventory_parts.part_num,
  lego_database_parts.slug,
  GROUP_CONCAT(
    DISTINCT lego_database_inventory_parts.color_id
    ORDER BY
      lego_database_inventory_parts.color_id ASC
  ) AS colorIds,
  GROUP_CONCAT(
    DISTINCT lego_database_colors.name
    ORDER BY
      lego_database_colors.color_id ASC
  ) AS colorNames,
  COUNT(
    DISTINCT lego_database_inventory_parts.color_id
  ) AS color_count
FROM
  lego_database_inventory_parts
  INNER JOIN lego_database_parts ON lego_database_parts.part_num = lego_database_inventory_parts.part_num
  INNER JOIN lego_database_colors ON lego_database_colors.color_id = lego_database_inventory_parts.color_id
WHERE
  lego_database_inventory_parts.part_num = ?
GROUP BY
  lego_database_inventory_parts.part_num

SELECT lego_database_inventory_parts.part_num,
                lego_database_parts.slug,
                GROUP_CONCAT(DISTINCT lego_database_inventory_parts.color_id ORDER BY lego_database_inventory_parts.color_id ASC) AS colorIds,
                GROUP_CONCAT(DISTINCT lego_database_colors.name ORDER BY lego_database_colors.color_id ASC) AS colorNames,
                COUNT(DISTINCT lego_database_inventory_parts.color_id) AS color_count
                    FROM lego_database_inventory_parts
                    INNER JOIN lego_database_parts ON lego_database_parts.part_num = lego_database_inventory_parts.part_num 
                    INNER JOIN lego_database_colors ON lego_database_colors.color_id = lego_database_inventory_parts.color_id
                    WHERE lego_database_inventory_parts.part_num = '18277pr0005'
                    GROUP BY lego_database_inventory_parts.part_num ;

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
  y1,
  y2,
  num_sets
FROM
  lego_database_colors
WHERE
  color_id IN (?)
GROUP BY
  color_id

SELECT y1, y2, num_sets
                    FROM lego_database_colors
                    WHERE color_id IN ('25')
                    GROUP BY color_id;

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 = 3 AND t0_.slug IS NOT NULL ORDER BY t0_.name ASC;

SELECT
  MAX(id) as id,
  color_id,
  part_num
from
  lego_database_inventory_parts
WHERE
  part_num = ?
GROUP BY
  color_id,
  part_num

SELECT 
                    MAX(id) as id,
                    color_id,
                    part_num
                        from lego_database_inventory_parts
                        WHERE part_num = '18277pr0005'
                        GROUP BY color_id, part_num
                    ;

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;

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');