GET https://www.squadtwitch.com/de/alle-streamer?page=17483

Query Metrics

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

Queries

Group similar statements

# Time Info
1 333.76 ms
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM streamer s0_
Parameters:
[]
2 4951.25 ms
SELECT DISTINCT s0_.id AS id_0, s0_.followers AS followers_1 FROM streamer s0_ ORDER BY s0_.followers DESC LIMIT 50 OFFSET 874100
Parameters:
[]
3 1.73 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:
[
  833109
  857600
  815383
  821045
  839874
  826377
  806932
  819685
  839884
  813617
  814656
  813654
  844767
  813649
  773700
  773704
  806908
  833171
  790589
  821062
  876078
  772188
  827992
  827004
  827985
  875060
  806286
  875055
  850336
  844756
  839847
  867522
  813648
  806233
  858802
  791078
  856128
  858808
  868403
  868404
  791077
  813618
  856122
  819732
  857631
  856132
  806222
  821793
  772190
  806221
]

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.