Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

4.59 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.82 ms
(61.43%)

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.excerpt AS excerpt_3, b0_.content AS content_4, b0_.featured_image AS featured_image_5, b0_.image_alt AS image_alt_6, b0_.published AS published_7, b0_.created_at AS created_at_8, b0_.updated_at AS updated_at_9, b0_.published_at AS published_at_10, b0_.meta_title AS meta_title_11, b0_.meta_description AS meta_description_12, b0_.meta_keywords AS meta_keywords_13, b0_.canonical_url AS canonical_url_14, b0_.tags AS tags_15, b0_.category AS category_16, b0_.reading_time AS reading_time_17, b0_.views AS views_18, b0_.author AS author_19, b0_.structured_data AS structured_data_20 FROM blog_posts b0_ WHERE b0_.published = ? ORDER BY b0_.published_at DESC

Parameters:

[
  1
]

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_.excerpt AS excerpt_3,
  b0_.content AS content_4,
  b0_.featured_image AS featured_image_5,
  b0_.image_alt AS image_alt_6,
  b0_.published AS published_7,
  b0_.created_at AS created_at_8,
  b0_.updated_at AS updated_at_9,
  b0_.published_at AS published_at_10,
  b0_.meta_title AS meta_title_11,
  b0_.meta_description AS meta_description_12,
  b0_.meta_keywords AS meta_keywords_13,
  b0_.canonical_url AS canonical_url_14,
  b0_.tags AS tags_15,
  b0_.category AS category_16,
  b0_.reading_time AS reading_time_17,
  b0_.views AS views_18,
  b0_.author AS author_19,
  b0_.structured_data AS structured_data_20
FROM
  blog_posts b0_
WHERE
  b0_.published = ?
ORDER BY
  b0_.published_at DESC

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.excerpt AS excerpt_3, b0_.content AS content_4, b0_.featured_image AS featured_image_5, b0_.image_alt AS image_alt_6, b0_.published AS published_7, b0_.created_at AS created_at_8, b0_.updated_at AS updated_at_9, b0_.published_at AS published_at_10, b0_.meta_title AS meta_title_11, b0_.meta_description AS meta_description_12, b0_.meta_keywords AS meta_keywords_13, b0_.canonical_url AS canonical_url_14, b0_.tags AS tags_15, b0_.category AS category_16, b0_.reading_time AS reading_time_17, b0_.views AS views_18, b0_.author AS author_19, b0_.structured_data AS structured_data_20 FROM blog_posts b0_ WHERE b0_.published = 1 ORDER BY b0_.published_at DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\BlogPostRepository->findPublished (line 30)
7	App\Controller\BlogController->index (line 40)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.63 ms
(13.68%)

SELECT DISTINCT b0_.category AS category_0 FROM blog_posts b0_ WHERE b0_.published = ? AND b0_.category IS NOT NULL

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT b0_.category AS category_0
FROM
  blog_posts b0_
WHERE
  b0_.published = ?
  AND b0_.category IS NOT NULL

SELECT DISTINCT b0_.category AS category_0 FROM blog_posts b0_ WHERE b0_.published = 1 AND b0_.category IS NOT NULL;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	App\Repository\BlogPostRepository->getCategories (line 125)
7	App\Controller\BlogController->index (line 45)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.43 ms
(9.35%)

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.excerpt AS excerpt_3, b0_.content AS content_4, b0_.featured_image AS featured_image_5, b0_.image_alt AS image_alt_6, b0_.published AS published_7, b0_.created_at AS created_at_8, b0_.updated_at AS updated_at_9, b0_.published_at AS published_at_10, b0_.meta_title AS meta_title_11, b0_.meta_description AS meta_description_12, b0_.meta_keywords AS meta_keywords_13, b0_.canonical_url AS canonical_url_14, b0_.tags AS tags_15, b0_.category AS category_16, b0_.reading_time AS reading_time_17, b0_.views AS views_18, b0_.author AS author_19, b0_.structured_data AS structured_data_20 FROM blog_posts b0_ WHERE b0_.published = ? ORDER BY b0_.views DESC LIMIT 5

Parameters:

[
  1
]

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_.excerpt AS excerpt_3,
  b0_.content AS content_4,
  b0_.featured_image AS featured_image_5,
  b0_.image_alt AS image_alt_6,
  b0_.published AS published_7,
  b0_.created_at AS created_at_8,
  b0_.updated_at AS updated_at_9,
  b0_.published_at AS published_at_10,
  b0_.meta_title AS meta_title_11,
  b0_.meta_description AS meta_description_12,
  b0_.meta_keywords AS meta_keywords_13,
  b0_.canonical_url AS canonical_url_14,
  b0_.tags AS tags_15,
  b0_.category AS category_16,
  b0_.reading_time AS reading_time_17,
  b0_.views AS views_18,
  b0_.author AS author_19,
  b0_.structured_data AS structured_data_20
FROM
  blog_posts b0_
WHERE
  b0_.published = ?
ORDER BY
  b0_.views DESC
LIMIT
  5

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.excerpt AS excerpt_3, b0_.content AS content_4, b0_.featured_image AS featured_image_5, b0_.image_alt AS image_alt_6, b0_.published AS published_7, b0_.created_at AS created_at_8, b0_.updated_at AS updated_at_9, b0_.published_at AS published_at_10, b0_.meta_title AS meta_title_11, b0_.meta_description AS meta_description_12, b0_.meta_keywords AS meta_keywords_13, b0_.canonical_url AS canonical_url_14, b0_.tags AS tags_15, b0_.category AS category_16, b0_.reading_time AS reading_time_17, b0_.views AS views_18, b0_.author AS author_19, b0_.structured_data AS structured_data_20 FROM blog_posts b0_ WHERE b0_.published = 1 ORDER BY b0_.views DESC LIMIT 5;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\BlogPostRepository->findPopular (line 103)
7	App\Controller\BlogController->index (line 47)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.38 ms
(8.17%)

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.excerpt AS excerpt_3, b0_.content AS content_4, b0_.featured_image AS featured_image_5, b0_.image_alt AS image_alt_6, b0_.published AS published_7, b0_.created_at AS created_at_8, b0_.updated_at AS updated_at_9, b0_.published_at AS published_at_10, b0_.meta_title AS meta_title_11, b0_.meta_description AS meta_description_12, b0_.meta_keywords AS meta_keywords_13, b0_.canonical_url AS canonical_url_14, b0_.tags AS tags_15, b0_.category AS category_16, b0_.reading_time AS reading_time_17, b0_.views AS views_18, b0_.author AS author_19, b0_.structured_data AS structured_data_20 FROM blog_posts b0_ WHERE b0_.published = ? ORDER BY b0_.published_at DESC LIMIT 5

Parameters:

[
  1
]

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_.excerpt AS excerpt_3,
  b0_.content AS content_4,
  b0_.featured_image AS featured_image_5,
  b0_.image_alt AS image_alt_6,
  b0_.published AS published_7,
  b0_.created_at AS created_at_8,
  b0_.updated_at AS updated_at_9,
  b0_.published_at AS published_at_10,
  b0_.meta_title AS meta_title_11,
  b0_.meta_description AS meta_description_12,
  b0_.meta_keywords AS meta_keywords_13,
  b0_.canonical_url AS canonical_url_14,
  b0_.tags AS tags_15,
  b0_.category AS category_16,
  b0_.reading_time AS reading_time_17,
  b0_.views AS views_18,
  b0_.author AS author_19,
  b0_.structured_data AS structured_data_20
FROM
  blog_posts b0_
WHERE
  b0_.published = ?
ORDER BY
  b0_.published_at DESC
LIMIT
  5

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.excerpt AS excerpt_3, b0_.content AS content_4, b0_.featured_image AS featured_image_5, b0_.image_alt AS image_alt_6, b0_.published AS published_7, b0_.created_at AS created_at_8, b0_.updated_at AS updated_at_9, b0_.published_at AS published_at_10, b0_.meta_title AS meta_title_11, b0_.meta_description AS meta_description_12, b0_.meta_keywords AS meta_keywords_13, b0_.canonical_url AS canonical_url_14, b0_.tags AS tags_15, b0_.category AS category_16, b0_.reading_time AS reading_time_17, b0_.views AS views_18, b0_.author AS author_19, b0_.structured_data AS structured_data_20 FROM blog_posts b0_ WHERE b0_.published = 1 ORDER BY b0_.published_at DESC LIMIT 5;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\BlogPostRepository->findRecent (line 114)
7	App\Controller\BlogController->index (line 48)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.34 ms
(7.37%)

SELECT b0_.tags AS tags_0 FROM blog_posts b0_ WHERE b0_.published = ? AND b0_.tags IS NOT NULL

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.tags AS tags_0
FROM
  blog_posts b0_
WHERE
  b0_.published = ?
  AND b0_.tags IS NOT NULL

SELECT b0_.tags AS tags_0 FROM blog_posts b0_ WHERE b0_.published = 1 AND b0_.tags IS NOT NULL;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\BlogPostRepository->getAllTags (line 138)
7	App\Controller\BlogController->index (line 46)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (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

Entities Mapping

Class	Mapping errors
App\Entity\BlogPost	No errors.

Symfony Profiler

GET https://macssolution.fr/blog

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping