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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 295.39 ms
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM streamer s0_
Parameters:
[]
2 4675.09 ms
SELECT DISTINCT s0_.id AS id_0, s0_.followers AS followers_1 FROM streamer s0_ ORDER BY s0_.followers DESC LIMIT 50 OFFSET 400
Parameters:
[]
3 11.23 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:
[
  28996
  177
  31538
  154
  436575
  78532
  34430
  408410
  2611
  3362
  6424
  74452
  29850
  80533
  39181
  23202
  2553
  82806
  61266
  61264
  11514
  63589
  19141
  864310
  6405
  6510
  157
  43094
  45580
  2615
  11057
  3297
  6397
  80035
  86106
  2573
  2787
  271023
  2609
  11065
  82944
  45616
  49269
  2679
  2588
  6396
  2705
  217123
  16856
  29822
]

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.