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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.36 ms
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM streamer s0_
Parameters:
[]
2 4630.21 ms
SELECT DISTINCT s0_.id AS id_0, s0_.followers AS followers_1 FROM streamer s0_ ORDER BY s0_.followers DESC LIMIT 50 OFFSET 433650
Parameters:
[]
3 9.71 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:
[
  643984
  681471
  549757
  452418
  498955
  533979
  548388
  528144
  493905
  431993
  757028
  520884
  409023
  565958
  470683
  603688
  541506
  447360
  628642
  420247
  392174
  646330
  521592
  461789
  461959
  628798
  415749
  631296
  667200
  612595
  681186
  476707
  559382
  684592
  680389
  447479
  514243
  514247
  447496
  478229
  524748
  416451
  660802
  492392
  740814
  506537
  499082
  516117
  496976
  422717
]

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.