Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

2.79 ms Query time

0 Invalid entities

0 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Queries

Group similar statements

default connection

#▲

Time

Info

1.08 ms

SELECT DISTINCT UPPER(SUBSTRING(v0_.name FROM 1 FOR 1)) AS sclr_0 FROM venue v0_ WHERE v0_.type IN (?) AND (EXISTS (SELECT 1 AS sclr_1 FROM event e1_ WHERE e1_.venue_id = v0_.id AND e1_.active = 1 AND e1_.deleted = 0 AND e1_.venue_pending = 0))

Parameters:

[
  "PHYSICAL_VENUE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT UPPER(
    SUBSTRING(
      v0_.name
      FROM
        1 FOR 1
    )
  ) AS sclr_0
FROM
  venue v0_
WHERE
  v0_.type IN (?)
  AND (
    EXISTS (
      SELECT
        1 AS sclr_1
      FROM
        event e1_
      WHERE
        e1_.venue_id = v0_.id
        AND e1_.active = 1
        AND e1_.deleted = 0
        AND e1_.venue_pending = 0
    )
  )

SELECT DISTINCT UPPER(SUBSTRING(v0_.name FROM 1 FOR 1)) AS sclr_0 FROM venue v0_ WHERE v0_.type IN ('PHYSICAL_VENUE') AND (EXISTS (SELECT 1 AS sclr_1 FROM event e1_ WHERE e1_.venue_id = v0_.id AND e1_.active = 1 AND e1_.deleted = 0 AND e1_.venue_pending = 0));

#	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\VenueRepository->getVenuesFirstsLetter (line 32)
7	App\Domain\Venue\QueryHandler\VenueGetAllFirstsLettersQueryHandler->__invoke (line 18)
8	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 152)
9	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 91)
10	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 71)
11	Symfony\Component\Messenger\Middleware\ValidationMiddleware->handle (line 45)
12	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
13	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
14	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
15	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 37)
16	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 40)
17	Symfony\Component\Messenger\MessageBus->dispatch (line 70)
18	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 38)
19	App\Controller\Front\VenuesController->index (line 49)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 208)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

0.81 ms

SELECT COUNT(v0_.id) AS sclr_0 FROM venue v0_ LEFT JOIN venue_lang v1_ ON v0_.id = v1_.venue_id AND (v0_.id = v1_.venue_id AND v1_.language_id = ?) WHERE v0_.type IN (?) AND (EXISTS (SELECT 1 AS sclr_1 FROM event e2_ WHERE e2_.venue_id = v0_.id AND e2_.active = 1 AND e2_.deleted = 0 AND e2_.venue_pending = 0))

Parameters:

[
  2
  "PHYSICAL_VENUE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(v0_.id) AS sclr_0
FROM
  venue v0_
  LEFT JOIN venue_lang v1_ ON v0_.id = v1_.venue_id
  AND (
    v0_.id = v1_.venue_id
    AND v1_.language_id = ?
  )
WHERE
  v0_.type IN (?)
  AND (
    EXISTS (
      SELECT
        1 AS sclr_1
      FROM
        event e2_
      WHERE
        e2_.venue_id = v0_.id
        AND e2_.active = 1
        AND e2_.deleted = 0
        AND e2_.venue_pending = 0
    )
  )

SELECT COUNT(v0_.id) AS sclr_0 FROM venue v0_ LEFT JOIN venue_lang v1_ ON v0_.id = v1_.venue_id AND (v0_.id = v1_.venue_id AND v1_.language_id = 2) WHERE v0_.type IN ('PHYSICAL_VENUE') AND (EXISTS (SELECT 1 AS sclr_1 FROM event e2_ WHERE e2_.venue_id = v0_.id AND e2_.active = 1 AND e2_.deleted = 0 AND e2_.venue_pending = 0));

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Repository\VenueRepository->countByFirstLetter (line 113)
8	App\Domain\Venue\QueryHandler\VenueCountAllByFirstLetterQueryHandler->__invoke (line 18)
9	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 152)
10	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 91)
11	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 71)
12	Symfony\Component\Messenger\Middleware\ValidationMiddleware->handle (line 45)
13	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
14	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
15	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
16	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 37)
17	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 40)
18	Symfony\Component\Messenger\MessageBus->dispatch (line 70)
19	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 38)
20	App\Controller\Front\VenuesController->index (line 54)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 208)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.91 ms

SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.address AS address_2, v0_.phone AS phone_3, v0_.latitude AS latitude_4, v0_.longitude AS longitude_5, v0_.email AS email_6, v0_.www AS www_7, v0_.facebook AS facebook_8, v0_.twitter AS twitter_9, v0_.soundcloud AS soundcloud_10, v0_.youtube AS youtube_11, v0_.status AS status_12, v0_.type AS type_13, v0_.google_place_id AS google_place_id_14, v0_.slug AS slug_15, v0_.date_add AS date_add_16, v0_.date_upd AS date_upd_17, v1_.excerpt AS excerpt_18, v1_.description AS description_19, v1_.opening_time AS opening_time_20, v1_.event_time AS event_time_21, v1_.instrumentation AS instrumentation_22, v1_.stage AS stage_23, v1_.service AS service_24, v1_.checksound_time AS checksound_time_25, v1_.more_info AS more_info_26, v0_.user_id AS user_id_27, v0_.city_id AS city_id_28, v1_.venue_id AS venue_id_29, v1_.language_id AS language_id_30 FROM venue v0_ LEFT JOIN venue_lang v1_ ON v0_.id = v1_.venue_id AND (v0_.id = v1_.venue_id AND v1_.language_id = ?) WHERE v0_.type IN (?) AND (EXISTS (SELECT 1 AS sclr_31 FROM event e2_ WHERE e2_.venue_id = v0_.id AND e2_.active = 1 AND e2_.deleted = 0 AND e2_.venue_pending = 0)) ORDER BY v0_.name ASC LIMIT 9

Parameters:

[
  2
  "PHYSICAL_VENUE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.name AS name_1,
  v0_.address AS address_2,
  v0_.phone AS phone_3,
  v0_.latitude AS latitude_4,
  v0_.longitude AS longitude_5,
  v0_.email AS email_6,
  v0_.www AS www_7,
  v0_.facebook AS facebook_8,
  v0_.twitter AS twitter_9,
  v0_.soundcloud AS soundcloud_10,
  v0_.youtube AS youtube_11,
  v0_.status AS status_12,
  v0_.type AS type_13,
  v0_.google_place_id AS google_place_id_14,
  v0_.slug AS slug_15,
  v0_.date_add AS date_add_16,
  v0_.date_upd AS date_upd_17,
  v1_.excerpt AS excerpt_18,
  v1_.description AS description_19,
  v1_.opening_time AS opening_time_20,
  v1_.event_time AS event_time_21,
  v1_.instrumentation AS instrumentation_22,
  v1_.stage AS stage_23,
  v1_.service AS service_24,
  v1_.checksound_time AS checksound_time_25,
  v1_.more_info AS more_info_26,
  v0_.user_id AS user_id_27,
  v0_.city_id AS city_id_28,
  v1_.venue_id AS venue_id_29,
  v1_.language_id AS language_id_30
FROM
  venue v0_
  LEFT JOIN venue_lang v1_ ON v0_.id = v1_.venue_id
  AND (
    v0_.id = v1_.venue_id
    AND v1_.language_id = ?
  )
WHERE
  v0_.type IN (?)
  AND (
    EXISTS (
      SELECT
        1 AS sclr_31
      FROM
        event e2_
      WHERE
        e2_.venue_id = v0_.id
        AND e2_.active = 1
        AND e2_.deleted = 0
        AND e2_.venue_pending = 0
    )
  )
ORDER BY
  v0_.name ASC
LIMIT
  9

SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.address AS address_2, v0_.phone AS phone_3, v0_.latitude AS latitude_4, v0_.longitude AS longitude_5, v0_.email AS email_6, v0_.www AS www_7, v0_.facebook AS facebook_8, v0_.twitter AS twitter_9, v0_.soundcloud AS soundcloud_10, v0_.youtube AS youtube_11, v0_.status AS status_12, v0_.type AS type_13, v0_.google_place_id AS google_place_id_14, v0_.slug AS slug_15, v0_.date_add AS date_add_16, v0_.date_upd AS date_upd_17, v1_.excerpt AS excerpt_18, v1_.description AS description_19, v1_.opening_time AS opening_time_20, v1_.event_time AS event_time_21, v1_.instrumentation AS instrumentation_22, v1_.stage AS stage_23, v1_.service AS service_24, v1_.checksound_time AS checksound_time_25, v1_.more_info AS more_info_26, v0_.user_id AS user_id_27, v0_.city_id AS city_id_28, v1_.venue_id AS venue_id_29, v1_.language_id AS language_id_30 FROM venue v0_ LEFT JOIN venue_lang v1_ ON v0_.id = v1_.venue_id AND (v0_.id = v1_.venue_id AND v1_.language_id = 2) WHERE v0_.type IN ('PHYSICAL_VENUE') AND (EXISTS (SELECT 1 AS sclr_31 FROM event e2_ WHERE e2_.venue_id = v0_.id AND e2_.active = 1 AND e2_.deleted = 0 AND e2_.venue_pending = 0)) ORDER BY v0_.name ASC LIMIT 9;

#	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\VenueRepository->findByFirstLetter (line 79)
7	App\Domain\Venue\QueryHandler\VenueGetAllByFiltersQueryHandler->__invoke (line 18)
8	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 152)
9	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 91)
10	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 71)
11	Symfony\Component\Messenger\Middleware\ValidationMiddleware->handle (line 45)
12	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
13	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
14	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
15	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 37)
16	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 40)
17	Symfony\Component\Messenger\MessageBus->dispatch (line 70)
18	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 38)
19	App\Controller\Front\VenuesController->index (line 63)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 208)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
messenger	doctrine.dbal.messenger_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

0 Hits

0 Misses

0 Puts

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

Class	Mapping errors
App\Entity\Venue	No errors.
App\Entity\Event	No errors.
App\Entity\VenueLang	No errors.
App\Entity\User	No errors.
App\Entity\City	No errors.
App\Entity\Lang	No errors.

Symfony Profiler

GET https://docker.dev.localero.it/venues

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping