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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.44 ms
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM streamer s0_
Parameters:
[]
2 4765.92 ms
SELECT DISTINCT s0_.id AS id_0, s0_.followers AS followers_1 FROM streamer s0_ ORDER BY s0_.followers DESC LIMIT 50 OFFSET 873150
Parameters:
[]
3 1.76 ms
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:
[
  764261
  835441
  827342
  835205
  867442
  874874
  815394
  850132
  843853
  855972
  801559
  807149
  807145
  835204
  834025
  844900
  855971
  855975
  781130
  849937
  865613
  764255
  826291
  826338
  827372
  827371
  857273
  783345
  828335
  866005
  838710
  867024
  798346
  774252
  783088
  839317
  874965
  868449
  798161
  866013
  802081
  819676
  796176
  807335
  785006
  797282
  832995
  834231
  822105
  814511
]

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.