Symfony Profiler

Query Metrics

6 Database Queries

5 Different statements

5.59 ms Query time

0 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.25 ms
(40.27%)

SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.title AS title_2, p0_.description AS description_3, p0_.content AS content_4, p0_.publication_date AS publication_date_5, p0_.visits_count AS visits_count_6, p0_.video_url AS video_url_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.deleted_at AS deleted_at_10, p0_.deleted AS deleted_11, p0_.category AS category_12 FROM article_category a1_, page p0_ INNER JOIN article_category a2_ ON p0_.category = a2_.id WHERE a2_.id = ? ORDER BY p0_.publication_date DESC LIMIT 5

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.type AS type_1,
  p0_.title AS title_2,
  p0_.description AS description_3,
  p0_.content AS content_4,
  p0_.publication_date AS publication_date_5,
  p0_.visits_count AS visits_count_6,
  p0_.video_url AS video_url_7,
  p0_.created_at AS created_at_8,
  p0_.updated_at AS updated_at_9,
  p0_.deleted_at AS deleted_at_10,
  p0_.deleted AS deleted_11,
  p0_.category AS category_12
FROM
  article_category a1_,
  page p0_
  INNER JOIN article_category a2_ ON p0_.category = a2_.id
WHERE
  a2_.id = ?
ORDER BY
  p0_.publication_date DESC
LIMIT
  5

SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.title AS title_2, p0_.description AS description_3, p0_.content AS content_4, p0_.publication_date AS publication_date_5, p0_.visits_count AS visits_count_6, p0_.video_url AS video_url_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.deleted_at AS deleted_at_10, p0_.deleted AS deleted_11, p0_.category AS category_12 FROM article_category a1_, page p0_ INNER JOIN article_category a2_ ON p0_.category = a2_.id WHERE a2_.id = 2 ORDER BY p0_.publication_date 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\Page\ArticleCategoryRepository->findLastCategoryArticles (line 34)
7	App\Controller\ArticlesController->categories (line 91)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
12	frankenphp_handle_request (line 45)
13	Runtime\FrankenPhpSymfony\Runner::run (line 45)
14	require_once (line 32)
15	require_once (line 5)

2.01 ms
(35.93%)

SELECT p0_.id AS id_0, p0_.is_enabled AS is_enabled_1, p0_.is_default AS is_default_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.deleted_at AS deleted_at_5, p0_.deleted AS deleted_6, p0_.original_filename AS original_filename_7, p0_.path AS path_8, p0_.mime_type AS mime_type_9, p0_.alt AS alt_10, p0_.size AS size_11, p0_.file_updated_at AS file_updated_at_12, p0_.page_id AS page_id_13 FROM page p1_, page_media p0_ WHERE p0_.page_id = ? AND p0_.is_enabled = true AND p0_.is_default = true LIMIT 1

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.is_enabled AS is_enabled_1,
  p0_.is_default AS is_default_2,
  p0_.created_at AS created_at_3,
  p0_.updated_at AS updated_at_4,
  p0_.deleted_at AS deleted_at_5,
  p0_.deleted AS deleted_6,
  p0_.original_filename AS original_filename_7,
  p0_.path AS path_8,
  p0_.mime_type AS mime_type_9,
  p0_.alt AS alt_10,
  p0_.size AS size_11,
  p0_.file_updated_at AS file_updated_at_12,
  p0_.page_id AS page_id_13
FROM
  page p1_,
  page_media p0_
WHERE
  p0_.page_id = ?
  AND p0_.is_enabled = true
  AND p0_.is_default = true
LIMIT
  1

SELECT p0_.id AS id_0, p0_.is_enabled AS is_enabled_1, p0_.is_default AS is_default_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.deleted_at AS deleted_at_5, p0_.deleted AS deleted_6, p0_.original_filename AS original_filename_7, p0_.path AS path_8, p0_.mime_type AS mime_type_9, p0_.alt AS alt_10, p0_.size AS size_11, p0_.file_updated_at AS file_updated_at_12, p0_.page_id AS page_id_13 FROM page p1_, page_media p0_ WHERE p0_.page_id = 7 AND p0_.is_enabled = true AND p0_.is_default = true LIMIT 1;

#	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->getOneOrNullResult (line 737)
6	App\Repository\Page\PageRepository->findDefaultMedia (line 49)
7	App\Controller\ArticlesController->categories (line 96)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
12	frankenphp_handle_request (line 45)
13	Runtime\FrankenPhpSymfony\Runner::run (line 45)
14	require_once (line 32)
15	require_once (line 5)

0.59 ms
(10.46%)

SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.title AS title_2, p0_.description AS description_3, p0_.content AS content_4, p0_.publication_date AS publication_date_5, p0_.visits_count AS visits_count_6, p0_.video_url AS video_url_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.deleted_at AS deleted_at_10, p0_.deleted AS deleted_11, p0_.category AS category_12 FROM page p0_ WHERE p0_.type = ? ORDER BY p0_.created_at DESC LIMIT 5

Parameters:

[
  "article"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.type AS type_1,
  p0_.title AS title_2,
  p0_.description AS description_3,
  p0_.content AS content_4,
  p0_.publication_date AS publication_date_5,
  p0_.visits_count AS visits_count_6,
  p0_.video_url AS video_url_7,
  p0_.created_at AS created_at_8,
  p0_.updated_at AS updated_at_9,
  p0_.deleted_at AS deleted_at_10,
  p0_.deleted AS deleted_11,
  p0_.category AS category_12
FROM
  page p0_
WHERE
  p0_.type = ?
ORDER BY
  p0_.created_at DESC
LIMIT
  5

SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.title AS title_2, p0_.description AS description_3, p0_.content AS content_4, p0_.publication_date AS publication_date_5, p0_.visits_count AS visits_count_6, p0_.video_url AS video_url_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.deleted_at AS deleted_at_10, p0_.deleted AS deleted_11, p0_.category AS category_12 FROM page p0_ WHERE p0_.type = 'article' ORDER BY p0_.created_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\Page\PageRepository->findAllArticles (line 32)
7	App\Service\ArticlesService->getCategoriesAndRecentArticles (line 55)
8	App\Controller\ArticlesController->categories (line 107)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
13	frankenphp_handle_request (line 45)
14	Runtime\FrankenPhpSymfony\Runner::run (line 45)
15	require_once (line 32)
16	require_once (line 5)

0.48 ms
(8.54%)

SELECT a0_.id AS id_0, a0_.label AS label_1, a0_.created_at AS created_at_2, a0_.updated_at AS updated_at_3, a0_.deleted_at AS deleted_at_4, a0_.deleted AS deleted_5, a0_.parent_category AS parent_category_6 FROM article_category a0_ WHERE a0_.parent_category IS NULL AND LOWER(a0_.label) <> ? ORDER BY a0_.label ASC

Parameters:

[
  "autre"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.label AS label_1,
  a0_.created_at AS created_at_2,
  a0_.updated_at AS updated_at_3,
  a0_.deleted_at AS deleted_at_4,
  a0_.deleted AS deleted_5,
  a0_.parent_category AS parent_category_6
FROM
  article_category a0_
WHERE
  a0_.parent_category IS NULL
  AND LOWER(a0_.label) <> ?
ORDER BY
  a0_.label ASC

SELECT a0_.id AS id_0, a0_.label AS label_1, a0_.created_at AS created_at_2, a0_.updated_at AS updated_at_3, a0_.deleted_at AS deleted_at_4, a0_.deleted AS deleted_5, a0_.parent_category AS parent_category_6 FROM article_category a0_ WHERE a0_.parent_category IS NULL AND LOWER(a0_.label) <> 'autre' ORDER BY a0_.label ASC;

#	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\Page\ArticleCategoryRepository->findDefaultCategories (line 45)
7	App\Service\ArticlesService->getCategoriesAndRecentArticles (line 62)
8	App\Controller\ArticlesController->categories (line 107)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
13	frankenphp_handle_request (line 45)
14	Runtime\FrankenPhpSymfony\Runner::run (line 45)
15	require_once (line 32)
16	require_once (line 5)

0.27 ms
(4.79%)

SELECT a0_.id AS id_0, a0_.label AS label_1, a0_.created_at AS created_at_2, a0_.updated_at AS updated_at_3, a0_.deleted_at AS deleted_at_4, a0_.deleted AS deleted_5, a0_.parent_category AS parent_category_6 FROM article_category a0_ WHERE LOWER(a0_.label) = ? LIMIT 1

Parameters:

[
  "autre"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.label AS label_1,
  a0_.created_at AS created_at_2,
  a0_.updated_at AS updated_at_3,
  a0_.deleted_at AS deleted_at_4,
  a0_.deleted AS deleted_5,
  a0_.parent_category AS parent_category_6
FROM
  article_category a0_
WHERE
  LOWER(a0_.label) = ?
LIMIT
  1

SELECT a0_.id AS id_0, a0_.label AS label_1, a0_.created_at AS created_at_2, a0_.updated_at AS updated_at_3, a0_.deleted_at AS deleted_at_4, a0_.deleted AS deleted_5, a0_.parent_category AS parent_category_6 FROM article_category a0_ WHERE LOWER(a0_.label) = 'autre' LIMIT 1;

#	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->getOneOrNullResult (line 737)
6	App\Service\ArticlesService->getOrCreateOtherCategory (line 32)
7	App\Service\ArticlesService->getCategoriesAndRecentArticles (line 69)
8	App\Controller\ArticlesController->categories (line 107)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
13	frankenphp_handle_request (line 45)
14	Runtime\FrankenPhpSymfony\Runner::run (line 45)
15	require_once (line 32)
16	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\Page\Page	3
App\Entity\Page\ArticleCategory	2
App\Entity\Page\Media	2

Entities Mapping

Class	Mapping errors
App\Entity\Security\User	No errors.
App\Entity\Geo\City	No errors.
App\Entity\Geo\Region	No errors.
App\Entity\Geo\Department	No errors.
App\Entity\Module\Module	No errors.
App\Entity\Module\Tag	No errors.
App\Entity\Contact\Contact	No errors.
App\Entity\Common\Hours	No errors.
App\Entity\Common\Address	No errors.
App\Entity\LegalUnit\NafCode	No errors.
App\Entity\LegalUnit\NaturalPerson	No errors.
App\Entity\LegalUnit\Establishment	No errors.
App\Entity\LegalUnit\Profile\Faq	No errors.
App\Entity\LegalUnit\Profile\SocietyProfile	No errors.
App\Entity\LegalUnit\Profile\Product	No errors.
App\Entity\LegalUnit\Profile\SpecialHours	No errors.
App\Entity\LegalUnit\Profile\Logo	No errors.
App\Entity\LegalUnit\LegalUnit	No errors.
App\Entity\Page\ArticleCategory	No errors.
App\Entity\Page\Page	No errors.
App\Entity\Page\Media	No errors.
Zhortein\AuditableBundle\Entity\AuditEntry	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://bbernier.devlogiciel.com/actualites/categorie/2-Autre

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping