Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

3.96 ms Query time

0 Invalid entities

0 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

2.68 ms
(67.55%)

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, ranking_position_22, total_points_21, 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, t2_.id AS id_28, t2_.min_points AS min_points_29, t2_.position AS position_30, t2_.badge AS badge_31, t2_.stars AS stars_32, t2_.hex_code AS hex_code_33, t2_.date_add AS date_add_34, t2_.date_upd AS date_upd_35, t3_.id AS id_36, t3_.name AS name_37, a4_.id AS id_38, a4_.firstname AS firstname_39, a4_.lastname AS lastname_40, a4_.nickname AS nickname_41, a4_.slug AS slug_42, a4_.excerpt AS excerpt_43, a4_.mood AS mood_44, a4_.exhibition AS exhibition_45, a4_.crew AS crew_46, a4_.biography AS biography_47, a4_.original AS original_48, a4_.cover AS cover_49, a4_.instrumentation AS instrumentation_50, a4_.willingness AS willingness_51, a4_.www AS www_52, a4_.facebook AS facebook_53, a4_.twitter AS twitter_54, a4_.soundcloud AS soundcloud_55, a4_.youtube AS youtube_56, a4_.avatar AS avatar_57, a4_.wide AS wide_58, a4_.thumb AS thumb_59, a4_.privacy AS privacy_60, a4_.solo_artist AS solo_artist_61, a4_.avatar_name AS avatar_name_62, a4_.avatar_thumb_name AS avatar_thumb_name_63, a4_.cover_name AS cover_name_64, a4_.date_add AS date_add_65, a4_.date_upd AS date_upd_66, a4_.last_inactivity_reminder_at AS last_inactivity_reminder_at_67 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 tier t2_ ON b0_.current_tier_id = t2_.id LEFT JOIN tier_lang t3_ ON t2_.id = t3_.tier_id AND (t2_.id = t3_.tier_id AND t3_.language_id = ?) LEFT JOIN band_artist b5_ ON b0_.id = b5_.band_id LEFT JOIN artist a4_ ON a4_.id = b5_.artist_id) dctrn_result_inner ORDER BY ranking_position_22 ASC, total_points_21 DESC, name_2 ASC) dctrn_result LIMIT 20

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      ranking_position_22,
      total_points_21,
      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,
          t2_.id AS id_28,
          t2_.min_points AS min_points_29,
          t2_.position AS position_30,
          t2_.badge AS badge_31,
          t2_.stars AS stars_32,
          t2_.hex_code AS hex_code_33,
          t2_.date_add AS date_add_34,
          t2_.date_upd AS date_upd_35,
          t3_.id AS id_36,
          t3_.name AS name_37,
          a4_.id AS id_38,
          a4_.firstname AS firstname_39,
          a4_.lastname AS lastname_40,
          a4_.nickname AS nickname_41,
          a4_.slug AS slug_42,
          a4_.excerpt AS excerpt_43,
          a4_.mood AS mood_44,
          a4_.exhibition AS exhibition_45,
          a4_.crew AS crew_46,
          a4_.biography AS biography_47,
          a4_.original AS original_48,
          a4_.cover AS cover_49,
          a4_.instrumentation AS instrumentation_50,
          a4_.willingness AS willingness_51,
          a4_.www AS www_52,
          a4_.facebook AS facebook_53,
          a4_.twitter AS twitter_54,
          a4_.soundcloud AS soundcloud_55,
          a4_.youtube AS youtube_56,
          a4_.avatar AS avatar_57,
          a4_.wide AS wide_58,
          a4_.thumb AS thumb_59,
          a4_.privacy AS privacy_60,
          a4_.solo_artist AS solo_artist_61,
          a4_.avatar_name AS avatar_name_62,
          a4_.avatar_thumb_name AS avatar_thumb_name_63,
          a4_.cover_name AS cover_name_64,
          a4_.date_add AS date_add_65,
          a4_.date_upd AS date_upd_66,
          a4_.last_inactivity_reminder_at AS last_inactivity_reminder_at_67
        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 tier t2_ ON b0_.current_tier_id = t2_.id
          LEFT JOIN tier_lang t3_ ON t2_.id = t3_.tier_id
          AND (
            t2_.id = t3_.tier_id
            AND t3_.language_id = ?
          )
          LEFT JOIN band_artist b5_ ON b0_.id = b5_.band_id
          LEFT JOIN artist a4_ ON a4_.id = b5_.artist_id
      ) dctrn_result_inner
    ORDER BY
      ranking_position_22 ASC,
      total_points_21 DESC,
      name_2 ASC
  ) dctrn_result
LIMIT
  20

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, ranking_position_22, total_points_21, 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, t2_.id AS id_28, t2_.min_points AS min_points_29, t2_.position AS position_30, t2_.badge AS badge_31, t2_.stars AS stars_32, t2_.hex_code AS hex_code_33, t2_.date_add AS date_add_34, t2_.date_upd AS date_upd_35, t3_.id AS id_36, t3_.name AS name_37, a4_.id AS id_38, a4_.firstname AS firstname_39, a4_.lastname AS lastname_40, a4_.nickname AS nickname_41, a4_.slug AS slug_42, a4_.excerpt AS excerpt_43, a4_.mood AS mood_44, a4_.exhibition AS exhibition_45, a4_.crew AS crew_46, a4_.biography AS biography_47, a4_.original AS original_48, a4_.cover AS cover_49, a4_.instrumentation AS instrumentation_50, a4_.willingness AS willingness_51, a4_.www AS www_52, a4_.facebook AS facebook_53, a4_.twitter AS twitter_54, a4_.soundcloud AS soundcloud_55, a4_.youtube AS youtube_56, a4_.avatar AS avatar_57, a4_.wide AS wide_58, a4_.thumb AS thumb_59, a4_.privacy AS privacy_60, a4_.solo_artist AS solo_artist_61, a4_.avatar_name AS avatar_name_62, a4_.avatar_thumb_name AS avatar_thumb_name_63, a4_.cover_name AS cover_name_64, a4_.date_add AS date_add_65, a4_.date_upd AS date_upd_66, a4_.last_inactivity_reminder_at AS last_inactivity_reminder_at_67 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 tier t2_ ON b0_.current_tier_id = t2_.id LEFT JOIN tier_lang t3_ ON t2_.id = t3_.tier_id AND (t2_.id = t3_.tier_id AND t3_.language_id = 1) LEFT JOIN band_artist b5_ ON b0_.id = b5_.band_id LEFT JOIN artist a4_ ON a4_.id = b5_.artist_id) dctrn_result_inner ORDER BY ranking_position_22 ASC, total_points_21 DESC, name_2 ASC) dctrn_result LIMIT 20;

#	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->findRanking (line 271)
8	App\Domain\Band\QueryHandler\BandGetRankingQueryHandler->__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\RankController->index (line 26)
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.29 ms
(32.45%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

SELECT COUNT(DISTINCT 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->countRanking (line 284)
8	App\Domain\Band\QueryHandler\BandCountRankingQueryHandler->__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\RankController->index (line 27)
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\Tier	No errors.
App\Entity\TierLang	No errors.
App\Entity\Artist	No errors.