Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

3.30 ms Query time

0 Invalid entities

4 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.46 ms

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_ ORDER BY b0_.created_at DESC LIMIT 6

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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_
ORDER BY
  b0_.created_at DESC
LIMIT
  6

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_ ORDER BY b0_.created_at DESC LIMIT 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 364)
7	App\Repository\Boardgame\BoardgameRepository->findLatest (line 26)
8	App\Controller\MainController->index (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.21 ms

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, MAX(b1_.created_at) AS sclr_35, b0_.author_id AS author_id_36, b0_.base_game_id AS base_game_id_37, b0_.main_edition_id AS main_edition_id_38 FROM bgg_boardgame b0_ INNER JOIN bgg_review b1_ ON b0_.id = b1_.boardgame_id GROUP BY b0_.id ORDER BY sclr_35 DESC LIMIT 6

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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,
  MAX(b1_.created_at) AS sclr_35,
  b0_.author_id AS author_id_36,
  b0_.base_game_id AS base_game_id_37,
  b0_.main_edition_id AS main_edition_id_38
FROM
  bgg_boardgame b0_
  INNER JOIN bgg_review b1_ ON b0_.id = b1_.boardgame_id
GROUP BY
  b0_.id
ORDER BY
  sclr_35 DESC
LIMIT
  6

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, MAX(b1_.created_at) AS sclr_35, b0_.author_id AS author_id_36, b0_.base_game_id AS base_game_id_37, b0_.main_edition_id AS main_edition_id_38 FROM bgg_boardgame b0_ INNER JOIN bgg_review b1_ ON b0_.id = b1_.boardgame_id GROUP BY b0_.id ORDER BY sclr_35 DESC LIMIT 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 380)
7	App\Repository\Boardgame\BoardgameRepository->findRecentlyReviewed (line 27)
8	App\Controller\MainController->index (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.63 ms

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.created_at AS created_at_3, b0_.updated_at AS updated_at_4, MAX(b1_.created_at) AS sclr_5, b0_.boardgame_id AS boardgame_id_6, b0_.category_id AS category_id_7, b0_.author_id AS author_id_8 FROM bgg_forum_thread b0_ LEFT JOIN bgg_forum_post b1_ ON b0_.id = b1_.thread_id GROUP BY b0_.id ORDER BY sclr_5 DESC LIMIT 5

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.slug AS slug_2,
  b0_.created_at AS created_at_3,
  b0_.updated_at AS updated_at_4,
  MAX(b1_.created_at) AS sclr_5,
  b0_.boardgame_id AS boardgame_id_6,
  b0_.category_id AS category_id_7,
  b0_.author_id AS author_id_8
FROM
  bgg_forum_thread b0_
  LEFT JOIN bgg_forum_post b1_ ON b0_.id = b1_.thread_id
GROUP BY
  b0_.id
ORDER BY
  sclr_5 DESC
LIMIT
  5

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.created_at AS created_at_3, b0_.updated_at AS updated_at_4, MAX(b1_.created_at) AS sclr_5, b0_.boardgame_id AS boardgame_id_6, b0_.category_id AS category_id_7, b0_.author_id AS author_id_8 FROM bgg_forum_thread b0_ LEFT JOIN bgg_forum_post b1_ ON b0_.id = b1_.thread_id GROUP BY b0_.id ORDER BY sclr_5 DESC LIMIT 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 112)
7	App\Repository\Boardgame\ForumThreadRepository->findMostActive (line 28)
8	App\Controller\MainController->index (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Boardgame\Boardgame	3
App\Entity\Users	1

Entities Mapping

Class	Mapping errors
App\Entity\Boardgame\Boardgame	No errors.
App\Entity\Users	No errors.
App\Entity\Boardgame\Creator	No errors.
App\Entity\Boardgame\Illustrator	No errors.
App\Entity\Boardgame\Publisher	No errors.
App\Entity\Boardgame\Tag	No errors.
App\Entity\Boardgame\Review	No errors.
App\Entity\Boardgame\ForumThread	No errors.
App\Entity\Boardgame\BoardgameFile	No errors.
App\Entity\Boardgame\BgCollection	No errors.
App\Entity\Boardgame\PlaySession	No errors.
App\Entity\Boardgame\BoardgameImage	No errors.
App\Entity\Boardgame\ForumPost	No errors.
App\Entity\Boardgame\ForumCategory	No errors.

Symfony Profiler

GET https://jeux.sifflote.fr/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping