GET https://www.squadtwitch.com/en/all-streamer?page=8697

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
4400.02 ms
(93.65%)
1
SELECT DISTINCT s0_.id AS id_0, s0_.followers AS followers_1 FROM streamer s0_ ORDER BY s0_.followers DESC LIMIT 50 OFFSET 434800
Parameters:
[]
287.90 ms
(6.13%)
1
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM streamer s0_
Parameters:
[]
10.59 ms
(0.23%)
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:
[
  221207
  276821
  296246
  99454
  19473
  286562
  267910
  100225
  197805
  122352
  76884
  168878
  167381
  316029
  224792
  139304
  93977
  243007
  244321
  93989
  74065
  365666
  331850
  331865
  229236
  159587
  316426
  197970
  45925
  65756
  168752
  318338
  122685
  167429
  186874
  139368
  157803
  265043
  167148
  129964
  319031
  157795
  52588
  221949
  372898
  114687
  203779
  114680
  318939
  102176
]

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.