Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

4.34 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.66 ms

SELECT DISTINCT UPPER(SUBSTRING(a0_.nickname FROM 1 FOR 1)) AS sclr_0 FROM artist a0_ WHERE a0_.nickname IS NOT NULL AND (a0_.nickname REGEXP ?) = 0 AND a0_.avatar_name IS NOT NULL

Parameters:

[
  "^artist_[0-9]+$"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT UPPER(
    SUBSTRING(
      a0_.nickname
      FROM
        1 FOR 1
    )
  ) AS sclr_0
FROM
  artist a0_
WHERE
  a0_.nickname IS NOT NULL
  AND (a0_.nickname REGEXP ?) = 0
  AND a0_.avatar_name IS NOT NULL

SELECT DISTINCT UPPER(SUBSTRING(a0_.nickname FROM 1 FOR 1)) AS sclr_0 FROM artist a0_ WHERE a0_.nickname IS NOT NULL AND (a0_.nickname REGEXP '^artist_[0-9]+$') = 0 AND a0_.avatar_name IS NOT NULL;

#	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\ArtistRepository->getArtistsFirstsLetter (line 196)
7	App\Domain\Artist\QueryHandler\ArtistGetAllFirstsLettersQueryHandler->__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\ArtistsController->index (line 41)
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.34 ms

SELECT COUNT(a0_.id) AS sclr_0 FROM artist a0_ LEFT JOIN artist_lang a1_ ON a0_.id = a1_.artist_id AND (a0_.id = a1_.artist_id AND a1_.language_id = ?) WHERE a0_.nickname IS NOT NULL AND (a0_.nickname REGEXP ?) = 0 AND a0_.avatar_name IS NOT NULL

Parameters:

[
  2
  "^artist_[0-9]+$"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  artist a0_
  LEFT JOIN artist_lang a1_ ON a0_.id = a1_.artist_id
  AND (
    a0_.id = a1_.artist_id
    AND a1_.language_id = ?
  )
WHERE
  a0_.nickname IS NOT NULL
  AND (a0_.nickname REGEXP ?) = 0
  AND a0_.avatar_name IS NOT NULL

SELECT COUNT(a0_.id) AS sclr_0 FROM artist a0_ LEFT JOIN artist_lang a1_ ON a0_.id = a1_.artist_id AND (a0_.id = a1_.artist_id AND a1_.language_id = 2) WHERE a0_.nickname IS NOT NULL AND (a0_.nickname REGEXP '^artist_[0-9]+$') = 0 AND a0_.avatar_name IS NOT NULL;

#	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\ArtistRepository->countByFirstLetter (line 273)
8	App\Domain\Artist\QueryHandler\ArtistCountAllByFirstLetterQueryHandler->__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\ArtistsController->index (line 46)
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)

1.34 ms

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, nickname_3 FROM (SELECT a0_.id AS id_0, a0_.firstname AS firstname_1, a0_.lastname AS lastname_2, a0_.nickname AS nickname_3, a0_.slug AS slug_4, a0_.excerpt AS excerpt_5, a0_.mood AS mood_6, a0_.exhibition AS exhibition_7, a0_.crew AS crew_8, a0_.biography AS biography_9, a0_.original AS original_10, a0_.cover AS cover_11, a0_.instrumentation AS instrumentation_12, a0_.willingness AS willingness_13, a0_.www AS www_14, a0_.facebook AS facebook_15, a0_.twitter AS twitter_16, a0_.soundcloud AS soundcloud_17, a0_.youtube AS youtube_18, a0_.avatar AS avatar_19, a0_.wide AS wide_20, a0_.thumb AS thumb_21, a0_.privacy AS privacy_22, a0_.solo_artist AS solo_artist_23, a0_.avatar_name AS avatar_name_24, a0_.avatar_thumb_name AS avatar_thumb_name_25, a0_.cover_name AS cover_name_26, a0_.date_add AS date_add_27, a0_.date_upd AS date_upd_28, a0_.last_inactivity_reminder_at AS last_inactivity_reminder_at_29, a1_.id AS id_30, a1_.excerpt AS excerpt_31, a1_.mood AS mood_32, a1_.exhibition AS exhibition_33, a1_.crew AS crew_34, a1_.biography AS biography_35, a2_.id AS id_36, a2_.active AS active_37, a2_.icon AS icon_38, a2_.date_add AS date_add_39, a2_.date_upd AS date_upd_40 FROM artist a0_ LEFT JOIN artist_lang a1_ ON a0_.id = a1_.artist_id AND (a0_.id = a1_.artist_id AND a1_.language_id = ?) LEFT JOIN artist_artist_type a3_ ON a0_.id = a3_.artist_id LEFT JOIN artist_type a2_ ON a2_.id = a3_.artist_type_id WHERE a0_.nickname IS NOT NULL AND (a0_.nickname REGEXP ?) = 0 AND a0_.avatar_name IS NOT NULL) dctrn_result_inner ORDER BY nickname_3 ASC) dctrn_result LIMIT 12

Parameters:

[
  2
  "^artist_[0-9]+$"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      nickname_3
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.firstname AS firstname_1,
          a0_.lastname AS lastname_2,
          a0_.nickname AS nickname_3,
          a0_.slug AS slug_4,
          a0_.excerpt AS excerpt_5,
          a0_.mood AS mood_6,
          a0_.exhibition AS exhibition_7,
          a0_.crew AS crew_8,
          a0_.biography AS biography_9,
          a0_.original AS original_10,
          a0_.cover AS cover_11,
          a0_.instrumentation AS instrumentation_12,
          a0_.willingness AS willingness_13,
          a0_.www AS www_14,
          a0_.facebook AS facebook_15,
          a0_.twitter AS twitter_16,
          a0_.soundcloud AS soundcloud_17,
          a0_.youtube AS youtube_18,
          a0_.avatar AS avatar_19,
          a0_.wide AS wide_20,
          a0_.thumb AS thumb_21,
          a0_.privacy AS privacy_22,
          a0_.solo_artist AS solo_artist_23,
          a0_.avatar_name AS avatar_name_24,
          a0_.avatar_thumb_name AS avatar_thumb_name_25,
          a0_.cover_name AS cover_name_26,
          a0_.date_add AS date_add_27,
          a0_.date_upd AS date_upd_28,
          a0_.last_inactivity_reminder_at AS last_inactivity_reminder_at_29,
          a1_.id AS id_30,
          a1_.excerpt AS excerpt_31,
          a1_.mood AS mood_32,
          a1_.exhibition AS exhibition_33,
          a1_.crew AS crew_34,
          a1_.biography AS biography_35,
          a2_.id AS id_36,
          a2_.active AS active_37,
          a2_.icon AS icon_38,
          a2_.date_add AS date_add_39,
          a2_.date_upd AS date_upd_40
        FROM
          artist a0_
          LEFT JOIN artist_lang a1_ ON a0_.id = a1_.artist_id
          AND (
            a0_.id = a1_.artist_id
            AND a1_.language_id = ?
          )
          LEFT JOIN artist_artist_type a3_ ON a0_.id = a3_.artist_id
          LEFT JOIN artist_type a2_ ON a2_.id = a3_.artist_type_id
        WHERE
          a0_.nickname IS NOT NULL
          AND (a0_.nickname REGEXP ?) = 0
          AND a0_.avatar_name IS NOT NULL
      ) dctrn_result_inner
    ORDER BY
      nickname_3 ASC
  ) dctrn_result
LIMIT
  12

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, nickname_3 FROM (SELECT a0_.id AS id_0, a0_.firstname AS firstname_1, a0_.lastname AS lastname_2, a0_.nickname AS nickname_3, a0_.slug AS slug_4, a0_.excerpt AS excerpt_5, a0_.mood AS mood_6, a0_.exhibition AS exhibition_7, a0_.crew AS crew_8, a0_.biography AS biography_9, a0_.original AS original_10, a0_.cover AS cover_11, a0_.instrumentation AS instrumentation_12, a0_.willingness AS willingness_13, a0_.www AS www_14, a0_.facebook AS facebook_15, a0_.twitter AS twitter_16, a0_.soundcloud AS soundcloud_17, a0_.youtube AS youtube_18, a0_.avatar AS avatar_19, a0_.wide AS wide_20, a0_.thumb AS thumb_21, a0_.privacy AS privacy_22, a0_.solo_artist AS solo_artist_23, a0_.avatar_name AS avatar_name_24, a0_.avatar_thumb_name AS avatar_thumb_name_25, a0_.cover_name AS cover_name_26, a0_.date_add AS date_add_27, a0_.date_upd AS date_upd_28, a0_.last_inactivity_reminder_at AS last_inactivity_reminder_at_29, a1_.id AS id_30, a1_.excerpt AS excerpt_31, a1_.mood AS mood_32, a1_.exhibition AS exhibition_33, a1_.crew AS crew_34, a1_.biography AS biography_35, a2_.id AS id_36, a2_.active AS active_37, a2_.icon AS icon_38, a2_.date_add AS date_add_39, a2_.date_upd AS date_upd_40 FROM artist a0_ LEFT JOIN artist_lang a1_ ON a0_.id = a1_.artist_id AND (a0_.id = a1_.artist_id AND a1_.language_id = 2) LEFT JOIN artist_artist_type a3_ ON a0_.id = a3_.artist_id LEFT JOIN artist_type a2_ ON a2_.id = a3_.artist_type_id WHERE a0_.nickname IS NOT NULL AND (a0_.nickname REGEXP '^artist_[0-9]+$') = 0 AND a0_.avatar_name IS NOT NULL) dctrn_result_inner ORDER BY nickname_3 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\ArtistRepository->findByFirstLetter (line 251)
8	App\Domain\Artist\QueryHandler\ArtistGetAllByFiltersQueryHandler->{closure:App\Domain\Artist\QueryHandler\ArtistGetAllByFiltersQueryHandler::__invoke():22} (line 26)
9	Symfony\Component\Cache\LockRegistry->compute (line 113)
10	Symfony\Component\Cache\Adapter\TagAwareAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
11	Symfony\Component\Cache\Adapter\TagAwareAdapter->contractsGet (line 67)
12	Symfony\Component\Cache\Adapter\TagAwareAdapter->doGet (line 85)
13	Symfony\Component\Cache\Adapter\TagAwareAdapter->get (line 30)
14	App\Domain\Artist\QueryHandler\ArtistGetAllByFiltersQueryHandler->__invoke (line 22)
15	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 152)
16	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 91)
17	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 71)
18	Symfony\Component\Messenger\Middleware\ValidationMiddleware->handle (line 45)
19	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
20	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
21	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
22	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 37)
23	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 40)
24	Symfony\Component\Messenger\MessageBus->dispatch (line 70)
25	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 38)
26	App\Controller\Front\ArtistsController->index (line 56)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 208)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	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\Artist	No errors.
App\Entity\ArtistLang	No errors.
App\Entity\ArtistType	No errors.

Symfony Profiler

GET https://docker.dev.localero.it/en/artists

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping