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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
4766.87 ms
(99.81%)
1
SELECT DISTINCT s0_.id AS id_0, s0_.followers AS followers_1 FROM streamer s0_ ORDER BY s0_.followers DESC LIMIT 50 OFFSET 550
Parameters:
[]
8.78 ms
(0.18%)
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:
[
  80535
  2848
  31755
  3649
  38154
  351333
  2619
  159
  2799
  2549
  23167
  6994
  23194
  43947
  30647
  6406
  30674
  333610
  43943
  20105
  32958
  168
  6577
  6596
  3126
  2610
  86159
  6999
  173
  448207
  27793
  41616
  23246
  2691
  286736
  6965
  73486
  86416
  2569
  2714
  86415
  2744
  14556
  6482
  18076
  30667
  215228
  6385
  6417
  14359
]
0.37 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.