Query Metrics
4Database Queries
4Different statements
2.09 msQuery time
0Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
| 0.96 ms (46.06%) | 1 | SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.title AS title_4, t0.slug AS slug_5, t0.url AS url_6, t0.visibility AS visibility_7, t0.type AS type_8 FROM seo_redirection t0 WHERE t0.slug = ? AND t0.visibility = ? LIMIT 1 Parameters: [ "api/missions/categories/by-slug/content-marketing-copywriting?locale=en" 1 ] |
| 0.44 ms (20.95%) | 1 | SELECT t0.id AS id_1, t0.locale AS locale_2, t0.code AS code_3, t0.slug AS slug_4, t0.name AS name_5, t0.description AS description_6, t0.icon AS icon_7, t0.color AS color_8, t0.seo_title AS seo_title_9, t0.seo_description AS seo_description_10, t0.position AS position_11, t0.enabled AS enabled_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.parent_id AS parent_id_15 FROM whileproject_missions_categories t0 WHERE t0.locale = ? AND t0.slug = ? AND t0.enabled = ? LIMIT 1 Parameters: [ "en" "content-marketing-copywriting" 1 ] |
| 0.41 ms (19.42%) | 1 | SELECT t0.id AS id_1, t0.locale AS locale_2, t0.code AS code_3, t0.slug AS slug_4, t0.name AS name_5, t0.description AS description_6, t0.icon AS icon_7, t0.color AS color_8, t0.seo_title AS seo_title_9, t0.seo_description AS seo_description_10, t0.position AS position_11, t0.enabled AS enabled_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.parent_id AS parent_id_15 FROM whileproject_missions_categories t0 WHERE t0.parent_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.name ASC Parameters: [ 35 1 ] |
| 0.28 ms (13.57%) | 1 | SELECT t0.id AS id_1, t0.locale AS locale_2, t0.code AS code_3, t0.slug AS slug_4, t0.name AS name_5, t0.description AS description_6, t0.icon AS icon_7, t0.color AS color_8, t0.seo_title AS seo_title_9, t0.seo_description AS seo_description_10, t0.position AS position_11, t0.enabled AS enabled_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.parent_id AS parent_id_15 FROM whileproject_missions_categories t0 WHERE t0.id = ? Parameters: [
31
] |
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\Seo\Redirection | No errors. |
| App\Entity\WhileProject\MissionsCategories | No errors. |