Query Metrics
2
Database Queries
2
Different statements
1.30 ms
Query time
0
Invalid entities
27
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.00 ms (77.26%) |
1 |
SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.slug AS slug_2, e0_.description AS description_3, e0_.image AS image_4, e0_.broadcast_date AS broadcast_date_5, e0_.schedule_day AS schedule_day_6, e0_.schedule_time AS schedule_time_7, e0_.duration AS duration_8, e0_.host_name AS host_name_9, e0_.production_team AS production_team_10, e0_.audio_file AS audio_file_11, e0_.file_size AS file_size_12, e0_.is_active AS is_active_13, e0_.audio_url AS audio_url_14, e0_.plays_count AS plays_count_15, e0_.created_at AS created_at_16, e0_.updated_at AS updated_at_17, e1_.id AS id_18, e1_.name AS name_19, e1_.slug AS slug_20, e1_.description AS description_21, e1_.color AS color_22, e1_.icon AS icon_23, e1_.is_active AS is_active_24, e1_.display_order AS display_order_25, e1_.created_at AS created_at_26, e1_.updated_at AS updated_at_27, e0_.category_id AS category_id_28 FROM emission e0_ LEFT JOIN emission_category e1_ ON e0_.category_id = e1_.id WHERE e0_.is_active = ? ORDER BY e0_.schedule_time ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||
|
0.29 ms (22.74%) |
1 |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.setting_type AS setting_type_4, t0.description AS description_5, t0.updated_at AS updated_at_6 FROM setting t0
Parameters:
[] |
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Setting | 14 |
| App\Entity\Emission | 8 |
| App\Entity\EmissionCategory | 5 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Emission | No errors. |
| App\Entity\EmissionCategory | No errors. |
| App\Entity\Setting | No errors. |