Symfony Profiler

Query Metrics

33 Database Queries

6 Different statements

30.23 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

23.19 ms
(76.70%)

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_30593e902ffc31b87f953764a16629b0->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 35)
19	App\Controller\CountryController->country (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.67 ms
(8.84%)

SELECT t0.id AS id_1, t0.url AS url_2, t0.date AS date_3, t0.title AS title_4, t0.status AS status_5, t0.author_name AS author_name_6, t0.author_uri AS author_uri_7, t0.source AS source_8, t0.name AS name_9, t0.portada AS portada_10, t0.user_id AS user_id_11, t0.center_id AS center_id_12 FROM photos t0 WHERE t0.center_id = ?

Parameters:

[
  104
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.date AS date_3,
  t0.title AS title_4,
  t0.status AS status_5,
  t0.author_name AS author_name_6,
  t0.author_uri AS author_uri_7,
  t0.source AS source_8,
  t0.name AS name_9,
  t0.portada AS portada_10,
  t0.user_id AS user_id_11,
  t0.center_id AS center_id_12
FROM
  photos t0
WHERE
  t0.center_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.date AS date_3, t0.title AS title_4, t0.status AS status_5, t0.author_name AS author_name_6, t0.author_uri AS author_uri_7, t0.source AS source_8, t0.name AS name_9, t0.portada AS portada_10, t0.user_id AS user_id_11, t0.center_id AS center_id_12 FROM photos t0 WHERE t0.center_id = 104;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2708)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 379)
8	App\Entity\Center->getPhoto (line 1629)
9	Twig\Extension\CoreExtension::getAttribute (line 205)
10	__TwigTemplate_30593e902ffc31b87f953764a16629b0->block_body (line 430)
11	Twig\Template->yieldBlock (line 115)
12	__TwigTemplate_a6184985b381358af0c52a0868f78082->doDisplay (line 360)
13	Twig\Template->yield (line 52)
14	__TwigTemplate_30593e902ffc31b87f953764a16629b0->doDisplay (line 360)
15	Twig\Template->yield (line 335)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 307)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 35)
22	App\Controller\CountryController->country (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

1.32 ms
(4.37%)

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_30593e902ffc31b87f953764a16629b0->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 35)
20	App\Controller\CountryController->country (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.18 ms
(3.92%)

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_30593e902ffc31b87f953764a16629b0->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 35)
20	App\Controller\CountryController->country (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.02 ms
(3.38%)

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 = ? ORDER BY t0.rating ASC LIMIT 100

Parameters:

[
  7
]

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 = ?
ORDER BY
  t0.rating ASC
LIMIT
  100

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 = 7 ORDER BY t0.rating ASC LIMIT 100;

#	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 31)
5	App\Controller\CountryController->country (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.84 ms
(2.78%)

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 WHERE t0.shortname = ? LIMIT 1

Parameters:

[
  "th"
]

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
WHERE
  t0.shortname = ?
LIMIT
  1

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 WHERE t0.shortname = 'th' 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 25)
5	App\Controller\CountryController->country (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)

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\Country	No errors.
App\Entity\DivePlace	No errors.
App\Entity\Center	No errors.
App\Entity\DiveRegion	No errors.
App\Entity\DiveLog	No errors.
App\Entity\Photos	No errors.
App\Entity\AvailableDiveCenter	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://www.buceoscuba.com/th/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping