Symfony Profiler

Query Metrics

4 Database Queries

2 Different statements

2.13 ms Query time

0 Invalid entities

8 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.62 ms

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\Controller\ArticlesController->actualities (line 65)
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.61 ms

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:

[
  1
]

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 = 1 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->{closure:App\Controller\ArticlesController::actualities():67} (line 68)
8	array_map (line 67)
9	App\Controller\ArticlesController::actualities (line 67)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
14	frankenphp_handle_request (line 45)
15	Runtime\FrankenPhpSymfony\Runner::run (line 45)
16	require_once (line 32)
17	require_once (line 5)

0.38 ms

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:

[
  9
]

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 = 9 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->{closure:App\Controller\ArticlesController::actualities():67} (line 68)
8	array_map (line 67)
9	App\Controller\ArticlesController::actualities (line 67)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
14	frankenphp_handle_request (line 45)
15	Runtime\FrankenPhpSymfony\Runner::run (line 45)
16	require_once (line 32)
17	require_once (line 5)

0.52 ms

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->{closure:App\Controller\ArticlesController::actualities():67} (line 68)
8	array_map (line 67)
9	App\Controller\ArticlesController::actualities (line 67)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
14	frankenphp_handle_request (line 45)
15	Runtime\FrankenPhpSymfony\Runner::run (line 45)
16	require_once (line 32)
17	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\Media	3
App\Entity\Page\ArticleCategory	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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping