Query Metrics
3
Database Queries
3
Different statements
5682.71 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
5383.58 ms (94.74%) |
1 |
SELECT DISTINCT s0_.id AS id_0, s0_.followers AS followers_1 FROM streamer s0_ ORDER BY s0_.followers DESC LIMIT 50 OFFSET 432300
Parameters:
[] |
297.84 ms (5.24%) |
1 |
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM streamer s0_
Parameters:
[] |
1.28 ms (0.02%) |
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:
[ 820103 864890 822496 852892 767937 789147 855657 773554 766567 781712 872681 871114 807578 840453 843189 842367 820715 799705 869501 846977 843979 784157 822066 865020 865553 842172 782474 789746 794816 777864 802464 786050 813568 785143 871074 789771 840348 827990 790044 859216 876009 808760 795335 768969 874341 799630 857017 809315 798565 774775 ] |
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. |