Symfony Profiler

Query Metrics

17 Database Queries

6 Different statements

19.96 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

14.24 ms
(71.33%)

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 53)
11	__TwigTemplate_11eadd7710d2f444d56cdcbb10923469->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 58)
19	App\Controller\DiveplaceController->diveplace (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)

1.48 ms
(7.42%)

SELECT t0.id AS id_1, t0.date AS date_2, t0.zone AS zone_3, t0.minutes AS minutes_4, t0.depp AS depp_5, t0.gas_type AS gas_type_6, t0.pressure_init AS pressure_init_7, t0.pressure_end AS pressure_end_8, t0.gas_capacity AS gas_capacity_9, t0.lead_weight AS lead_weight_10, t0.suit AS suit_11, t0.temperature AS temperature_12, t0.visibility AS visibility_13, t0.stream AS stream_14, t0.description AS description_15, t0.jacket AS jacket_16, t0.fin AS fin_17, t0.regulator AS regulator_18, t0.compass AS compass_19, t0.cylinder AS cylinder_20, t0.computer AS computer_21, t0.mask AS mask_22, t0.glove AS glove_23, t0.boot AS boot_24, t0.knife AS knife_25, t0.divemaster_text AS divemaster_text_26, t0.buddy_text AS buddy_text_27, t0.dive_place_id AS dive_place_id_28, t0.user_id AS user_id_29, t0.center_id AS center_id_30, t0.buddy_id AS buddy_id_31, t0.divemaster_id AS divemaster_id_32, t0.equipment_suit_id AS equipment_suit_id_33, t0.equipment_jacket_id AS equipment_jacket_id_34, t0.equipment_fin_id AS equipment_fin_id_35, t0.equipment_regulator_id AS equipment_regulator_id_36, t0.equipment_compass_id AS equipment_compass_id_37, t0.equipment_cylinder_id AS equipment_cylinder_id_38, t0.equipment_computer_id AS equipment_computer_id_39, t0.equipment_mask_id AS equipment_mask_id_40, t0.equipment_glove_id AS equipment_glove_id_41, t0.equipment_boot_id AS equipment_boot_id_42, t0.equipment_knife_id AS equipment_knife_id_43 FROM dive_log t0 WHERE t0.dive_place_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.zone AS zone_3,
  t0.minutes AS minutes_4,
  t0.depp AS depp_5,
  t0.gas_type AS gas_type_6,
  t0.pressure_init AS pressure_init_7,
  t0.pressure_end AS pressure_end_8,
  t0.gas_capacity AS gas_capacity_9,
  t0.lead_weight AS lead_weight_10,
  t0.suit AS suit_11,
  t0.temperature AS temperature_12,
  t0.visibility AS visibility_13,
  t0.stream AS stream_14,
  t0.description AS description_15,
  t0.jacket AS jacket_16,
  t0.fin AS fin_17,
  t0.regulator AS regulator_18,
  t0.compass AS compass_19,
  t0.cylinder AS cylinder_20,
  t0.computer AS computer_21,
  t0.mask AS mask_22,
  t0.glove AS glove_23,
  t0.boot AS boot_24,
  t0.knife AS knife_25,
  t0.divemaster_text AS divemaster_text_26,
  t0.buddy_text AS buddy_text_27,
  t0.dive_place_id AS dive_place_id_28,
  t0.user_id AS user_id_29,
  t0.center_id AS center_id_30,
  t0.buddy_id AS buddy_id_31,
  t0.divemaster_id AS divemaster_id_32,
  t0.equipment_suit_id AS equipment_suit_id_33,
  t0.equipment_jacket_id AS equipment_jacket_id_34,
  t0.equipment_fin_id AS equipment_fin_id_35,
  t0.equipment_regulator_id AS equipment_regulator_id_36,
  t0.equipment_compass_id AS equipment_compass_id_37,
  t0.equipment_cylinder_id AS equipment_cylinder_id_38,
  t0.equipment_computer_id AS equipment_computer_id_39,
  t0.equipment_mask_id AS equipment_mask_id_40,
  t0.equipment_glove_id AS equipment_glove_id_41,
  t0.equipment_boot_id AS equipment_boot_id_42,
  t0.equipment_knife_id AS equipment_knife_id_43
FROM
  dive_log t0
WHERE
  t0.dive_place_id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.zone AS zone_3, t0.minutes AS minutes_4, t0.depp AS depp_5, t0.gas_type AS gas_type_6, t0.pressure_init AS pressure_init_7, t0.pressure_end AS pressure_end_8, t0.gas_capacity AS gas_capacity_9, t0.lead_weight AS lead_weight_10, t0.suit AS suit_11, t0.temperature AS temperature_12, t0.visibility AS visibility_13, t0.stream AS stream_14, t0.description AS description_15, t0.jacket AS jacket_16, t0.fin AS fin_17, t0.regulator AS regulator_18, t0.compass AS compass_19, t0.cylinder AS cylinder_20, t0.computer AS computer_21, t0.mask AS mask_22, t0.glove AS glove_23, t0.boot AS boot_24, t0.knife AS knife_25, t0.divemaster_text AS divemaster_text_26, t0.buddy_text AS buddy_text_27, t0.dive_place_id AS dive_place_id_28, t0.user_id AS user_id_29, t0.center_id AS center_id_30, t0.buddy_id AS buddy_id_31, t0.divemaster_id AS divemaster_id_32, t0.equipment_suit_id AS equipment_suit_id_33, t0.equipment_jacket_id AS equipment_jacket_id_34, t0.equipment_fin_id AS equipment_fin_id_35, t0.equipment_regulator_id AS equipment_regulator_id_36, t0.equipment_compass_id AS equipment_compass_id_37, t0.equipment_cylinder_id AS equipment_cylinder_id_38, t0.equipment_computer_id AS equipment_computer_id_39, t0.equipment_mask_id AS equipment_mask_id_40, t0.equipment_glove_id AS equipment_glove_id_41, t0.equipment_boot_id AS equipment_boot_id_42, t0.equipment_knife_id AS equipment_knife_id_43 FROM dive_log t0 WHERE t0.dive_place_id = 1;

#	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 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1274)
9	Twig\Extension\CoreExtension::testEmpty (line 325)
10	__TwigTemplate_11eadd7710d2f444d56cdcbb10923469->block_body (line 430)
11	Twig\Template->yieldBlock (line 115)
12	__TwigTemplate_a6184985b381358af0c52a0868f78082->doDisplay (line 360)
13	Twig\Template->yield (line 53)
14	__TwigTemplate_11eadd7710d2f444d56cdcbb10923469->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 58)
22	App\Controller\DiveplaceController->diveplace (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.37 ms
(6.85%)

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.slug = ? LIMIT 1

Parameters:

[
  "afroditip-ria-de-pontevedra-es"
]

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.slug = ?
LIMIT
  1

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.slug = 'afroditip-ria-de-pontevedra-es' 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 49)
5	App\Controller\DiveplaceController->diveplace (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.31 ms
(6.58%)

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 53)
12	__TwigTemplate_11eadd7710d2f444d56cdcbb10923469->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 58)
20	App\Controller\DiveplaceController->diveplace (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)

0.80 ms
(3.99%)

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 53)
12	__TwigTemplate_11eadd7710d2f444d56cdcbb10923469->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 58)
20	App\Controller\DiveplaceController->diveplace (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)

0.76 ms
(3.83%)

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 297)
9	__TwigTemplate_11eadd7710d2f444d56cdcbb10923469->block_body (line 430)
10	Twig\Template->yieldBlock (line 115)
11	__TwigTemplate_a6184985b381358af0c52a0868f78082->doDisplay (line 360)
12	Twig\Template->yield (line 53)
13	__TwigTemplate_11eadd7710d2f444d56cdcbb10923469->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 58)
21	App\Controller\DiveplaceController->diveplace (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)

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\DivePlace	No errors.
App\Entity\Country	No errors.
App\Entity\DiveRegion	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.
App\Entity\User	No errors.
App\Entity\EquipmentSuit	No errors.
App\Entity\EquipmentJacket	The association App\Entity\EquipmentJacket#status refers to the inverse side field App\Entity\EquipmentStatus#equipmentJackets which does not exist. The association App\Entity\EquipmentJacket#buy refers to the inverse side field App\Entity\EquipmentBuy#equipmentJackets which does not exist. The association App\Entity\EquipmentJacket#user refers to the inverse side field App\Entity\User#equipmentJackets which does not exist.
App\Entity\EquipmentFin	The association App\Entity\EquipmentFin#user refers to the inverse side field App\Entity\User#equipmentFins which does not exist.
App\Entity\EquipmentRegulator	No errors.
App\Entity\EquipmentCompass	No errors.
App\Entity\EquipmentCylinder	No errors.
App\Entity\EquipmentComputer	No errors.
App\Entity\EquipmentMask	No errors.
App\Entity\EquipmentGlove	No errors.
App\Entity\EquipmentBoot	No errors.
App\Entity\EquipmentKnife	No errors.

Symfony Profiler

GET https://www.buceoscuba.com/diveplace/point/afroditip-ria-de-pontevedra-es/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping