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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 310.95 ms
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM streamer s0_
Parameters:
[]
2 5454.53 ms
SELECT DISTINCT s0_.id AS id_0, s0_.followers AS followers_1 FROM streamer s0_ ORDER BY s0_.followers DESC LIMIT 50 OFFSET 872600
Parameters:
[]
3 12.44 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:
[
  224202
  200984
  224201
  212635
  178518
  34027
  60944
  322770
  50562
  300780
  322369
  132371
  112209
  349220
  50622
  349230
  112201
  132387
  269454
  269455
  349250
  269432
  86755
  108537
  269401
  50612
  132353
  349178
  33446
  300797
  236522
  283633
  300807
  164778
  236544
  164845
  164846
  300875
  371074
  269480
  283586
  178230
  349298
  200858
  13395
  13450
  269491
  269492
  164883
  164881
]

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.