Query Metrics
4
Database Queries
4
Different statements
4.39 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.92 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.type AS type_4, t0.base_url AS base_url_5, t0.parent_name AS parent_name_6, t0.token AS token_7, t0.project_id AS project_id_8, t0.view_mode AS view_mode_9, t0.display_title AS display_title_10, t0.display_description AS display_description_11, t0.google_map_url AS google_map_url_12, t0.video_url AS video_url_13, t0.logo_path AS logo_path_14, t0.image_sizes AS image_sizes_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17 FROM instance t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"emeraude"
]
|
| 2 | 0.48 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.row_pos AS row_pos_4, t0.glb_path AS glb_path_5, t0.mesh_group_name AS mesh_group_name_6, t0.mesh_property_map AS mesh_property_map_7, t0.is_default AS is_default_8, t0.show_on_homepage AS show_on_homepage_9, t0.sort_order AS sort_order_10, t0.icon AS icon_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.instance_id AS instance_id_14 FROM instance_view t0 WHERE t0.id = ? AND t0.instance_id = ? LIMIT 1
Parameters:
[ 3 1 ] |
| 3 | 2.34 ms |
SELECT t0.id AS id_1, t0.row_pos AS row_pos_2, t0.type AS type_3, t0.original_filename AS original_filename_4, t0.original_path AS original_path_5, t0.variants AS variants_6, t0.status AS status_7, t0.source_type AS source_type_8, t0.source_config AS source_config_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.instance_id AS instance_id_12, t0.view_id AS view_id_13 FROM media_item t0 WHERE t0.instance_id = ? AND t0.view_id = ? AND t0.type = ? ORDER BY t0.row_pos ASC, t0.id ASC
Parameters:
[ 1 3 "image" ] |
| 4 | 0.65 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.enabled AS enabled_5 FROM user t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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\Instance | No errors. |
| App\Entity\InstanceView | No errors. |
| App\Entity\MediaItem | No errors. |
| App\Entity\User | No errors. |