GET https://www.squadtwitch.com/de/alle-streamer?page=11

Query Metrics

3 Database Queries
3 Different statements
3668.03 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3659.71 ms
(99.77%)
1
SELECT DISTINCT s0_.id AS id_0, s0_.followers AS followers_1 FROM streamer s0_ ORDER BY s0_.followers DESC LIMIT 50 OFFSET 500
Parameters:
[]
7.94 ms
(0.22%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.logo AS logo_2, s0_.url AS url_3, s0_.team AS team_4, s0_.twitch_id AS twitch_id_5, s0_.broadcaster_type AS broadcaster_type_6, s0_.offline_image_url AS offline_image_url_7, s0_.twitch_created_at AS twitch_created_at_8, s0_.description AS description_9, s0_.followers AS followers_10, s0_.language AS language_11, s0_.prio AS prio_12, s0_.created_at AS created_at_13, s0_.updated_at AS updated_at_14 FROM streamer s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.followers DESC
Parameters:
[
  61255
  80014
  10052
  2777
  72388
  2938
  49832
  4751
  79992
  90325
  2905
  27814
  85877
  80004
  6692
  6508
  79488
  417356
  485347
  2925
  162
  2589
  27880
  6714
  162062
  85675
  6452
  9947
  29011
  30696
  29039
  24891
  78947
  190615
  190613
  33742
  320551
  2741
  382924
  46380
  14405
  26623
  79224
  50297
  2718
  6599
  14312
  85410
  684682
  2842
]
0.39 ms
(0.01%)
1
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM streamer s0_
Parameters:
[]

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.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Streamer No errors.