Query Metrics
3
Database Queries
3
Different statements
6196.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
5912.90 ms (95.43%) |
1 |
SELECT DISTINCT s0_.id AS id_0, s0_.followers AS followers_1 FROM streamer s0_ ORDER BY s0_.followers DESC LIMIT 50 OFFSET 3600
Parameters:
[] |
|
269.28 ms (4.35%) |
1 |
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM streamer s0_
Parameters:
[] |
|
14.17 ms (0.23%) |
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:
[ 392024 2625 57049 7115 517169 6606 14741 485740 2798 363085 3619 20158 56475 6070 306334 20138 440815 70050 5319 26566 30652 11377 3347 7319 11145 8132 118740 29083 291294 30952 29415 3143 3007 55663 78935 718652 69672 19133 6587 478014 807 258066 31603 28002 3699 44376 85501 26687 154627 16925 ] |
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. |