Query Metrics
6
Database Queries
4
Different statements
2.75 ms
Query time
0
Invalid entities
7
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.01 ms (36.82%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.sort_order AS sort_order_4 FROM project_category t0 INNER JOIN project_project_category ON t0.id = project_project_category.project_category_id WHERE project_project_category.project_id = ?
Parameters:
[
4
]
|
|
0.64 ms (23.41%) |
1 |
SELECT t0.id AS id_1, t0.content_key AS content_key_2, t0.hero_title AS hero_title_3, t0.hero_subtitle AS hero_subtitle_4, t0.primary_cta_label AS primary_cta_label_5, t0.primary_cta_target AS primary_cta_target_6, t0.secondary_cta_label AS secondary_cta_label_7, t0.secondary_cta_target AS secondary_cta_target_8, t0.services_title AS services_title_9, t0.services_subtitle AS services_subtitle_10, t0.portfolio_title AS portfolio_title_11, t0.portfolio_subtitle AS portfolio_subtitle_12, t0.contact_title AS contact_title_13, t0.contact_subtitle AS contact_subtitle_14, t0.contact_address AS contact_address_15, t0.contact_phone AS contact_phone_16, t0.contact_email AS contact_email_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19 FROM tech_site_content t0 WHERE t0.content_key = ? LIMIT 1
Parameters:
[
"homepage"
]
|
|
0.60 ms (21.74%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.images AS images_5, t0.created_at AS created_at_6, t0.is_published AS is_published_7, t0.sort_order AS sort_order_8 FROM tech_project t0 WHERE t0.is_published = ? ORDER BY t0.sort_order ASC, t0.created_at DESC
Parameters:
[
1
]
|
|
0.50 ms (18.03%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.sort_order AS sort_order_4 FROM project_category t0 ORDER BY t0.sort_order ASC
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\Project | 3 |
| App\Entity\ProjectCategory | 3 |
| App\Entity\SiteContent | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Project | No errors. |
| App\Entity\ProjectCategory | No errors. |
| App\Entity\SiteContent | No errors. |