Symfony Profiler

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1
FROM
  bgg_publisher b0_
WHERE
  b0_.id IN (?)

SELECT b0_.id AS id_0, b0_.name AS name_1 FROM bgg_publisher b0_ WHERE b0_.id IN ('12');

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1
FROM
  bgg_publisher b0_
WHERE
  b0_.id IN (?)

SELECT b0_.id AS id_0, b0_.name AS name_1 FROM bgg_publisher b0_ WHERE b0_.id IN ('12');

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      created_at_2
    FROM
      (
        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_.name AS name_58,
          b5_.id AS id_59,
          b5_.name AS name_60,
          b6_.id AS id_61,
          b6_.name AS name_62
        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_boardgame_creator b8_ ON b0_.id = b8_.boardgame_id
          LEFT JOIN bgg_creator b4_ ON b4_.id = b8_.creator_id
          LEFT JOIN bgg_boardgame_illustrator b9_ ON b0_.id = b9_.boardgame_id
          LEFT JOIN bgg_illustrator b5_ ON b5_.id = b9_.illustrator_id
          LEFT JOIN bgg_boardgame_publisher b10_ ON b0_.id = b10_.boardgame_id
          LEFT JOIN bgg_publisher b6_ ON b6_.id = b10_.publisher_id
        WHERE
          b6_.id IN (?)
      ) dctrn_result_inner
    ORDER BY
      created_at_2 DESC
  ) dctrn_result
LIMIT
  20

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_2 FROM (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_.name AS name_58, b5_.id AS id_59, b5_.name AS name_60, b6_.id AS id_61, b6_.name AS name_62 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_boardgame_creator b8_ ON b0_.id = b8_.boardgame_id LEFT JOIN bgg_creator b4_ ON b4_.id = b8_.creator_id LEFT JOIN bgg_boardgame_illustrator b9_ ON b0_.id = b9_.boardgame_id LEFT JOIN bgg_illustrator b5_ ON b5_.id = b9_.illustrator_id LEFT JOIN bgg_boardgame_publisher b10_ ON b0_.id = b10_.boardgame_id LEFT JOIN bgg_publisher b6_ ON b6_.id = b10_.publisher_id WHERE b6_.id IN (12)) dctrn_result_inner ORDER BY created_at_2 DESC) dctrn_result LIMIT 20;

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_.name AS name_58,
  b5_.id AS id_59,
  b5_.name AS name_60,
  b6_.id AS id_61,
  b6_.name AS name_62,
  b0_.author_id AS author_id_63,
  b0_.base_game_id AS base_game_id_64,
  b0_.main_edition_id AS main_edition_id_65,
  b2_.category_id AS category_id_66,
  b2_.main_tag_id AS main_tag_id_67
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_boardgame_creator b8_ ON b0_.id = b8_.boardgame_id
  LEFT JOIN bgg_creator b4_ ON b4_.id = b8_.creator_id
  LEFT JOIN bgg_boardgame_illustrator b9_ ON b0_.id = b9_.boardgame_id
  LEFT JOIN bgg_illustrator b5_ ON b5_.id = b9_.illustrator_id
  LEFT JOIN bgg_boardgame_publisher b10_ ON b0_.id = b10_.boardgame_id
  LEFT JOIN bgg_publisher b6_ ON b6_.id = b10_.publisher_id
WHERE
  b6_.id IN (?)
  AND b0_.id IN (?)
ORDER BY
  b0_.created_at DESC

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_.name AS name_58, b5_.id AS id_59, b5_.name AS name_60, b6_.id AS id_61, b6_.name AS name_62, b0_.author_id AS author_id_63, b0_.base_game_id AS base_game_id_64, b0_.main_edition_id AS main_edition_id_65, b2_.category_id AS category_id_66, b2_.main_tag_id AS main_tag_id_67 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_boardgame_creator b8_ ON b0_.id = b8_.boardgame_id LEFT JOIN bgg_creator b4_ ON b4_.id = b8_.creator_id LEFT JOIN bgg_boardgame_illustrator b9_ ON b0_.id = b9_.boardgame_id LEFT JOIN bgg_illustrator b5_ ON b5_.id = b9_.illustrator_id LEFT JOIN bgg_boardgame_publisher b10_ ON b0_.id = b10_.boardgame_id LEFT JOIN bgg_publisher b6_ ON b6_.id = b10_.publisher_id WHERE b6_.id IN (12) AND b0_.id IN (1) ORDER BY b0_.created_at DESC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        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_.name AS name_58,
          b5_.id AS id_59,
          b5_.name AS name_60,
          b6_.id AS id_61,
          b6_.name AS name_62
        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_boardgame_creator b8_ ON b0_.id = b8_.boardgame_id
          LEFT JOIN bgg_creator b4_ ON b4_.id = b8_.creator_id
          LEFT JOIN bgg_boardgame_illustrator b9_ ON b0_.id = b9_.boardgame_id
          LEFT JOIN bgg_illustrator b5_ ON b5_.id = b9_.illustrator_id
          LEFT JOIN bgg_boardgame_publisher b10_ ON b0_.id = b10_.boardgame_id
          LEFT JOIN bgg_publisher b6_ ON b6_.id = b10_.publisher_id
        WHERE
          b6_.id IN (?)
        ORDER BY
          b0_.created_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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_.name AS name_58, b5_.id AS id_59, b5_.name AS name_60, b6_.id AS id_61, b6_.name AS name_62 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_boardgame_creator b8_ ON b0_.id = b8_.boardgame_id LEFT JOIN bgg_creator b4_ ON b4_.id = b8_.creator_id LEFT JOIN bgg_boardgame_illustrator b9_ ON b0_.id = b9_.boardgame_id LEFT JOIN bgg_illustrator b5_ ON b5_.id = b9_.illustrator_id LEFT JOIN bgg_boardgame_publisher b10_ ON b0_.id = b10_.boardgame_id LEFT JOIN bgg_publisher b6_ ON b6_.id = b10_.publisher_id WHERE b6_.id IN (12) ORDER BY b0_.created_at DESC) dctrn_result) dctrn_table;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1
FROM
  bgg_creator b0_

SELECT b0_.id AS id_0, b0_.name AS name_1 FROM bgg_creator b0_;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1
FROM
  bgg_illustrator b0_

SELECT b0_.id AS id_0, b0_.name AS name_1 FROM bgg_illustrator b0_;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1
FROM
  bgg_publisher b0_

SELECT b0_.id AS id_0, b0_.name AS name_1 FROM bgg_publisher b0_;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.category_id AS category_id_2,
  b0_.main_tag_id AS main_tag_id_3
FROM
  bgg_tag b0_

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.category_id AS category_id_2, b0_.main_tag_id AS main_tag_id_3 FROM bgg_tag b0_;

SELECT
  t0.id AS id_1,
  t0.rating AS rating_2,
  t0.comment AS comment_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.boardgame_id AS boardgame_id_6,
  t0.author_id AS author_id_7
FROM
  bgg_review t0
WHERE
  t0.boardgame_id = ?

SELECT t0.id AS id_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.boardgame_id AS boardgame_id_6, t0.author_id AS author_id_7 FROM bgg_review t0 WHERE t0.boardgame_id = 1;