Symfony Profiler

SELECT
  b0_.id AS id_0,
  b0_.content AS content_1,
  b0_.created_at AS created_at_2,
  b0_.updated_at AS updated_at_3,
  b0_.game_name AS game_name_4,
  b0_.min_players AS min_players_5,
  b0_.max_players AS max_players_6,
  b0_.play_time AS play_time_7,
  b0_.min_age AS min_age_8,
  b0_.difficulty AS difficulty_9,
  b0_.cover_image_filename AS cover_image_filename_10,
  b0_.release_date AS release_date_11,
  b0_.language AS language_12,
  b0_.slug AS slug_13,
  b0_.score AS score_14,
  b0_.average_rating AS average_rating_15,
  b0_.mise_en_place AS mise_en_place_16,
  b0_.rejouabilite AS rejouabilite_17,
  b0_.interactivite AS interactivite_18,
  b0_.prise_en_main AS prise_en_main_19,
  b0_.thematique AS thematique_20,
  b0_.materiel AS materiel_21,
  b0_.difficulte_description AS difficulte_description_22,
  b0_.mise_en_place_description AS mise_en_place_description_23,
  b0_.rejouabilite_description AS rejouabilite_description_24,
  b0_.interactivite_description AS interactivite_description_25,
  b0_.prise_en_main_description AS prise_en_main_description_26,
  b0_.thematique_description AS thematique_description_27,
  b0_.materiel_description AS materiel_description_28,
  b0_.author_rating AS author_rating_29,
  b0_.author_comment AS author_comment_30,
  b0_.is_standalone_extension AS is_standalone_extension_31,
  b0_.edition_name AS edition_name_32,
  b0_.bgg_id AS bgg_id_33,
  b0_.bgg_rank AS bgg_rank_34,
  u1_.id AS id_35,
  u1_.registered_at AS registered_at_36,
  u1_.last_login_at AS last_login_at_37,
  u1_.nickname AS nickname_38,
  u1_.roles AS roles_39,
  u1_.password AS password_40,
  u1_.email AS email_41,
  u1_.is_verified AS is_verified_42,
  u1_.google_id AS google_id_43,
  u1_.first_name AS first_name_44,
  u1_.last_name AS last_name_45,
  u1_.date_of_birth AS date_of_birth_46,
  u1_.avatar_filename AS avatar_filename_47,
  u1_.updated_at AS updated_at_48,
  u1_.notification_settings AS notification_settings_49,
  u1_.is_profile_private AS is_profile_private_50,
  b2_.id AS id_51,
  b2_.name AS name_52,
  b3_.id AS id_53,
  b3_.name AS name_54,
  b3_.color AS color_55,
  b3_.text_color AS text_color_56,
  b4_.id AS id_57,
  b4_.rating AS rating_58,
  b4_.comment AS comment_59,
  b4_.created_at AS created_at_60,
  b4_.updated_at AS updated_at_61,
  b5_.id AS id_62,
  b5_.filename AS filename_63,
  b5_.original_filename AS original_filename_64,
  b5_.size AS size_65,
  b5_.mime_type AS mime_type_66,
  b5_.title AS title_67,
  b5_.updated_at AS updated_at_68,
  b5_.description AS description_69,
  b5_.uploaded_at AS uploaded_at_70,
  b6_.id AS id_71,
  b6_.played_at AS played_at_72,
  b6_.guest_players AS guest_players_73,
  b6_.winner_name AS winner_name_74,
  b6_.results AS results_75,
  b6_.location AS location_76,
  b6_.notes AS notes_77,
  b6_.created_at AS created_at_78,
  b6_.is_public AS is_public_79,
  b0_.author_id AS author_id_80,
  b0_.base_game_id AS base_game_id_81,
  b0_.main_edition_id AS main_edition_id_82,
  b2_.category_id AS category_id_83,
  b2_.main_tag_id AS main_tag_id_84,
  b4_.boardgame_id AS boardgame_id_85,
  b4_.author_id AS author_id_86,
  b5_.boardgame_id AS boardgame_id_87,
  b5_.uploaded_by_id AS uploaded_by_id_88,
  b6_.boardgame_id AS boardgame_id_89,
  b6_.user_id AS user_id_90,
  b6_.tournament_id AS tournament_id_91
FROM
  bgg_boardgame b0_
  LEFT JOIN users u1_ ON b0_.author_id = u1_.id
  LEFT JOIN bgg_boardgame_tag b7_ ON b0_.id = b7_.boardgame_id
  LEFT JOIN bgg_tag b2_ ON b2_.id = b7_.tag_id
  LEFT JOIN bgg_tag_category b3_ ON b2_.category_id = b3_.id
  LEFT JOIN bgg_review b4_ ON b0_.id = b4_.boardgame_id
  LEFT JOIN boardgame_file b5_ ON b0_.id = b5_.boardgame_id
  LEFT JOIN bgg_play_session b6_ ON b0_.id = b6_.boardgame_id
WHERE
  b0_.slug = ?

SELECT b0_.id AS id_0, b0_.content AS content_1, b0_.created_at AS created_at_2, b0_.updated_at AS updated_at_3, b0_.game_name AS game_name_4, b0_.min_players AS min_players_5, b0_.max_players AS max_players_6, b0_.play_time AS play_time_7, b0_.min_age AS min_age_8, b0_.difficulty AS difficulty_9, b0_.cover_image_filename AS cover_image_filename_10, b0_.release_date AS release_date_11, b0_.language AS language_12, b0_.slug AS slug_13, b0_.score AS score_14, b0_.average_rating AS average_rating_15, b0_.mise_en_place AS mise_en_place_16, b0_.rejouabilite AS rejouabilite_17, b0_.interactivite AS interactivite_18, b0_.prise_en_main AS prise_en_main_19, b0_.thematique AS thematique_20, b0_.materiel AS materiel_21, b0_.difficulte_description AS difficulte_description_22, b0_.mise_en_place_description AS mise_en_place_description_23, b0_.rejouabilite_description AS rejouabilite_description_24, b0_.interactivite_description AS interactivite_description_25, b0_.prise_en_main_description AS prise_en_main_description_26, b0_.thematique_description AS thematique_description_27, b0_.materiel_description AS materiel_description_28, b0_.author_rating AS author_rating_29, b0_.author_comment AS author_comment_30, b0_.is_standalone_extension AS is_standalone_extension_31, b0_.edition_name AS edition_name_32, b0_.bgg_id AS bgg_id_33, b0_.bgg_rank AS bgg_rank_34, u1_.id AS id_35, u1_.registered_at AS registered_at_36, u1_.last_login_at AS last_login_at_37, u1_.nickname AS nickname_38, u1_.roles AS roles_39, u1_.password AS password_40, u1_.email AS email_41, u1_.is_verified AS is_verified_42, u1_.google_id AS google_id_43, u1_.first_name AS first_name_44, u1_.last_name AS last_name_45, u1_.date_of_birth AS date_of_birth_46, u1_.avatar_filename AS avatar_filename_47, u1_.updated_at AS updated_at_48, u1_.notification_settings AS notification_settings_49, u1_.is_profile_private AS is_profile_private_50, b2_.id AS id_51, b2_.name AS name_52, b3_.id AS id_53, b3_.name AS name_54, b3_.color AS color_55, b3_.text_color AS text_color_56, b4_.id AS id_57, b4_.rating AS rating_58, b4_.comment AS comment_59, b4_.created_at AS created_at_60, b4_.updated_at AS updated_at_61, b5_.id AS id_62, b5_.filename AS filename_63, b5_.original_filename AS original_filename_64, b5_.size AS size_65, b5_.mime_type AS mime_type_66, b5_.title AS title_67, b5_.updated_at AS updated_at_68, b5_.description AS description_69, b5_.uploaded_at AS uploaded_at_70, b6_.id AS id_71, b6_.played_at AS played_at_72, b6_.guest_players AS guest_players_73, b6_.winner_name AS winner_name_74, b6_.results AS results_75, b6_.location AS location_76, b6_.notes AS notes_77, b6_.created_at AS created_at_78, b6_.is_public AS is_public_79, b0_.author_id AS author_id_80, b0_.base_game_id AS base_game_id_81, b0_.main_edition_id AS main_edition_id_82, b2_.category_id AS category_id_83, b2_.main_tag_id AS main_tag_id_84, b4_.boardgame_id AS boardgame_id_85, b4_.author_id AS author_id_86, b5_.boardgame_id AS boardgame_id_87, b5_.uploaded_by_id AS uploaded_by_id_88, b6_.boardgame_id AS boardgame_id_89, b6_.user_id AS user_id_90, b6_.tournament_id AS tournament_id_91 FROM bgg_boardgame b0_ LEFT JOIN users u1_ ON b0_.author_id = u1_.id LEFT JOIN bgg_boardgame_tag b7_ ON b0_.id = b7_.boardgame_id LEFT JOIN bgg_tag b2_ ON b2_.id = b7_.tag_id LEFT JOIN bgg_tag_category b3_ ON b2_.category_id = b3_.id LEFT JOIN bgg_review b4_ ON b0_.id = b4_.boardgame_id LEFT JOIN boardgame_file b5_ ON b0_.id = b5_.boardgame_id LEFT JOIN bgg_play_session b6_ ON b0_.id = b6_.boardgame_id WHERE b0_.slug = 'skyjo-action';

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.game_name AS game_name_5,
  t0.min_players AS min_players_6,
  t0.max_players AS max_players_7,
  t0.play_time AS play_time_8,
  t0.min_age AS min_age_9,
  t0.difficulty AS difficulty_10,
  t0.cover_image_filename AS cover_image_filename_11,
  t0.release_date AS release_date_12,
  t0.language AS language_13,
  t0.slug AS slug_14,
  t0.score AS score_15,
  t0.average_rating AS average_rating_16,
  t0.mise_en_place AS mise_en_place_17,
  t0.rejouabilite AS rejouabilite_18,
  t0.interactivite AS interactivite_19,
  t0.prise_en_main AS prise_en_main_20,
  t0.thematique AS thematique_21,
  t0.materiel AS materiel_22,
  t0.difficulte_description AS difficulte_description_23,
  t0.mise_en_place_description AS mise_en_place_description_24,
  t0.rejouabilite_description AS rejouabilite_description_25,
  t0.interactivite_description AS interactivite_description_26,
  t0.prise_en_main_description AS prise_en_main_description_27,
  t0.thematique_description AS thematique_description_28,
  t0.materiel_description AS materiel_description_29,
  t0.author_rating AS author_rating_30,
  t0.author_comment AS author_comment_31,
  t0.is_standalone_extension AS is_standalone_extension_32,
  t0.edition_name AS edition_name_33,
  t0.bgg_id AS bgg_id_34,
  t0.bgg_rank AS bgg_rank_35,
  t0.author_id AS author_id_36,
  t0.base_game_id AS base_game_id_37,
  t0.main_edition_id AS main_edition_id_38
FROM
  bgg_boardgame t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.game_name AS game_name_5, t0.min_players AS min_players_6, t0.max_players AS max_players_7, t0.play_time AS play_time_8, t0.min_age AS min_age_9, t0.difficulty AS difficulty_10, t0.cover_image_filename AS cover_image_filename_11, t0.release_date AS release_date_12, t0.language AS language_13, t0.slug AS slug_14, t0.score AS score_15, t0.average_rating AS average_rating_16, t0.mise_en_place AS mise_en_place_17, t0.rejouabilite AS rejouabilite_18, t0.interactivite AS interactivite_19, t0.prise_en_main AS prise_en_main_20, t0.thematique AS thematique_21, t0.materiel AS materiel_22, t0.difficulte_description AS difficulte_description_23, t0.mise_en_place_description AS mise_en_place_description_24, t0.rejouabilite_description AS rejouabilite_description_25, t0.interactivite_description AS interactivite_description_26, t0.prise_en_main_description AS prise_en_main_description_27, t0.thematique_description AS thematique_description_28, t0.materiel_description AS materiel_description_29, t0.author_rating AS author_rating_30, t0.author_comment AS author_comment_31, t0.is_standalone_extension AS is_standalone_extension_32, t0.edition_name AS edition_name_33, t0.bgg_id AS bgg_id_34, t0.bgg_rank AS bgg_rank_35, t0.author_id AS author_id_36, t0.base_game_id AS base_game_id_37, t0.main_edition_id AS main_edition_id_38 FROM bgg_boardgame t0 WHERE t0.slug = 'skyjo-action' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.game_name AS game_name_5,
  t0.min_players AS min_players_6,
  t0.max_players AS max_players_7,
  t0.play_time AS play_time_8,
  t0.min_age AS min_age_9,
  t0.difficulty AS difficulty_10,
  t0.cover_image_filename AS cover_image_filename_11,
  t0.release_date AS release_date_12,
  t0.language AS language_13,
  t0.slug AS slug_14,
  t0.score AS score_15,
  t0.average_rating AS average_rating_16,
  t0.mise_en_place AS mise_en_place_17,
  t0.rejouabilite AS rejouabilite_18,
  t0.interactivite AS interactivite_19,
  t0.prise_en_main AS prise_en_main_20,
  t0.thematique AS thematique_21,
  t0.materiel AS materiel_22,
  t0.difficulte_description AS difficulte_description_23,
  t0.mise_en_place_description AS mise_en_place_description_24,
  t0.rejouabilite_description AS rejouabilite_description_25,
  t0.interactivite_description AS interactivite_description_26,
  t0.prise_en_main_description AS prise_en_main_description_27,
  t0.thematique_description AS thematique_description_28,
  t0.materiel_description AS materiel_description_29,
  t0.author_rating AS author_rating_30,
  t0.author_comment AS author_comment_31,
  t0.is_standalone_extension AS is_standalone_extension_32,
  t0.edition_name AS edition_name_33,
  t0.bgg_id AS bgg_id_34,
  t0.bgg_rank AS bgg_rank_35,
  t0.author_id AS author_id_36,
  t0.base_game_id AS base_game_id_37,
  t0.main_edition_id AS main_edition_id_38
FROM
  bgg_boardgame t0
WHERE
  t0.main_edition_id = ?

SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.game_name AS game_name_5, t0.min_players AS min_players_6, t0.max_players AS max_players_7, t0.play_time AS play_time_8, t0.min_age AS min_age_9, t0.difficulty AS difficulty_10, t0.cover_image_filename AS cover_image_filename_11, t0.release_date AS release_date_12, t0.language AS language_13, t0.slug AS slug_14, t0.score AS score_15, t0.average_rating AS average_rating_16, t0.mise_en_place AS mise_en_place_17, t0.rejouabilite AS rejouabilite_18, t0.interactivite AS interactivite_19, t0.prise_en_main AS prise_en_main_20, t0.thematique AS thematique_21, t0.materiel AS materiel_22, t0.difficulte_description AS difficulte_description_23, t0.mise_en_place_description AS mise_en_place_description_24, t0.rejouabilite_description AS rejouabilite_description_25, t0.interactivite_description AS interactivite_description_26, t0.prise_en_main_description AS prise_en_main_description_27, t0.thematique_description AS thematique_description_28, t0.materiel_description AS materiel_description_29, t0.author_rating AS author_rating_30, t0.author_comment AS author_comment_31, t0.is_standalone_extension AS is_standalone_extension_32, t0.edition_name AS edition_name_33, t0.bgg_id AS bgg_id_34, t0.bgg_rank AS bgg_rank_35, t0.author_id AS author_id_36, t0.base_game_id AS base_game_id_37, t0.main_edition_id AS main_edition_id_38 FROM bgg_boardgame t0 WHERE t0.main_edition_id = 2;

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  bgg_forum_thread b0_
  INNER JOIN bgg_boardgame b1_ ON b0_.boardgame_id = b1_.id
WHERE
  b1_.id = ?

SELECT COUNT(b0_.id) AS sclr_0 FROM bgg_forum_thread b0_ INNER JOIN bgg_boardgame b1_ ON b0_.boardgame_id = b1_.id WHERE b1_.id = 2;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.game_name AS game_name_5,
  t0.min_players AS min_players_6,
  t0.max_players AS max_players_7,
  t0.play_time AS play_time_8,
  t0.min_age AS min_age_9,
  t0.difficulty AS difficulty_10,
  t0.cover_image_filename AS cover_image_filename_11,
  t0.release_date AS release_date_12,
  t0.language AS language_13,
  t0.slug AS slug_14,
  t0.score AS score_15,
  t0.average_rating AS average_rating_16,
  t0.mise_en_place AS mise_en_place_17,
  t0.rejouabilite AS rejouabilite_18,
  t0.interactivite AS interactivite_19,
  t0.prise_en_main AS prise_en_main_20,
  t0.thematique AS thematique_21,
  t0.materiel AS materiel_22,
  t0.difficulte_description AS difficulte_description_23,
  t0.mise_en_place_description AS mise_en_place_description_24,
  t0.rejouabilite_description AS rejouabilite_description_25,
  t0.interactivite_description AS interactivite_description_26,
  t0.prise_en_main_description AS prise_en_main_description_27,
  t0.thematique_description AS thematique_description_28,
  t0.materiel_description AS materiel_description_29,
  t0.author_rating AS author_rating_30,
  t0.author_comment AS author_comment_31,
  t0.is_standalone_extension AS is_standalone_extension_32,
  t0.edition_name AS edition_name_33,
  t0.bgg_id AS bgg_id_34,
  t0.bgg_rank AS bgg_rank_35,
  t0.author_id AS author_id_36,
  t0.base_game_id AS base_game_id_37,
  t0.main_edition_id AS main_edition_id_38
FROM
  bgg_boardgame t0
WHERE
  t0.base_game_id = ?

SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.game_name AS game_name_5, t0.min_players AS min_players_6, t0.max_players AS max_players_7, t0.play_time AS play_time_8, t0.min_age AS min_age_9, t0.difficulty AS difficulty_10, t0.cover_image_filename AS cover_image_filename_11, t0.release_date AS release_date_12, t0.language AS language_13, t0.slug AS slug_14, t0.score AS score_15, t0.average_rating AS average_rating_16, t0.mise_en_place AS mise_en_place_17, t0.rejouabilite AS rejouabilite_18, t0.interactivite AS interactivite_19, t0.prise_en_main AS prise_en_main_20, t0.thematique AS thematique_21, t0.materiel AS materiel_22, t0.difficulte_description AS difficulte_description_23, t0.mise_en_place_description AS mise_en_place_description_24, t0.rejouabilite_description AS rejouabilite_description_25, t0.interactivite_description AS interactivite_description_26, t0.prise_en_main_description AS prise_en_main_description_27, t0.thematique_description AS thematique_description_28, t0.materiel_description AS materiel_description_29, t0.author_rating AS author_rating_30, t0.author_comment AS author_comment_31, t0.is_standalone_extension AS is_standalone_extension_32, t0.edition_name AS edition_name_33, t0.bgg_id AS bgg_id_34, t0.bgg_rank AS bgg_rank_35, t0.author_id AS author_id_36, t0.base_game_id AS base_game_id_37, t0.main_edition_id AS main_edition_id_38 FROM bgg_boardgame t0 WHERE t0.base_game_id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  bgg_creator t0
  INNER JOIN bgg_boardgame_creator ON t0.id = bgg_boardgame_creator.creator_id
WHERE
  bgg_boardgame_creator.boardgame_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM bgg_creator t0 INNER JOIN bgg_boardgame_creator ON t0.id = bgg_boardgame_creator.creator_id WHERE bgg_boardgame_creator.boardgame_id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  bgg_illustrator t0
  INNER JOIN bgg_boardgame_illustrator ON t0.id = bgg_boardgame_illustrator.illustrator_id
WHERE
  bgg_boardgame_illustrator.boardgame_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM bgg_illustrator t0 INNER JOIN bgg_boardgame_illustrator ON t0.id = bgg_boardgame_illustrator.illustrator_id WHERE bgg_boardgame_illustrator.boardgame_id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  bgg_publisher t0
  INNER JOIN bgg_boardgame_publisher ON t0.id = bgg_boardgame_publisher.publisher_id
WHERE
  bgg_boardgame_publisher.boardgame_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM bgg_publisher t0 INNER JOIN bgg_boardgame_publisher ON t0.id = bgg_boardgame_publisher.publisher_id WHERE bgg_boardgame_publisher.boardgame_id = 2;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.title AS title_4,
  t0.description AS description_5,
  t0.uploaded_at AS uploaded_at_6,
  t0.updated_at AS updated_at_7,
  t0.boardgame_id AS boardgame_id_8,
  t0.uploaded_by_id AS uploaded_by_id_9
FROM
  bgg_boardgame_image t0
WHERE
  t0.boardgame_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.title AS title_4, t0.description AS description_5, t0.uploaded_at AS uploaded_at_6, t0.updated_at AS updated_at_7, t0.boardgame_id AS boardgame_id_8, t0.uploaded_by_id AS uploaded_by_id_9 FROM bgg_boardgame_image t0 WHERE t0.boardgame_id = 2;