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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 267.75 ms
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM streamer s0_
Parameters:
[]
2 4345.37 ms
SELECT DISTINCT s0_.id AS id_0, s0_.followers AS followers_1 FROM streamer s0_ ORDER BY s0_.followers DESC LIMIT 50 OFFSET 431700
Parameters:
[]
3 8.16 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:
[
  619582
  753291
  741392
  475328
  537203
  761453
  402942
  686275
  569007
  753275
  445944
  491086
  407792
  404379
  563062
  679879
  656933
  428716
  458251
  661613
  554656
  614612
  635004
  592753
  574564
  598223
  556699
  574513
  605084
  714273
  635075
  610909
  533612
  449913
  535098
  748631
  607717
  651949
  621508
  585204
  578380
  555240
  459486
  426625
  707624
  656968
  546364
  568858
  451457
  405241
]

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.