Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

3.99 ms Query time

1 Invalid entities

5 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.17 ms
(29.43%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.slogan AS slogan_4, t0.color AS color_5, t0.resident AS resident_6, t0.network AS network_7, t0.is_created AS is_created_8, t0.is_activated AS is_activated_9, t0.created_at AS created_at_10, t0.data AS data_11, t0.legal AS legal_12, t0.wallpaper AS wallpaper_13, t0.statistical AS statistical_14, t0.manager_id AS manager_id_15, t0.main_borough_id AS main_borough_id_16 FROM subdomain t0 INNER JOIN subdomain_borough ON t0.id = subdomain_borough.subdomain_id WHERE subdomain_borough.borough_id = ?

Parameters:

[
  194
]

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.slogan AS slogan_4,
  t0.color AS color_5,
  t0.resident AS resident_6,
  t0.network AS network_7,
  t0.is_created AS is_created_8,
  t0.is_activated AS is_activated_9,
  t0.created_at AS created_at_10,
  t0.data AS data_11,
  t0.legal AS legal_12,
  t0.wallpaper AS wallpaper_13,
  t0.statistical AS statistical_14,
  t0.manager_id AS manager_id_15,
  t0.main_borough_id AS main_borough_id_16
FROM
  subdomain t0
  INNER JOIN subdomain_borough ON t0.id = subdomain_borough.subdomain_id
WHERE
  subdomain_borough.borough_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.slogan AS slogan_4, t0.color AS color_5, t0.resident AS resident_6, t0.network AS network_7, t0.is_created AS is_created_8, t0.is_activated AS is_activated_9, t0.created_at AS created_at_10, t0.data AS data_11, t0.legal AS legal_12, t0.wallpaper AS wallpaper_13, t0.statistical AS statistical_14, t0.manager_id AS manager_id_15, t0.main_borough_id AS main_borough_id_16 FROM subdomain t0 INNER JOIN subdomain_borough ON t0.id = subdomain_borough.subdomain_id WHERE subdomain_borough.borough_id = 194;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2750)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	App\Service\RedirectSubdomain->checkPlace (line 131)
9	App\Controller\EventController->search (line 1512)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	require_once (line 5)

1.16 ms
(29.01%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.cover_image AS cover_image_4, t0.description AS description_5, t0.pronoun AS pronoun_6, t0.name AS name_7, t0.number AS number_8, t0.address AS address_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.oldserial AS oldserial_12, t0.oldurl AS oldurl_13, t0.opening AS opening_14, t0.links AS links_15, t0.map_url AS map_url_16, t0.street_url AS street_url_17, t0.email AS email_18, t0.phone AS phone_19, t0.ip AS ip_20, t0.transport AS transport_21, t0.data_link AS data_link_22, t0.opinion AS opinion_23, t0.summary AS summary_24, t0.wifi AS wifi_25, t0.last_service AS last_service_26, t0.parking AS parking_27, t0.multi_titles AS multi_titles_28, t0.latitude AS latitude_29, t0.longitude AS longitude_30, t0.city_id AS city_id_31, t0.district_id AS district_id_32, t0.postcode_id AS postcode_id_33, t0.placekind_primary_id AS placekind_primary_id_34, t0.placekind_secondary_id AS placekind_secondary_id_35, t0.placekind_tertiary_id AS placekind_tertiary_id_36, t0.author_id AS author_id_37 FROM place t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "les-arenes-de-metz-palais-omnisport-metz"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.cover_image AS cover_image_4,
  t0.description AS description_5,
  t0.pronoun AS pronoun_6,
  t0.name AS name_7,
  t0.number AS number_8,
  t0.address AS address_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.oldserial AS oldserial_12,
  t0.oldurl AS oldurl_13,
  t0.opening AS opening_14,
  t0.links AS links_15,
  t0.map_url AS map_url_16,
  t0.street_url AS street_url_17,
  t0.email AS email_18,
  t0.phone AS phone_19,
  t0.ip AS ip_20,
  t0.transport AS transport_21,
  t0.data_link AS data_link_22,
  t0.opinion AS opinion_23,
  t0.summary AS summary_24,
  t0.wifi AS wifi_25,
  t0.last_service AS last_service_26,
  t0.parking AS parking_27,
  t0.multi_titles AS multi_titles_28,
  t0.latitude AS latitude_29,
  t0.longitude AS longitude_30,
  t0.city_id AS city_id_31,
  t0.district_id AS district_id_32,
  t0.postcode_id AS postcode_id_33,
  t0.placekind_primary_id AS placekind_primary_id_34,
  t0.placekind_secondary_id AS placekind_secondary_id_35,
  t0.placekind_tertiary_id AS placekind_tertiary_id_36,
  t0.author_id AS author_id_37
FROM
  place t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.cover_image AS cover_image_4, t0.description AS description_5, t0.pronoun AS pronoun_6, t0.name AS name_7, t0.number AS number_8, t0.address AS address_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.oldserial AS oldserial_12, t0.oldurl AS oldurl_13, t0.opening AS opening_14, t0.links AS links_15, t0.map_url AS map_url_16, t0.street_url AS street_url_17, t0.email AS email_18, t0.phone AS phone_19, t0.ip AS ip_20, t0.transport AS transport_21, t0.data_link AS data_link_22, t0.opinion AS opinion_23, t0.summary AS summary_24, t0.wifi AS wifi_25, t0.last_service AS last_service_26, t0.parking AS parking_27, t0.multi_titles AS multi_titles_28, t0.latitude AS latitude_29, t0.longitude AS longitude_30, t0.city_id AS city_id_31, t0.district_id AS district_id_32, t0.postcode_id AS postcode_id_33, t0.placekind_primary_id AS placekind_primary_id_34, t0.placekind_secondary_id AS placekind_secondary_id_35, t0.placekind_tertiary_id AS placekind_tertiary_id_36, t0.author_id AS author_id_37 FROM place t0 WHERE t0.slug = 'les-arenes-de-metz-palais-omnisport-metz' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\EventController->handlePlacePath (line 1582)
5	App\Controller\EventController->search (line 1490)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
10	require_once (line 32)
11	require_once (line 5)

0.91 ms
(22.89%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.resident AS resident_4, t0.chief_town AS chief_town_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.description AS description_8, t0.zoom AS zoom_9, t0.department_id AS department_id_10, t11.id AS id_12, t11.name AS name_13, t11.slug AS slug_14, t11.slogan AS slogan_15, t11.color AS color_16, t11.resident AS resident_17, t11.network AS network_18, t11.is_created AS is_created_19, t11.is_activated AS is_activated_20, t11.created_at AS created_at_21, t11.data AS data_22, t11.legal AS legal_23, t11.wallpaper AS wallpaper_24, t11.statistical AS statistical_25, t11.manager_id AS manager_id_26, t11.main_borough_id AS main_borough_id_27 FROM borough t0 LEFT JOIN subdomain t11 ON t11.main_borough_id = t0.id WHERE t0.id = ?

Parameters:

[
  194
]

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.resident AS resident_4,
  t0.chief_town AS chief_town_5,
  t0.latitude AS latitude_6,
  t0.longitude AS longitude_7,
  t0.description AS description_8,
  t0.zoom AS zoom_9,
  t0.department_id AS department_id_10,
  t11.id AS id_12,
  t11.name AS name_13,
  t11.slug AS slug_14,
  t11.slogan AS slogan_15,
  t11.color AS color_16,
  t11.resident AS resident_17,
  t11.network AS network_18,
  t11.is_created AS is_created_19,
  t11.is_activated AS is_activated_20,
  t11.created_at AS created_at_21,
  t11.data AS data_22,
  t11.legal AS legal_23,
  t11.wallpaper AS wallpaper_24,
  t11.statistical AS statistical_25,
  t11.manager_id AS manager_id_26,
  t11.main_borough_id AS main_borough_id_27
FROM
  borough t0
  LEFT JOIN subdomain t11 ON t11.main_borough_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.resident AS resident_4, t0.chief_town AS chief_town_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.description AS description_8, t0.zoom AS zoom_9, t0.department_id AS department_id_10, t11.id AS id_12, t11.name AS name_13, t11.slug AS slug_14, t11.slogan AS slogan_15, t11.color AS color_16, t11.resident AS resident_17, t11.network AS network_18, t11.is_created AS is_created_19, t11.is_activated AS is_activated_20, t11.created_at AS created_at_21, t11.data AS data_22, t11.legal AS legal_23, t11.wallpaper AS wallpaper_24, t11.statistical AS statistical_25, t11.manager_id AS manager_id_26, t11.main_borough_id AS main_borough_id_27 FROM borough t0 LEFT JOIN subdomain t11 ON t11.main_borough_id = t0.id WHERE t0.id = 194;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Borough::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Borough->__get (line 153)
7	App\Entity\Borough->getSubdomains (line 238)
8	App\Service\RedirectSubdomain->checkPlace (line 116)
9	App\Controller\EventController->search (line 1512)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	require_once (line 5)

0.75 ms
(18.68%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.coat_of_arms AS coat_of_arms_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.borough_id AS borough_id_8, t0.department_id AS department_id_9 FROM city t0 WHERE t0.id = ?

Parameters:

[
  3262
]

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.coat_of_arms AS coat_of_arms_5,
  t0.latitude AS latitude_6,
  t0.longitude AS longitude_7,
  t0.borough_id AS borough_id_8,
  t0.department_id AS department_id_9
FROM
  city 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, t0.coat_of_arms AS coat_of_arms_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.borough_id AS borough_id_8, t0.department_id AS department_id_9 FROM city t0 WHERE t0.id = 3262;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\City::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\City->__get (line 153)
7	App\Entity\City->getBorough (line 168)
8	App\Service\RedirectSubdomain->checkPlace (line 116)
9	App\Controller\EventController->search (line 1512)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	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\Place	1
App\Entity\City	1
App\Entity\Borough	1
App\Entity\Department	1
App\Entity\Subdomain	1

Entities Mapping

Class	Mapping errors
App\Entity\Place	No errors.
App\Entity\City	The field App\Entity\City#resources is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\TicketResource#city does not contain the required 'inversedBy: "resources"' attribute.
App\Entity\District	No errors.
App\Entity\Postcode	No errors.
App\Entity\Placekind	No errors.
App\Entity\User	No errors.
App\Entity\Event	No errors.
App\Entity\Comment	No errors.
App\Entity\Claim	No errors.
App\Entity\PlaceLike	No errors.
App\Entity\Room	No errors.
App\Entity\Placetag	No errors.
App\Entity\Borough	No errors.
App\Entity\Department	No errors.
App\Entity\TicketResource	No errors.
App\Entity\Subdomain	No errors.
App\Entity\Reduction	No errors.

Symfony Profiler

GET https://www.curieux.app/agenda/lieu/les-arenes-de-metz-palais-omnisport-metz

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping