Query Metrics
3
Database Queries
3
Different statements
8.37 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.82 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t4.id AS id_5, t4.name AS name_6, t4.domain AS domain_7, t4.logo AS logo_8, t4.is_active AS is_active_9, t4.primary_color AS primary_color_10, t4.secondary_color AS secondary_color_11, t4.tertiary_color AS tertiary_color_12, t4.quaternary_color AS quaternary_color_13, t4.logo_small AS logo_small_14, t4.avatar AS avatar_15, t4.role_id AS role_id_16 FROM role t0 LEFT JOIN website t4 ON t4.role_id = t0.id
Parameters:
[] |
| 2 | 2.69 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.domain AS domain_3, t0.logo AS logo_4, t0.is_active AS is_active_5, t0.primary_color AS primary_color_6, t0.secondary_color AS secondary_color_7, t0.tertiary_color AS tertiary_color_8, t0.quaternary_color AS quaternary_color_9, t0.logo_small AS logo_small_10, t0.avatar AS avatar_11, t0.role_id AS role_id_12 FROM website t0 WHERE t0.domain = ? AND t0.is_active = ? LIMIT 1
Parameters:
[ "dev.myeduscape.com" 1 ] |
| 3 | 1.86 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.domain AS domain_3, t0.logo AS logo_4, t0.is_active AS is_active_5, t0.primary_color AS primary_color_6, t0.secondary_color AS secondary_color_7, t0.tertiary_color AS tertiary_color_8, t0.quaternary_color AS quaternary_color_9, t0.logo_small AS logo_small_10, t0.avatar AS avatar_11, t0.role_id AS role_id_12 FROM website t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"myEduscape"
]
|
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\Role | No errors. |
| App\Entity\Website | No errors. |
| App\Entity\Course | No errors. |