Query Metrics
5
Database Queries
5
Different statements
51.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
26.73 ms (51.43%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.intro AS intro_3, t0.methodology AS methodology_4, t0.pub_date AS pub_date_5, t0.related_data_class AS related_data_class_6, t0.headline AS headline_7, t0.headline_ka AS headline_ka_8, t0.intro_ka AS intro_ka_9, t0.methodology_ka AS methodology_ka_10, t0.slug AS slug_11, t0.data_ctrl AS data_ctrl_12, t0.resume AS resume_13, t0.resume_ka AS resume_ka_14, t0.recommends AS recommends_15, t0.recommends_ka AS recommends_ka_16, t0.short AS short_17, t0.short_ka AS short_ka_18, t0.extract AS extract_19, t0.extract_ka AS extract_ka_20, t0.cover AS cover_21, t0.cover_ka AS cover_ka_22, t0.visible AS visible_23, t0.about AS about_24, t0.about_ka AS about_ka_25, t0.code AS code_26, t0.load_data AS load_data_27 FROM project t0 WHERE t0.slug = ? AND t0.visible = ? ORDER BY t0.pub_date DESC LIMIT 1
Parameters:
[ "pubinf" 1 ] |
|
13.13 ms (25.27%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ka AS title_ka_3, t0.src AS src_4, t0.src_ka AS src_ka_5, t0.cover AS cover_6, t0.cover_ka AS cover_ka_7, t0.extract AS extract_8, t0.extract_ka AS extract_ka_9, t0.published AS published_10, t0.on_home AS on_home_11, t0.deleted AS deleted_12, t0.project_id AS project_id_13 FROM attachment t0 WHERE t0.project_id = ?
Parameters:
[
2
]
|
|
8.69 ms (16.73%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ka AS title_ka_3, t0.logo AS logo_4, t0.logo_ka AS logo_ka_5, t0.url AS url_6, t0.url_ka AS url_ka_7 FROM donor t0 INNER JOIN project_donor ON t0.id = project_donor.donor_id WHERE project_donor.project_id = ?
Parameters:
[
2
]
|
|
1.72 ms (3.31%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ka AS title_ka_3, t0.visible AS visible_4, t0.url AS url_5, t0.menu_id AS menu_id_6 FROM menu_entry t0 WHERE t0.menu_id = ?
Parameters:
[
1
]
|
|
1.70 ms (3.27%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.visible AS visible_3 FROM menu t0 WHERE t0.name = ? AND t0.visible = ? LIMIT 1
Parameters:
[ "main" 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\Project | No errors. |
| App\Entity\Attachment | No errors. |
| App\Entity\Donor | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Menu | No errors. |
| App\Entity\MenuEntry | No errors. |