Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• VichUploader
• EasyAdmin
• Configuration

Query Metrics

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, b0_.author_id AS author_id_35, b0_.base_game_id AS base_game_id_36, b0_.main_edition_id AS main_edition_id_37 FROM bgg_boardgame b0_ WHERE (SELECT COUNT(*) FROM bgg_review b1_ WHERE b1_.boardgame_id = b0_.id) >= ? ORDER BY b0_.average_rating DESC, (SELECT COUNT(*) FROM bgg_review b1_ WHERE b1_.boardgame_id = b0_.id) DESC LIMIT 12

[
  2
]

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,
  b0_.author_id AS author_id_35,
  b0_.base_game_id AS base_game_id_36,
  b0_.main_edition_id AS main_edition_id_37
FROM
  bgg_boardgame b0_
WHERE
  (
    SELECT
      COUNT(*)
    FROM
      bgg_review b1_
    WHERE
      b1_.boardgame_id = b0_.id
  ) >= ?
ORDER BY
  b0_.average_rating DESC,
  (
    SELECT
      COUNT(*)
    FROM
      bgg_review b1_
    WHERE
      b1_.boardgame_id = b0_.id
  ) DESC
LIMIT
  12

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, b0_.author_id AS author_id_35, b0_.base_game_id AS base_game_id_36, b0_.main_edition_id AS main_edition_id_37 FROM bgg_boardgame b0_ WHERE (SELECT COUNT(*) FROM bgg_review b1_ WHERE b1_.boardgame_id = b0_.id) >= 2 ORDER BY b0_.average_rating DESC, (SELECT COUNT(*) FROM bgg_review b1_ WHERE b1_.boardgame_id = b0_.id) DESC LIMIT 12;