Symfony Profiler

Query Metrics

51 Database Queries

5 Different statements

27.18 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

24.56 ms
(90.36%)

SELECT t0.name AS name_1, t0.note AS note_2, t0.manager AS manager_3, t0.reference AS reference_4, t0.phone AS phone_5, t0.description AS description_6, t0.website AS website_7, t0.email AS email_8, t0.phone2 AS phone2_9, t0.view_number AS view_number_10, t0.verified AS verified_11, t0.score AS score_12, t0.keywords AS keywords_13, t0.place_id AS place_id_14, t0.platform AS platform_15, t0.version AS version_16, t0.google_type AS google_type_17, t0.google_photos AS google_photos_18, t0.map_url AS map_url_19, t0.weekday_text AS weekday_text_20, t0.enabled AS enabled_21, t0.ranks AS ranks_22, t0.full_address AS full_address_23, t0.latitude AS latitude_24, t0.longitude AS longitude_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.slug AS slug_28, t0.id AS id_29, t0.facebook AS facebook_30, t0.youtube AS youtube_31, t0.instagram AS instagram_32, t0.twitter AS twitter_33, t0.google_plus AS google_plus_34, t0.region_id AS region_id_35, t0.commune_id AS commune_id_36, t0.city_id AS city_id_37, t0.quartier_id AS quartier_id_38, t0.sub_prefecture_id AS sub_prefecture_id_39, t0.prefecture_id AS prefecture_id_40, t0.campagne_id AS campagne_id_41, t0.operator_id AS operator_id_42, t0.quotation_id AS quotation_id_43 FROM establishment t0 INNER JOIN establishment_category ON t0.id = establishment_category.establishment_id WHERE establishment_category.category_id = ?

Parameters:

[
  131
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.note AS note_2,
  t0.manager AS manager_3,
  t0.reference AS reference_4,
  t0.phone AS phone_5,
  t0.description AS description_6,
  t0.website AS website_7,
  t0.email AS email_8,
  t0.phone2 AS phone2_9,
  t0.view_number AS view_number_10,
  t0.verified AS verified_11,
  t0.score AS score_12,
  t0.keywords AS keywords_13,
  t0.place_id AS place_id_14,
  t0.platform AS platform_15,
  t0.version AS version_16,
  t0.google_type AS google_type_17,
  t0.google_photos AS google_photos_18,
  t0.map_url AS map_url_19,
  t0.weekday_text AS weekday_text_20,
  t0.enabled AS enabled_21,
  t0.ranks AS ranks_22,
  t0.full_address AS full_address_23,
  t0.latitude AS latitude_24,
  t0.longitude AS longitude_25,
  t0.created_at AS created_at_26,
  t0.updated_at AS updated_at_27,
  t0.slug AS slug_28,
  t0.id AS id_29,
  t0.facebook AS facebook_30,
  t0.youtube AS youtube_31,
  t0.instagram AS instagram_32,
  t0.twitter AS twitter_33,
  t0.google_plus AS google_plus_34,
  t0.region_id AS region_id_35,
  t0.commune_id AS commune_id_36,
  t0.city_id AS city_id_37,
  t0.quartier_id AS quartier_id_38,
  t0.sub_prefecture_id AS sub_prefecture_id_39,
  t0.prefecture_id AS prefecture_id_40,
  t0.campagne_id AS campagne_id_41,
  t0.operator_id AS operator_id_42,
  t0.quotation_id AS quotation_id_43
FROM
  establishment t0
  INNER JOIN establishment_category ON t0.id = establishment_category.establishment_id
WHERE
  establishment_category.category_id = ?

SELECT t0.name AS name_1, t0.note AS note_2, t0.manager AS manager_3, t0.reference AS reference_4, t0.phone AS phone_5, t0.description AS description_6, t0.website AS website_7, t0.email AS email_8, t0.phone2 AS phone2_9, t0.view_number AS view_number_10, t0.verified AS verified_11, t0.score AS score_12, t0.keywords AS keywords_13, t0.place_id AS place_id_14, t0.platform AS platform_15, t0.version AS version_16, t0.google_type AS google_type_17, t0.google_photos AS google_photos_18, t0.map_url AS map_url_19, t0.weekday_text AS weekday_text_20, t0.enabled AS enabled_21, t0.ranks AS ranks_22, t0.full_address AS full_address_23, t0.latitude AS latitude_24, t0.longitude AS longitude_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.slug AS slug_28, t0.id AS id_29, t0.facebook AS facebook_30, t0.youtube AS youtube_31, t0.instagram AS instagram_32, t0.twitter AS twitter_33, t0.google_plus AS google_plus_34, t0.region_id AS region_id_35, t0.commune_id AS commune_id_36, t0.city_id AS city_id_37, t0.quartier_id AS quartier_id_38, t0.sub_prefecture_id AS sub_prefecture_id_39, t0.prefecture_id AS prefecture_id_40, t0.campagne_id AS campagne_id_41, t0.operator_id AS operator_id_42, t0.quotation_id AS quotation_id_43 FROM establishment t0 INNER JOIN establishment_category ON t0.id = establishment_category.establishment_id WHERE establishment_category.category_id = 131;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1051)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 980)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2712)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 627)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 396)
8	Doctrine\ORM\PersistentCollection->count (line 182)
9	App\Entity\Category->getEstablishmentCount (line 1635)
10	twig_get_attribute (line 112)
11	__TwigTemplate_2757cc4fd21165baf99a64dc07f6ecaa->block_body (line 171)
12	Twig\Template->displayBlock (line 77)
13	__TwigTemplate_e718d897106eb0a446639ba624f18da7->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 49)
16	__TwigTemplate_2757cc4fd21165baf99a64dc07f6ecaa->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 379)
19	Twig\Template->render (line 38)
20	Twig\TemplateWrapper->render (line 280)
21	Twig\Environment->render (line 448)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 43)
25	App\Controller\CategoryController->mainCategories (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 23)

0.99 ms
(3.64%)

SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 WHERE t0.parent_id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.second_name AS second_name_2,
  t0.reference AS reference_3,
  t0.icon AS icon_4,
  t0.score AS score_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.slug AS slug_8,
  t0.id AS id_9,
  t0.parent_id AS parent_id_10,
  t0.popular_category_id AS popular_category_id_11,
  t0.quotation_id AS quotation_id_12
FROM
  category t0
WHERE
  t0.parent_id = ?

SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 WHERE t0.parent_id = 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 28)
5	App\Controller\CategoryController->mainCategories (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 23)

0.60 ms
(2.20%)

SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "batiment-et-construction"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.second_name AS second_name_2,
  t0.reference AS reference_3,
  t0.icon AS icon_4,
  t0.score AS score_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.slug AS slug_8,
  t0.id AS id_9,
  t0.parent_id AS parent_id_10,
  t0.popular_category_id AS popular_category_id_11,
  t0.quotation_id AS quotation_id_12
FROM
  category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 WHERE t0.slug = 'batiment-et-construction' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 238)
5	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\DoctrineParamConverter->findOneBy (line 93)
6	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\DoctrineParamConverter->apply (line 84)
7	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\ParamConverterManager->applyConverter (line 48)
8	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\ParamConverterManager->apply (line 72)
9	Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener->onKernelController (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 23)

0.54 ms
(2.00%)

SELECT * FROM category LEFT JOIN establishment_category ec ON category.id = ec.category_id WHERE ec.category_id IS NOT NULL AND category.parent_id = 6

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  category
  LEFT JOIN establishment_category ec ON category.id = ec.category_id
WHERE
  ec.category_id IS NOT NULL
  AND category.parent_id = 6

SELECT * FROM category LEFT JOIN establishment_category ec ON category.id = ec.category_id WHERE ec.category_id IS NOT NULL AND category.parent_id = 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 61)
2	Doctrine\ORM\NativeQuery->_doExecute (line 935)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
4	Doctrine\ORM\AbstractQuery->execute (line 689)
5	Doctrine\ORM\AbstractQuery->getResult (line 81)
6	App\Repository\CategoryRepository->getCategoriesWithEstablishment (line 34)
7	App\Controller\CategoryController->mainCategories (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 23)

0.49 ms
(1.80%)

SELECT * FROM category LEFT JOIN establishment_category ec ON category.id = ec.category_id WHERE ec.category_id IS  NULL AND category.parent_id = 6

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  category
  LEFT JOIN establishment_category ec ON category.id = ec.category_id
WHERE
  ec.category_id IS NULL
  AND category.parent_id = 6

SELECT * FROM category LEFT JOIN establishment_category ec ON category.id = ec.category_id WHERE ec.category_id IS  NULL AND category.parent_id = 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 61)
2	Doctrine\ORM\NativeQuery->_doExecute (line 935)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
4	Doctrine\ORM\AbstractQuery->execute (line 689)
5	Doctrine\ORM\AbstractQuery->getResult (line 94)
6	App\Repository\CategoryRepository->getCategoriesNotEstablishment (line 35)
7	App\Controller\CategoryController->mainCategories (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 23)

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.

Entities Mapping

Class	Mapping errors
App\Entity\Category	No errors.
App\Entity\PopularCategory	No errors.
App\Entity\Quotation	No errors.
App\Entity\Establishment	No errors.
App\Entity\JobOffert	No errors.
App\Entity\Region	No errors.
App\Entity\Commune	No errors.
App\Entity\City	No errors.
App\Entity\Quartier	No errors.
App\Entity\SubPrefecture	No errors.
App\Entity\Prefecture	No errors.
App\Entity\Campagne	No errors.
App\Entity\Operator	No errors.
App\Entity\Image	No errors.
App\Entity\OpeningHours	No errors.
App\Entity\PricingList	No errors.
App\Entity\Comment	No errors.
App\Entity\Address	No errors.
App\Entity\Booking	No errors.
App\Entity\EstablishmentAdd	No errors.
App\Entity\Amenity	No errors.

Symfony Profiler

GET http://193.70.3.237/categories/batiment-et-construction

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping