Symfony Profiler

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 = '3040b'
                    GROUP BY lego_database_inventory_parts.part_num ;

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 = '3040b'
                        GROUP BY color_id, part_num
                    ;

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 = '3040b'
                        AND lego_database_inventory_parts.color_id = '41'
                        ;

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 = '3040b';

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
  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 ('1', '2', '3', '4', '5', '6', '7', '8', '10', '14', '15', '19', '25', '26', '27', '28', '29', '30', '33', '34', '36', '41', '42', '46', '47', '70', '71', '72', '73', '84', '85', '143', '182', '191', '212', '272', '288', '308', '320', '321', '322', '323', '326', '351', '378', '379', '484', '1062')
                    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
  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.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;