Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.53 ms Query time

0 Invalid entities

43 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.61 ms
(39.98%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.price AS price_3, p0_.billing_cycle AS billing_cycle_4, p0_.is_active AS is_active_5, p0_.position AS position_6, p1_.id AS id_7, p1_.label AS label_8, p1_.position AS position_9, p1_.pack_id AS pack_id_10 FROM pack p0_ LEFT JOIN pack_feature p1_ ON p0_.id = p1_.pack_id WHERE p0_.is_active = 1 ORDER BY p0_.position ASC, p1_.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.description AS description_2,
  p0_.price AS price_3,
  p0_.billing_cycle AS billing_cycle_4,
  p0_.is_active AS is_active_5,
  p0_.position AS position_6,
  p1_.id AS id_7,
  p1_.label AS label_8,
  p1_.position AS position_9,
  p1_.pack_id AS pack_id_10
FROM
  pack p0_
  LEFT JOIN pack_feature p1_ ON p0_.id = p1_.pack_id
WHERE
  p0_.is_active = 1
ORDER BY
  p0_.position ASC,
  p1_.position ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.price AS price_3, p0_.billing_cycle AS billing_cycle_4, p0_.is_active AS is_active_5, p0_.position AS position_6, p1_.id AS id_7, p1_.label AS label_8, p1_.position AS position_9, p1_.pack_id AS pack_id_10 FROM pack p0_ LEFT JOIN pack_feature p1_ ON p0_.id = p1_.pack_id WHERE p0_.is_active = 1 ORDER BY p0_.position ASC, p1_.position 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\PackRepository->findActive (line 18)
7	App\Service\SiteDataService->{closure:App\Service\SiteDataService::getActivePacks():98} (line 100)
8	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
9	Symfony\Component\Cache\LockRegistry->compute (line 111)
10	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 67)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
14	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
15	App\Service\SiteDataService->getActivePacks (line 98)
16	App\Controller\HomeController->index (line 68)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0.38 ms
(24.90%)

SELECT f0_.id AS id_0, f0_.icon AS icon_1, f0_.title AS title_2, f0_.duration AS duration_3, f0_.price AS price_4, f0_.description AS description_5, f0_.color AS color_6, f0_.is_published AS is_published_7, f0_.position AS position_8 FROM formation f0_ WHERE f0_.is_published = 1 ORDER BY f0_.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.icon AS icon_1,
  f0_.title AS title_2,
  f0_.duration AS duration_3,
  f0_.price AS price_4,
  f0_.description AS description_5,
  f0_.color AS color_6,
  f0_.is_published AS is_published_7,
  f0_.position AS position_8
FROM
  formation f0_
WHERE
  f0_.is_published = 1
ORDER BY
  f0_.position ASC

SELECT f0_.id AS id_0, f0_.icon AS icon_1, f0_.title AS title_2, f0_.duration AS duration_3, f0_.price AS price_4, f0_.description AS description_5, f0_.color AS color_6, f0_.is_published AS is_published_7, f0_.position AS position_8 FROM formation f0_ WHERE f0_.is_published = 1 ORDER BY f0_.position 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\FormationRepository->findPublished (line 17)
7	App\Service\SiteDataService->{closure:App\Service\SiteDataService::getPublishedFormations():88} (line 90)
8	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
9	Symfony\Component\Cache\LockRegistry->compute (line 111)
10	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 67)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
14	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
15	App\Service\SiteDataService->getPublishedFormations (line 88)
16	App\Controller\HomeController->index (line 67)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0.34 ms
(22.40%)

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_.image_path AS image_path_5, b0_.image_alt AS image_alt_6, b0_.status AS status_7, b0_.published_at AS published_at_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.meta_title AS meta_title_11, b0_.meta_description AS meta_description_12, b0_.read_time AS read_time_13, b0_.view_count AS view_count_14, b1_.id AS id_15, b1_.name AS name_16, b1_.slug AS slug_17, b1_.position AS position_18, u2_.id AS id_19, u2_.email AS email_20, u2_.roles AS roles_21, u2_.password AS password_22, u2_.first_name AS first_name_23, u2_.last_name AS last_name_24, u2_.is_active AS is_active_25, u2_.created_at AS created_at_26, b0_.category_id AS category_id_27, b0_.author_id AS author_id_28 FROM blog_post b0_ LEFT JOIN blog_category b1_ ON b0_.category_id = b1_.id LEFT JOIN `user` u2_ ON b0_.author_id = u2_.id WHERE b0_.status = ? ORDER BY b0_.published_at DESC LIMIT 3

Parameters:

[
  "published"
]

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_.image_path AS image_path_5,
  b0_.image_alt AS image_alt_6,
  b0_.status AS status_7,
  b0_.published_at AS published_at_8,
  b0_.created_at AS created_at_9,
  b0_.updated_at AS updated_at_10,
  b0_.meta_title AS meta_title_11,
  b0_.meta_description AS meta_description_12,
  b0_.read_time AS read_time_13,
  b0_.view_count AS view_count_14,
  b1_.id AS id_15,
  b1_.name AS name_16,
  b1_.slug AS slug_17,
  b1_.position AS position_18,
  u2_.id AS id_19,
  u2_.email AS email_20,
  u2_.roles AS roles_21,
  u2_.password AS password_22,
  u2_.first_name AS first_name_23,
  u2_.last_name AS last_name_24,
  u2_.is_active AS is_active_25,
  u2_.created_at AS created_at_26,
  b0_.category_id AS category_id_27,
  b0_.author_id AS author_id_28
FROM
  blog_post b0_
  LEFT JOIN blog_category b1_ ON b0_.category_id = b1_.id
  LEFT JOIN `user` u2_ ON b0_.author_id = u2_.id
WHERE
  b0_.status = ?
ORDER BY
  b0_.published_at DESC
LIMIT
  3

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_.image_path AS image_path_5, b0_.image_alt AS image_alt_6, b0_.status AS status_7, b0_.published_at AS published_at_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.meta_title AS meta_title_11, b0_.meta_description AS meta_description_12, b0_.read_time AS read_time_13, b0_.view_count AS view_count_14, b1_.id AS id_15, b1_.name AS name_16, b1_.slug AS slug_17, b1_.position AS position_18, u2_.id AS id_19, u2_.email AS email_20, u2_.roles AS roles_21, u2_.password AS password_22, u2_.first_name AS first_name_23, u2_.last_name AS last_name_24, u2_.is_active AS is_active_25, u2_.created_at AS created_at_26, b0_.category_id AS category_id_27, b0_.author_id AS author_id_28 FROM blog_post b0_ LEFT JOIN blog_category b1_ ON b0_.category_id = b1_.id LEFT JOIN `user` u2_ ON b0_.author_id = u2_.id WHERE b0_.status = 'published' ORDER BY b0_.published_at DESC LIMIT 3;

#	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 25)
7	App\Controller\HomeController->index (line 70)
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	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.19 ms
(12.72%)

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.price AS price_2, t0_.info AS info_3, t0_.badge_label AS badge_label_4, t0_.category AS category_5, t0_.is_active AS is_active_6, t0_.position AS position_7, t0_.section_id AS section_id_8 FROM tarif t0_ WHERE t0_.is_active = 1 ORDER BY t0_.category ASC, t0_.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.price AS price_2,
  t0_.info AS info_3,
  t0_.badge_label AS badge_label_4,
  t0_.category AS category_5,
  t0_.is_active AS is_active_6,
  t0_.position AS position_7,
  t0_.section_id AS section_id_8
FROM
  tarif t0_
WHERE
  t0_.is_active = 1
ORDER BY
  t0_.category ASC,
  t0_.position ASC

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.price AS price_2, t0_.info AS info_3, t0_.badge_label AS badge_label_4, t0_.category AS category_5, t0_.is_active AS is_active_6, t0_.position AS position_7, t0_.section_id AS section_id_8 FROM tarif t0_ WHERE t0_.is_active = 1 ORDER BY t0_.category ASC, t0_.position 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\TarifRepository->findActiveGroupedByCategory (line 18)
7	App\Service\SiteDataService->{closure:App\Service\SiteDataService::getTarifsByCategory():78} (line 80)
8	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
9	Symfony\Component\Cache\LockRegistry->compute (line 111)
10	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 67)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
14	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
15	App\Service\SiteDataService->getTarifsByCategory (line 78)
16	App\Controller\HomeController->index (line 69)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	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\PackFeature	16
App\Entity\Tarif	11
App\Entity\Formation	5
App\Entity\Pack	4
App\Entity\BlogPost	3
App\Entity\BlogCategory	3
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\Formation	No errors.
App\Entity\Pack	No errors.
App\Entity\PackFeature	No errors.
App\Entity\Tarif	No errors.
App\Entity\Section	No errors.
App\Entity\BlogPost	No errors.
App\Entity\BlogCategory	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET http://click-ever.fr/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping