Symfony Profiler

Query Metrics

98 Database Queries

11 Different statements

67.61 ms Query time

3 Invalid entities

258 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

51.48 ms
(76.14%)

SELECT t0.id AS id_1, t0.content AS content_2, t0.subject AS subject_3, t0.images AS images_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.report_id AS report_id_9, t0.checklist_id AS checklist_id_10 FROM notification t0 WHERE t0.id = ?

Parameters:

[
  9710
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.subject AS subject_3,
  t0.images AS images_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.created_by AS created_by_7,
  t0.updated_by AS updated_by_8,
  t0.report_id AS report_id_9,
  t0.checklist_id AS checklist_id_10
FROM
  notification t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.content AS content_2, t0.subject AS subject_3, t0.images AS images_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.report_id AS report_id_9, t0.checklist_id AS checklist_id_10 FROM notification t0 WHERE t0.id = 9710;

#	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->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Entity\Notification::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Notification->__get (line 153)
7	App\Entity\Notification->getReport (line 204)
8	Twig\Extension\CoreExtension->getAttribute (line 1918)
9	__TwigTemplate_4e60d17a3c1fd962262eaf804ad05574::doDisplay (line 59)
10	Twig\Template->yield (line 411)
11	__TwigTemplate_bfac8311b4c4da7355b10300073aeeed->doDisplay (line 332)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_2484deeeadb3227444200e7889efb70d->doDisplay (line 54)
14	Twig\Template->yield (line 411)
15	Twig\Template->display (line 366)
16	Twig\Template->render (line 381)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\LogController->index (line 92)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

6.66 ms
(9.85%)

SELECT t0.id AS id_1, t0.value AS value_2, t0.raw AS raw_3, t0.source AS source_4, t0.timestamp AS timestamp_5, t0.forecast AS forecast_6, t0.strymo_id AS strymo_id_7, t0.kind AS kind_8, t0.day AS day_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.place_id AS place_id_12, t0.parameter_id AS parameter_id_13, t0.document_id AS document_id_14, t0.report_id AS report_id_15 FROM metric t0 WHERE t0.report_id = ?

Parameters:

[
  1005
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.raw AS raw_3,
  t0.source AS source_4,
  t0.timestamp AS timestamp_5,
  t0.forecast AS forecast_6,
  t0.strymo_id AS strymo_id_7,
  t0.kind AS kind_8,
  t0.day AS day_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.place_id AS place_id_12,
  t0.parameter_id AS parameter_id_13,
  t0.document_id AS document_id_14,
  t0.report_id AS report_id_15
FROM
  metric t0
WHERE
  t0.report_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.raw AS raw_3, t0.source AS source_4, t0.timestamp AS timestamp_5, t0.forecast AS forecast_6, t0.strymo_id AS strymo_id_7, t0.kind AS kind_8, t0.day AS day_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.place_id AS place_id_12, t0.parameter_id AS parameter_id_13, t0.document_id AS document_id_14, t0.report_id AS report_id_15 FROM metric t0 WHERE t0.report_id = 1005;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2462)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getResult (line 688)
11	App\Repository\ReportRepository->findByAllowedCategories (line 44)
12	App\Controller\LogController->index (line 38)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 32)
18	require_once (line 5)

1.75 ms
(2.58%)

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2, t0_.active AS active_3, t0_.description AS description_4, t0_.role AS role_5, t0_.parent_id AS parent_id_6 FROM taxonomy t0_ INNER JOIN taxonomy t1_ ON t0_.parent_id = t1_.id WHERE t1_.slug = ? ORDER BY t0_.name ASC

Parameters:

[
  "report"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.slug AS slug_2,
  t0_.active AS active_3,
  t0_.description AS description_4,
  t0_.role AS role_5,
  t0_.parent_id AS parent_id_6
FROM
  taxonomy t0_
  INNER JOIN taxonomy t1_ ON t0_.parent_id = t1_.id
WHERE
  t1_.slug = ?
ORDER BY
  t0_.name ASC

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2, t0_.active AS active_3, t0_.description AS description_4, t0_.role AS role_5, t0_.parent_id AS parent_id_6 FROM taxonomy t0_ INNER JOIN taxonomy t1_ ON t0_.parent_id = t1_.id WHERE t1_.slug = 'report' ORDER BY t0_.name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\TaxonomyRepository->findByParentSlug (line 83)
7	App\Controller\LogController->index (line 34)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

1.38 ms
(2.04%)

SELECT r0_.id AS id_0, r0_.subject AS subject_1, r0_.content AS content_2, r0_.images AS images_3, r0_.date AS date_4, r0_.created_at AS created_at_5, r0_.updated_at AS updated_at_6, r0_.created_by AS created_by_7, r0_.updated_by AS updated_by_8, r0_.event_type_id AS event_type_id_9, r0_.module_id AS module_id_10, r0_.checklist_id AS checklist_id_11 FROM report r0_ INNER JOIN report_place r2_ ON r0_.id = r2_.report_id INNER JOIN place p1_ ON p1_.id = r2_.place_id WHERE r0_.event_type_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p1_.id = ? ORDER BY r0_.created_at DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.subject AS subject_1,
  r0_.content AS content_2,
  r0_.images AS images_3,
  r0_.date AS date_4,
  r0_.created_at AS created_at_5,
  r0_.updated_at AS updated_at_6,
  r0_.created_by AS created_by_7,
  r0_.updated_by AS updated_by_8,
  r0_.event_type_id AS event_type_id_9,
  r0_.module_id AS module_id_10,
  r0_.checklist_id AS checklist_id_11
FROM
  report r0_
  INNER JOIN report_place r2_ ON r0_.id = r2_.report_id
  INNER JOIN place p1_ ON p1_.id = r2_.place_id
WHERE
  r0_.event_type_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  AND p1_.id = ?
ORDER BY
  r0_.created_at DESC

SELECT r0_.id AS id_0, r0_.subject AS subject_1, r0_.content AS content_2, r0_.images AS images_3, r0_.date AS date_4, r0_.created_at AS created_at_5, r0_.updated_at AS updated_at_6, r0_.created_by AS created_by_7, r0_.updated_by AS updated_by_8, r0_.event_type_id AS event_type_id_9, r0_.module_id AS module_id_10, r0_.checklist_id AS checklist_id_11 FROM report r0_ INNER JOIN report_place r2_ ON r0_.id = r2_.report_id INNER JOIN place p1_ ON p1_.id = r2_.place_id WHERE r0_.event_type_id IN (53, 52, 23, 25, 29, 51, 49, 28, 26, 27, 36, 61, 48) AND p1_.id = 8 ORDER BY r0_.created_at DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\ReportRepository->findByAllowedCategories (line 44)
7	App\Controller\LogController->index (line 38)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

1.20 ms
(1.77%)

SELECT t0.id AS id_1, t0.status AS status_2, t0.opened_at AS opened_at_3, t0.received_at AS received_at_4, t0.user_id AS user_id_5, t0.place_id AS place_id_6, t0.notification_id AS notification_id_7 FROM message t0 WHERE t0.user_id = ?

Parameters:

[
  91
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.opened_at AS opened_at_3,
  t0.received_at AS received_at_4,
  t0.user_id AS user_id_5,
  t0.place_id AS place_id_6,
  t0.notification_id AS notification_id_7
FROM
  message t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.opened_at AS opened_at_3, t0.received_at AS received_at_4, t0.user_id AS user_id_5, t0.place_id AS place_id_6, t0.notification_id AS notification_id_7 FROM message t0 WHERE t0.user_id = 91;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 239)
7	App\Entity\User->getUnreadMessages (line 374)
8	Twig\Extension\CoreExtension->getAttribute (line 1918)
9	__TwigTemplate_4e60d17a3c1fd962262eaf804ad05574::doDisplay (line 52)
10	Twig\Template->yield (line 411)
11	__TwigTemplate_bfac8311b4c4da7355b10300073aeeed->doDisplay (line 332)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_2484deeeadb3227444200e7889efb70d->doDisplay (line 54)
14	Twig\Template->yield (line 411)
15	Twig\Template->display (line 366)
16	Twig\Template->render (line 381)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\LogController->index (line 92)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

1.13 ms
(1.67%)

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.username AS username_2, u0_.role AS role_3, u0_.password AS password_4, u0_.firstname AS firstname_5, u0_.lastname AS lastname_6, u0_.position AS position_7, u0_.user AS user_8, u0_.active AS active_9, u0_.phone AS phone_10, u0_.picture AS picture_11, u0_.plain_password AS plain_password_12, u0_.deleted AS deleted_13, u0_.language AS language_14, u0_.type AS type_15, u0_.created_at AS created_at_16, u0_.updated_at AS updated_at_17, u0_.created_by AS created_by_18, u0_.updated_by AS updated_by_19, u0_.function_id AS function_id_20, u0_.company_id AS company_id_21 FROM user u0_ WHERE u0_.email = ? OR u0_.username = ?

Parameters:

[
  "exploitant.test@test.fr"
  "exploitant.test@test.fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.username AS username_2,
  u0_.role AS role_3,
  u0_.password AS password_4,
  u0_.firstname AS firstname_5,
  u0_.lastname AS lastname_6,
  u0_.position AS position_7,
  u0_.user AS user_8,
  u0_.active AS active_9,
  u0_.phone AS phone_10,
  u0_.picture AS picture_11,
  u0_.plain_password AS plain_password_12,
  u0_.deleted AS deleted_13,
  u0_.language AS language_14,
  u0_.type AS type_15,
  u0_.created_at AS created_at_16,
  u0_.updated_at AS updated_at_17,
  u0_.created_by AS created_by_18,
  u0_.updated_by AS updated_by_19,
  u0_.function_id AS function_id_20,
  u0_.company_id AS company_id_21
FROM
  user u0_
WHERE
  u0_.email = ?
  OR u0_.username = ?

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.username AS username_2, u0_.role AS role_3, u0_.password AS password_4, u0_.firstname AS firstname_5, u0_.lastname AS lastname_6, u0_.position AS position_7, u0_.user AS user_8, u0_.active AS active_9, u0_.phone AS phone_10, u0_.picture AS picture_11, u0_.plain_password AS plain_password_12, u0_.deleted AS deleted_13, u0_.language AS language_14, u0_.type AS type_15, u0_.created_at AS created_at_16, u0_.updated_at AS updated_at_17, u0_.created_by AS created_by_18, u0_.updated_by AS updated_by_19, u0_.function_id AS function_id_20, u0_.company_id AS company_id_21 FROM user u0_ WHERE u0_.email = 'exploitant.test@test.fr' OR u0_.username = 'exploitant.test@test.fr';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Security\UserProvider->loadUserByIdentifier (line 65)
7	App\Security\UserProvider->refreshUser (line 51)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 227)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 132)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->{closure:Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext::authenticate():80} (line 83)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage::getToken (line 34)
13	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 42)
14	App\EventSubscriber\UserLocaleSubscriber->onKernelRequest (line 38)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

0.94 ms
(1.38%)

SELECT r0_.id AS id_0, r0_.subject AS subject_1, r0_.content AS content_2, r0_.images AS images_3, r0_.date AS date_4, r0_.created_at AS created_at_5, r0_.updated_at AS updated_at_6, r0_.created_by AS created_by_7, r0_.updated_by AS updated_by_8, r0_.event_type_id AS event_type_id_9, r0_.module_id AS module_id_10, r0_.checklist_id AS checklist_id_11 FROM report r0_ INNER JOIN report_place r2_ ON r0_.id = r2_.report_id INNER JOIN place p1_ ON p1_.id = r2_.place_id WHERE r0_.event_type_id IN (?, ?, ?, ?) AND p1_.id = ? ORDER BY r0_.created_at DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.subject AS subject_1,
  r0_.content AS content_2,
  r0_.images AS images_3,
  r0_.date AS date_4,
  r0_.created_at AS created_at_5,
  r0_.updated_at AS updated_at_6,
  r0_.created_by AS created_by_7,
  r0_.updated_by AS updated_by_8,
  r0_.event_type_id AS event_type_id_9,
  r0_.module_id AS module_id_10,
  r0_.checklist_id AS checklist_id_11
FROM
  report r0_
  INNER JOIN report_place r2_ ON r0_.id = r2_.report_id
  INNER JOIN place p1_ ON p1_.id = r2_.place_id
WHERE
  r0_.event_type_id IN (?, ?, ?, ?)
  AND p1_.id = ?
ORDER BY
  r0_.created_at DESC

SELECT r0_.id AS id_0, r0_.subject AS subject_1, r0_.content AS content_2, r0_.images AS images_3, r0_.date AS date_4, r0_.created_at AS created_at_5, r0_.updated_at AS updated_at_6, r0_.created_by AS created_by_7, r0_.updated_by AS updated_by_8, r0_.event_type_id AS event_type_id_9, r0_.module_id AS module_id_10, r0_.checklist_id AS checklist_id_11 FROM report r0_ INNER JOIN report_place r2_ ON r0_.id = r2_.report_id INNER JOIN place p1_ ON p1_.id = r2_.place_id WHERE r0_.event_type_id IN (68, 69, 67, 54) AND p1_.id = 8 ORDER BY r0_.created_at DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\ReportRepository->findByAllowedCategories (line 44)
7	App\Controller\LogController->index (line 39)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.85 ms
(1.26%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.city AS city_4, t0.country AS country_5, t0.postalcode AS postalcode_6, t0.address AS address_7, t0.active AS active_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.webcam_url AS webcam_url_11, t0.weather_station_id AS weather_station_id_12, t0.water_station_id AS water_station_id_13, t0.opening_hours AS opening_hours_14, t0.max_people AS max_people_15, t0.picture AS picture_16, t0.strymo_station_id AS strymo_station_id_17, t0.jauge_url AS jauge_url_18, t0.preview_code AS preview_code_19, t0.control_code AS control_code_20, t0.link AS link_21, t0.boazcreate AS boazcreate_22, t0.pict3d AS pict3d_23, t0.drive_directory AS drive_directory_24, t0.opening_days AS opening_days_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.created_by AS created_by_28, t0.updated_by AS updated_by_29, t0.client_id AS client_id_30 FROM place t0 INNER JOIN user_place ON t0.id = user_place.place_id WHERE user_place.user_id = ?

Parameters:

[
  91
]

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.city AS city_4,
  t0.country AS country_5,
  t0.postalcode AS postalcode_6,
  t0.address AS address_7,
  t0.active AS active_8,
  t0.latitude AS latitude_9,
  t0.longitude AS longitude_10,
  t0.webcam_url AS webcam_url_11,
  t0.weather_station_id AS weather_station_id_12,
  t0.water_station_id AS water_station_id_13,
  t0.opening_hours AS opening_hours_14,
  t0.max_people AS max_people_15,
  t0.picture AS picture_16,
  t0.strymo_station_id AS strymo_station_id_17,
  t0.jauge_url AS jauge_url_18,
  t0.preview_code AS preview_code_19,
  t0.control_code AS control_code_20,
  t0.link AS link_21,
  t0.boazcreate AS boazcreate_22,
  t0.pict3d AS pict3d_23,
  t0.drive_directory AS drive_directory_24,
  t0.opening_days AS opening_days_25,
  t0.created_at AS created_at_26,
  t0.updated_at AS updated_at_27,
  t0.created_by AS created_by_28,
  t0.updated_by AS updated_by_29,
  t0.client_id AS client_id_30
FROM
  place t0
  INNER JOIN user_place ON t0.id = user_place.place_id
WHERE
  user_place.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.city AS city_4, t0.country AS country_5, t0.postalcode AS postalcode_6, t0.address AS address_7, t0.active AS active_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.webcam_url AS webcam_url_11, t0.weather_station_id AS weather_station_id_12, t0.water_station_id AS water_station_id_13, t0.opening_hours AS opening_hours_14, t0.max_people AS max_people_15, t0.picture AS picture_16, t0.strymo_station_id AS strymo_station_id_17, t0.jauge_url AS jauge_url_18, t0.preview_code AS preview_code_19, t0.control_code AS control_code_20, t0.link AS link_21, t0.boazcreate AS boazcreate_22, t0.pict3d AS pict3d_23, t0.drive_directory AS drive_directory_24, t0.opening_days AS opening_days_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.created_by AS created_by_28, t0.updated_by AS updated_by_29, t0.client_id AS client_id_30 FROM place t0 INNER JOIN user_place ON t0.id = user_place.place_id WHERE user_place.user_id = 91;

#	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 2737)
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	Twig\Extension\CoreExtension->length (line 1278)
9	__TwigTemplate_8dc66f9026c6a26f27e12233694adec3::doDisplay (line 59)
10	Twig\Template->yield (line 411)
11	__TwigTemplate_bfac8311b4c4da7355b10300073aeeed->doDisplay (line 179)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_2484deeeadb3227444200e7889efb70d->doDisplay (line 54)
14	Twig\Template->yield (line 411)
15	Twig\Template->display (line 366)
16	Twig\Template->render (line 381)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\LogController->index (line 92)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

0.85 ms
(1.25%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.city AS city_4, t0.country AS country_5, t0.postalcode AS postalcode_6, t0.address AS address_7, t0.active AS active_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.webcam_url AS webcam_url_11, t0.weather_station_id AS weather_station_id_12, t0.water_station_id AS water_station_id_13, t0.opening_hours AS opening_hours_14, t0.max_people AS max_people_15, t0.picture AS picture_16, t0.strymo_station_id AS strymo_station_id_17, t0.jauge_url AS jauge_url_18, t0.preview_code AS preview_code_19, t0.control_code AS control_code_20, t0.link AS link_21, t0.boazcreate AS boazcreate_22, t0.pict3d AS pict3d_23, t0.drive_directory AS drive_directory_24, t0.opening_days AS opening_days_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.created_by AS created_by_28, t0.updated_by AS updated_by_29, t0.client_id AS client_id_30 FROM place t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "demo-aquapark"
]

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.city AS city_4,
  t0.country AS country_5,
  t0.postalcode AS postalcode_6,
  t0.address AS address_7,
  t0.active AS active_8,
  t0.latitude AS latitude_9,
  t0.longitude AS longitude_10,
  t0.webcam_url AS webcam_url_11,
  t0.weather_station_id AS weather_station_id_12,
  t0.water_station_id AS water_station_id_13,
  t0.opening_hours AS opening_hours_14,
  t0.max_people AS max_people_15,
  t0.picture AS picture_16,
  t0.strymo_station_id AS strymo_station_id_17,
  t0.jauge_url AS jauge_url_18,
  t0.preview_code AS preview_code_19,
  t0.control_code AS control_code_20,
  t0.link AS link_21,
  t0.boazcreate AS boazcreate_22,
  t0.pict3d AS pict3d_23,
  t0.drive_directory AS drive_directory_24,
  t0.opening_days AS opening_days_25,
  t0.created_at AS created_at_26,
  t0.updated_at AS updated_at_27,
  t0.created_by AS created_by_28,
  t0.updated_by AS updated_by_29,
  t0.client_id AS client_id_30
FROM
  place t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.city AS city_4, t0.country AS country_5, t0.postalcode AS postalcode_6, t0.address AS address_7, t0.active AS active_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.webcam_url AS webcam_url_11, t0.weather_station_id AS weather_station_id_12, t0.water_station_id AS water_station_id_13, t0.opening_hours AS opening_hours_14, t0.max_people AS max_people_15, t0.picture AS picture_16, t0.strymo_station_id AS strymo_station_id_17, t0.jauge_url AS jauge_url_18, t0.preview_code AS preview_code_19, t0.control_code AS control_code_20, t0.link AS link_21, t0.boazcreate AS boazcreate_22, t0.pict3d AS pict3d_23, t0.drive_directory AS drive_directory_24, t0.opening_days AS opening_days_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.created_by AS created_by_28, t0.updated_by AS updated_by_29, t0.client_id AS client_id_30 FROM place t0 WHERE t0.slug = 'demo-aquapark' 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\ArgumentResolver\PlaceValueResolver->resolve (line 30)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.74 ms
(1.09%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4, t0.description AS description_5, t0.role AS role_6, t0.parent_id AS parent_id_7 FROM taxonomy t0 INNER JOIN place_taxonomy ON t0.id = place_taxonomy.taxonomy_id WHERE place_taxonomy.place_id = ?

Parameters:

[
  8
]

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.active AS active_4,
  t0.description AS description_5,
  t0.role AS role_6,
  t0.parent_id AS parent_id_7
FROM
  taxonomy t0
  INNER JOIN place_taxonomy ON t0.id = place_taxonomy.taxonomy_id
WHERE
  place_taxonomy.place_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4, t0.description AS description_5, t0.role AS role_6, t0.parent_id AS parent_id_7 FROM taxonomy t0 INNER JOIN place_taxonomy ON t0.id = place_taxonomy.taxonomy_id WHERE place_taxonomy.place_id = 8;

#	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 2737)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Service\PlaceService->hasCategory (line 69)
8	Twig\Extension\CoreExtension->getAttribute (line 1918)
9	__TwigTemplate_1dae860385bd1089f0a9578e2866c131::doDisplay (line 172)
10	Twig\Template->yield (line 411)
11	__TwigTemplate_bfac8311b4c4da7355b10300073aeeed->block_sidebar_menu (line 470)
12	Twig\Template->yieldBlock (line 456)
13	__TwigTemplate_bfac8311b4c4da7355b10300073aeeed->doDisplay (line 184)
14	Twig\Template->yield (line 411)
15	__TwigTemplate_2484deeeadb3227444200e7889efb70d->doDisplay (line 54)
16	Twig\Template->yield (line 411)
17	Twig\Template->display (line 366)
18	Twig\Template->render (line 381)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
24	App\Controller\LogController->index (line 92)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

0.64 ms
(0.95%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.logo AS logo_4, t0.cover AS cover_5, t0.color AS color_6, t0.active AS active_7, t0.domain AS domain_8, t0.preview_code AS preview_code_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13 FROM client t0 WHERE t0.id = ?

Parameters:

[
  8
]

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.logo AS logo_4,
  t0.cover AS cover_5,
  t0.color AS color_6,
  t0.active AS active_7,
  t0.domain AS domain_8,
  t0.preview_code AS preview_code_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.created_by AS created_by_12,
  t0.updated_by AS updated_by_13
FROM
  client t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.logo AS logo_4, t0.cover AS cover_5, t0.color AS color_6, t0.active AS active_7, t0.domain AS domain_8, t0.preview_code AS preview_code_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13 FROM client t0 WHERE t0.id = 8;

#	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->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Entity\Client::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Client->__get (line 153)
7	App\Entity\Client->getSlug (line 193)
8	Twig\Extension\CoreExtension->getAttribute (line 1918)
9	__TwigTemplate_8dc66f9026c6a26f27e12233694adec3::doDisplay (line 65)
10	Twig\Template->yield (line 411)
11	__TwigTemplate_bfac8311b4c4da7355b10300073aeeed->doDisplay (line 179)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_2484deeeadb3227444200e7889efb70d->doDisplay (line 54)
14	Twig\Template->yield (line 411)
15	Twig\Template->display (line 366)
16	Twig\Template->render (line 381)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\LogController->index (line 92)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	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\Message	77
App\Entity\Notification	77
App\Entity\Checklist	57
App\Entity\Taxonomy	21
App\Entity\Report	18
App\Entity\Structure	4
App\Entity\Place	2
App\Entity\User	1
App\Entity\Client	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Taxonomy	No errors.
App\Entity\Company	No errors.
App\Entity\Place	The association App\Entity\Place#category refers to the inverse side field App\Entity\Taxonomy#places which does not exist.
App\Entity\Message	No errors.
App\Entity\Notification	No errors.
App\Entity\Document	No errors.
App\Entity\Client	No errors.
App\Entity\Report	The field App\Entity\Report#taskDones is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\TaskDone#report does not contain the required 'inversedBy: "taskDones"' attribute.
App\Entity\Water	No errors.
App\Entity\Weather	No errors.
App\Entity\Status	No errors.
App\Entity\Webcam	No errors.
App\Entity\Metric	No errors.
App\Entity\Widget	No errors.
App\Entity\Structure	No errors.
App\Entity\News	No errors.
App\Entity\Task	No errors.
App\Entity\Tutorial	No errors.
App\Entity\Checklist	No errors.
App\Entity\Parameter	No errors.
App\Entity\TaskDone	No errors.
App\Entity\Todo	The association App\Entity\Todo#project refers to the inverse side field App\Entity\Taxonomy#todos which does not exist.
App\Entity\Chat	No errors.

Symfony Profiler

GET https://dev.boaz-connect.fr/fr/place/demo-aquapark/logs/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping