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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
4826.15 ms
(99.79%)
1
SELECT DISTINCT s0_.id AS id_0, s0_.followers AS followers_1 FROM streamer s0_ ORDER BY s0_.followers DESC LIMIT 50 OFFSET 3150
Parameters:
[]
9.78 ms
(0.20%)
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:
[
  83290
  14497
  7792
  28957
  729225
  104843
  29019
  8425
  705836
  79735
  6446
  49831
  3368
  35282
  72368
  95574
  62325
  214575
  149020
  111278
  83268
  79239
  7487
  79819
  79837
  844078
  10120
  29177
  29933
  29928
  376
  22126
  104177
  50302
  2661
  397
  4196
  26034
  6693
  36371
  42475
  66332
  52811
  11446
  74463
  422526
  11112
  11077
  3227
  31501
]
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.