Symfony Profiler

Query Metrics

30 Database Queries

6 Different statements

33.12 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

26.34 ms
(79.51%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.place_id AS place_id_3, t0.formatted_address AS formatted_address_4, t0.locality AS locality_5, t0.administrative_area_level_second AS administrative_area_level_second_6, t0.administrative_area_level_first AS administrative_area_level_first_7, t0.postal_code AS postal_code_8, t0.lat AS lat_9, t0.lng AS lng_10, t0.rating AS rating_11, t0.google_maps_uri AS google_maps_uri_12, t0.website_uri AS website_uri_13, t0.adr_format_address AS adr_format_address_14, t0.user_rating_count AS user_rating_count_15, t0.display_name AS display_name_16, t0.slug AS slug_17, t0.whatsapp AS whatsapp_18, t0.instagram AS instagram_19, t0.facebook AS facebook_20, t0.twitter AS twitter_21, t0.youtube AS youtube_22, t0.phone AS phone_23, t0.country_id AS country_id_24 FROM center t0 WHERE t0.country_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.place_id AS place_id_3,
  t0.formatted_address AS formatted_address_4,
  t0.locality AS locality_5,
  t0.administrative_area_level_second AS administrative_area_level_second_6,
  t0.administrative_area_level_first AS administrative_area_level_first_7,
  t0.postal_code AS postal_code_8,
  t0.lat AS lat_9,
  t0.lng AS lng_10,
  t0.rating AS rating_11,
  t0.google_maps_uri AS google_maps_uri_12,
  t0.website_uri AS website_uri_13,
  t0.adr_format_address AS adr_format_address_14,
  t0.user_rating_count AS user_rating_count_15,
  t0.display_name AS display_name_16,
  t0.slug AS slug_17,
  t0.whatsapp AS whatsapp_18,
  t0.instagram AS instagram_19,
  t0.facebook AS facebook_20,
  t0.twitter AS twitter_21,
  t0.youtube AS youtube_22,
  t0.phone AS phone_23,
  t0.country_id AS country_id_24
FROM
  center t0
WHERE
  t0.country_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.place_id AS place_id_3, t0.formatted_address AS formatted_address_4, t0.locality AS locality_5, t0.administrative_area_level_second AS administrative_area_level_second_6, t0.administrative_area_level_first AS administrative_area_level_first_7, t0.postal_code AS postal_code_8, t0.lat AS lat_9, t0.lng AS lng_10, t0.rating AS rating_11, t0.google_maps_uri AS google_maps_uri_12, t0.website_uri AS website_uri_13, t0.adr_format_address AS adr_format_address_14, t0.user_rating_count AS user_rating_count_15, t0.display_name AS display_name_16, t0.slug AS slug_17, t0.whatsapp AS whatsapp_18, t0.instagram AS instagram_19, t0.facebook AS facebook_20, t0.twitter AS twitter_21, t0.youtube AS youtube_22, t0.phone AS phone_23, t0.country_id AS country_id_24 FROM center t0 WHERE t0.country_id = 1;

#	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 26)
5	App\Service\DataBase->getAllCountries (line 1629)
6	Twig\Extension\CoreExtension::getAttribute (line 127)
7	__TwigTemplate_a34de65c57639aed321dd40f30edcec2->doDisplay (line 360)
8	Twig\Template->yield (line 110)
9	__TwigTemplate_a6184985b381358af0c52a0868f78082->doDisplay (line 360)
10	Twig\Template->yield (line 52)
11	__TwigTemplate_86853648047f2c3774fc4281a3768a40->doDisplay (line 360)
12	Twig\Template->yield (line 335)
13	Twig\Template->render (line 38)
14	Twig\TemplateWrapper->render (line 307)
15	Twig\Environment->render (line 448)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 42)
19	App\Controller\DiveplaceController->region (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

2.27 ms
(6.84%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.shortname AS shortname_3, t0.lat AS lat_4, t0.lng AS lng_5 FROM country t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.shortname AS shortname_3,
  t0.lat AS lat_4,
  t0.lng AS lng_5
FROM
  country t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.shortname AS shortname_3, t0.lat AS lat_4, t0.lng AS lng_5 FROM country t0;

#	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 96)
5	Doctrine\ORM\EntityRepository->findAll (line 25)
6	App\Service\DataBase->getAllCountries (line 1629)
7	Twig\Extension\CoreExtension::getAttribute (line 127)
8	__TwigTemplate_a34de65c57639aed321dd40f30edcec2->doDisplay (line 360)
9	Twig\Template->yield (line 110)
10	__TwigTemplate_a6184985b381358af0c52a0868f78082->doDisplay (line 360)
11	Twig\Template->yield (line 52)
12	__TwigTemplate_86853648047f2c3774fc4281a3768a40->doDisplay (line 360)
13	Twig\Template->yield (line 335)
14	Twig\Template->render (line 38)
15	Twig\TemplateWrapper->render (line 307)
16	Twig\Environment->render (line 448)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 42)
20	App\Controller\DiveplaceController->region (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

1.44 ms
(4.34%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.deep AS deep_6, t0.slug AS slug_7, t0.country_id AS country_id_8, t0.region_id AS region_id_9, t0.type_id AS type_id_10 FROM dive_place t0 WHERE t0.region_id = ? ORDER BY t0.id DESC

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.lat AS lat_4,
  t0.lng AS lng_5,
  t0.deep AS deep_6,
  t0.slug AS slug_7,
  t0.country_id AS country_id_8,
  t0.region_id AS region_id_9,
  t0.type_id AS type_id_10
FROM
  dive_place t0
WHERE
  t0.region_id = ?
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.deep AS deep_6, t0.slug AS slug_7, t0.country_id AS country_id_8, t0.region_id AS region_id_9, t0.type_id AS type_id_10 FROM dive_place t0 WHERE t0.region_id = 3 ORDER BY t0.id DESC;

#	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 36)
5	App\Controller\DiveplaceController->region (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 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

1.22 ms
(3.69%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.country_id AS country_id_5 FROM dive_region t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "algarve-pt"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.country_id AS country_id_5
FROM
  dive_region t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.country_id AS country_id_5 FROM dive_region t0 WHERE t0.slug = 'algarve-pt' 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 30)
5	App\Controller\DiveplaceController->region (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 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.98 ms
(2.96%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4 FROM dive_type t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4
FROM
  dive_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4 FROM dive_type t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 100)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
6	Proxies\__CG__\App\Entity\DiveType->__get (line 46)
7	App\Entity\DiveType->getName (line 1629)
8	Twig\Extension\CoreExtension::getAttribute (line 316)
9	__TwigTemplate_86853648047f2c3774fc4281a3768a40->block_body (line 430)
10	Twig\Template->yieldBlock (line 115)
11	__TwigTemplate_a6184985b381358af0c52a0868f78082->doDisplay (line 360)
12	Twig\Template->yield (line 52)
13	__TwigTemplate_86853648047f2c3774fc4281a3768a40->doDisplay (line 360)
14	Twig\Template->yield (line 335)
15	Twig\Template->render (line 38)
16	Twig\TemplateWrapper->render (line 307)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 42)
21	App\Controller\DiveplaceController->region (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.89 ms
(2.67%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.country_id AS country_id_5 FROM dive_region t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.country_id AS country_id_5
FROM
  dive_region t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.country_id AS country_id_5 FROM dive_region t0;

#	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 96)
5	Doctrine\ORM\EntityRepository->findAll (line 44)
6	App\Service\DataBase->getAllRegions (line 1629)
7	Twig\Extension\CoreExtension::getAttribute (line 153)
8	__TwigTemplate_a34de65c57639aed321dd40f30edcec2->doDisplay (line 360)
9	Twig\Template->yield (line 110)
10	__TwigTemplate_a6184985b381358af0c52a0868f78082->doDisplay (line 360)
11	Twig\Template->yield (line 52)
12	__TwigTemplate_86853648047f2c3774fc4281a3768a40->doDisplay (line 360)
13	Twig\Template->yield (line 335)
14	Twig\Template->render (line 38)
15	Twig\TemplateWrapper->render (line 307)
16	Twig\Environment->render (line 448)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 42)
20	App\Controller\DiveplaceController->region (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	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.

Entities Mapping

Class	Mapping errors
App\Entity\DiveRegion	No errors.
App\Entity\Country	No errors.
App\Entity\DivePlace	No errors.
App\Entity\DiveType	No errors.
App\Entity\DiveLog	No errors.
App\Entity\Center	No errors.
App\Entity\Photos	No errors.
App\Entity\AvailableDiveCenter	No errors.

Symfony Profiler

GET https://www.buceoscuba.com/diveplace/region/algarve-pt/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping