Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

14.50 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

2.02 ms

SELECT DISTINCT UPPER(SUBSTRING(b0_.name FROM 1 FOR 1)) AS sclr_0 FROM band b0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT UPPER(
    SUBSTRING(
      b0_.name
      FROM
        1 FOR 1
    )
  ) AS sclr_0
FROM
  band b0_

SELECT DISTINCT UPPER(SUBSTRING(b0_.name FROM 1 FOR 1)) AS sclr_0 FROM band b0_;

#	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\BandRepository->getBandsFirstsLetter (line 109)
7	App\Domain\Band\QueryHandler\BandGetAllFirstsLettersQueryHandler->__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\BandController->index (line 89)
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)

1.77 ms

SELECT COUNT(b0_.id) AS sclr_0 FROM band b0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  band b0_

SELECT COUNT(b0_.id) AS sclr_0 FROM band b0_;

#	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\BandRepository->countByFirstLetter (line 173)
8	App\Domain\Band\QueryHandler\BandCountAllByFirstLetterQueryHandler->__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\BandController->index (line 94)
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)

10.71 ms

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, name_2 FROM (SELECT b0_.id AS id_0, b0_.active AS active_1, b0_.name AS name_2, b0_.slug AS slug_3, b0_.foundation_year AS foundation_year_4, b0_.website AS website_5, b0_.facebook AS facebook_6, b0_.instagram AS instagram_7, b0_.tiktok AS tiktok_8, b0_.soundcloud AS soundcloud_9, b0_.youtube AS youtube_10, b0_.discord AS discord_11, b0_.twitter AS twitter_12, b0_.spotify AS spotify_13, b0_.twitch AS twitch_14, b0_.bandsintown AS bandsintown_15, b0_.bandsintown_api_key AS bandsintown_api_key_16, b0_.cover_name AS cover_name_17, b0_.cover_thumb AS cover_thumb_18, b0_.date_add AS date_add_19, b0_.date_upd AS date_upd_20, b0_.total_points AS total_points_21, b0_.ranking_position AS ranking_position_22, b1_.id AS id_23, b1_.description_short AS description_short_24, b1_.description AS description_25, b1_.date_add AS date_add_26, b1_.date_upd AS date_upd_27, b2_.id AS id_28, b2_.type AS type_29, b2_.file_name AS file_name_30, b2_.position AS position_31, b2_.date_add AS date_add_32, t3_.id AS id_33, t3_.min_points AS min_points_34, t3_.position AS position_35, t3_.badge AS badge_36, t3_.stars AS stars_37, t3_.hex_code AS hex_code_38, t3_.date_add AS date_add_39, t3_.date_upd AS date_upd_40, t4_.id AS id_41, t4_.name AS name_42, m5_.id AS id_43, m5_.position AS position_44, m5_.active AS active_45, m5_.date_add AS date_add_46, m5_.date_upd AS date_upd_47, m6_.id AS id_48, m6_.name AS name_49 FROM band b0_ LEFT JOIN band_lang b1_ ON b0_.id = b1_.band_id AND (b0_.id = b1_.band_id AND b1_.lang_id = ?) LEFT JOIN band_media b2_ ON b0_.id = b2_.band_id LEFT JOIN tier t3_ ON b0_.current_tier_id = t3_.id LEFT JOIN tier_lang t4_ ON t3_.id = t4_.tier_id AND (t3_.id = t4_.tier_id AND t4_.language_id = ?) LEFT JOIN band_music_genre b7_ ON b0_.id = b7_.band_id LEFT JOIN music_genre m5_ ON m5_.id = b7_.music_genre_id LEFT JOIN music_genre_lang m6_ ON m5_.id = m6_.music_genre_id AND (m6_.language_id = ?) ORDER BY b2_.position ASC) dctrn_result_inner ORDER BY name_2 ASC) dctrn_result LIMIT 12

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      name_2
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.active AS active_1,
          b0_.name AS name_2,
          b0_.slug AS slug_3,
          b0_.foundation_year AS foundation_year_4,
          b0_.website AS website_5,
          b0_.facebook AS facebook_6,
          b0_.instagram AS instagram_7,
          b0_.tiktok AS tiktok_8,
          b0_.soundcloud AS soundcloud_9,
          b0_.youtube AS youtube_10,
          b0_.discord AS discord_11,
          b0_.twitter AS twitter_12,
          b0_.spotify AS spotify_13,
          b0_.twitch AS twitch_14,
          b0_.bandsintown AS bandsintown_15,
          b0_.bandsintown_api_key AS bandsintown_api_key_16,
          b0_.cover_name AS cover_name_17,
          b0_.cover_thumb AS cover_thumb_18,
          b0_.date_add AS date_add_19,
          b0_.date_upd AS date_upd_20,
          b0_.total_points AS total_points_21,
          b0_.ranking_position AS ranking_position_22,
          b1_.id AS id_23,
          b1_.description_short AS description_short_24,
          b1_.description AS description_25,
          b1_.date_add AS date_add_26,
          b1_.date_upd AS date_upd_27,
          b2_.id AS id_28,
          b2_.type AS type_29,
          b2_.file_name AS file_name_30,
          b2_.position AS position_31,
          b2_.date_add AS date_add_32,
          t3_.id AS id_33,
          t3_.min_points AS min_points_34,
          t3_.position AS position_35,
          t3_.badge AS badge_36,
          t3_.stars AS stars_37,
          t3_.hex_code AS hex_code_38,
          t3_.date_add AS date_add_39,
          t3_.date_upd AS date_upd_40,
          t4_.id AS id_41,
          t4_.name AS name_42,
          m5_.id AS id_43,
          m5_.position AS position_44,
          m5_.active AS active_45,
          m5_.date_add AS date_add_46,
          m5_.date_upd AS date_upd_47,
          m6_.id AS id_48,
          m6_.name AS name_49
        FROM
          band b0_
          LEFT JOIN band_lang b1_ ON b0_.id = b1_.band_id
          AND (
            b0_.id = b1_.band_id
            AND b1_.lang_id = ?
          )
          LEFT JOIN band_media b2_ ON b0_.id = b2_.band_id
          LEFT JOIN tier t3_ ON b0_.current_tier_id = t3_.id
          LEFT JOIN tier_lang t4_ ON t3_.id = t4_.tier_id
          AND (
            t3_.id = t4_.tier_id
            AND t4_.language_id = ?
          )
          LEFT JOIN band_music_genre b7_ ON b0_.id = b7_.band_id
          LEFT JOIN music_genre m5_ ON m5_.id = b7_.music_genre_id
          LEFT JOIN music_genre_lang m6_ ON m5_.id = m6_.music_genre_id
          AND (m6_.language_id = ?)
        ORDER BY
          b2_.position ASC
      ) dctrn_result_inner
    ORDER BY
      name_2 ASC
  ) dctrn_result
LIMIT
  12

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, name_2 FROM (SELECT b0_.id AS id_0, b0_.active AS active_1, b0_.name AS name_2, b0_.slug AS slug_3, b0_.foundation_year AS foundation_year_4, b0_.website AS website_5, b0_.facebook AS facebook_6, b0_.instagram AS instagram_7, b0_.tiktok AS tiktok_8, b0_.soundcloud AS soundcloud_9, b0_.youtube AS youtube_10, b0_.discord AS discord_11, b0_.twitter AS twitter_12, b0_.spotify AS spotify_13, b0_.twitch AS twitch_14, b0_.bandsintown AS bandsintown_15, b0_.bandsintown_api_key AS bandsintown_api_key_16, b0_.cover_name AS cover_name_17, b0_.cover_thumb AS cover_thumb_18, b0_.date_add AS date_add_19, b0_.date_upd AS date_upd_20, b0_.total_points AS total_points_21, b0_.ranking_position AS ranking_position_22, b1_.id AS id_23, b1_.description_short AS description_short_24, b1_.description AS description_25, b1_.date_add AS date_add_26, b1_.date_upd AS date_upd_27, b2_.id AS id_28, b2_.type AS type_29, b2_.file_name AS file_name_30, b2_.position AS position_31, b2_.date_add AS date_add_32, t3_.id AS id_33, t3_.min_points AS min_points_34, t3_.position AS position_35, t3_.badge AS badge_36, t3_.stars AS stars_37, t3_.hex_code AS hex_code_38, t3_.date_add AS date_add_39, t3_.date_upd AS date_upd_40, t4_.id AS id_41, t4_.name AS name_42, m5_.id AS id_43, m5_.position AS position_44, m5_.active AS active_45, m5_.date_add AS date_add_46, m5_.date_upd AS date_upd_47, m6_.id AS id_48, m6_.name AS name_49 FROM band b0_ LEFT JOIN band_lang b1_ ON b0_.id = b1_.band_id AND (b0_.id = b1_.band_id AND b1_.lang_id = 1) LEFT JOIN band_media b2_ ON b0_.id = b2_.band_id LEFT JOIN tier t3_ ON b0_.current_tier_id = t3_.id LEFT JOIN tier_lang t4_ ON t3_.id = t4_.tier_id AND (t3_.id = t4_.tier_id AND t4_.language_id = 1) LEFT JOIN band_music_genre b7_ ON b0_.id = b7_.band_id LEFT JOIN music_genre m5_ ON m5_.id = b7_.music_genre_id LEFT JOIN music_genre_lang m6_ ON m5_.id = m6_.music_genre_id AND (m6_.language_id = 1) ORDER BY b2_.position ASC) dctrn_result_inner ORDER BY name_2 ASC) dctrn_result LIMIT 12;

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	App\Repository\BandRepository->findByFirstLetter (line 155)
8	App\Domain\Band\QueryHandler\BandGetAllByFiltersQueryHandler->__invoke (line 39)
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\BandController->index (line 103)
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)

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\Band	No errors.
App\Entity\BandLang	No errors.
App\Entity\BandMedia	No errors.
App\Entity\Tier	No errors.
App\Entity\TierLang	No errors.
App\Entity\MusicGenre	No errors.
App\Entity\MusicGenreLang	No errors.

Symfony Profiler

GET https://docker.dev.localero.it/band/elenco

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping