Query Metrics
11
Database Queries
9
Different statements
94.65 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 23.53 ms |
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 ] |
| 2 | 8.67 ms |
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
]
|
| 3 | 10.85 ms |
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
]
|
| 4 | 1.70 ms |
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 ] |
| 5 | 2.07 ms |
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
]
|
| 6 | 1.99 ms |
SELECT r0_.id AS id_0, r0_.name_ka AS name_ka_1 FROM region r0_
Parameters:
[] |
| 7 | 32.90 ms |
SELECT m0_.id AS id_0, m0_.title_ka AS title_ka_1 FROM media_type m0_
Parameters:
[] |
| 8 | 8.66 ms |
SELECT g0_.id AS id_0, r1_.id AS id_1, g0_.branch AS branch_2, g0_.title_ka AS title_ka_3 FROM government_entity g0_ LEFT JOIN region r1_ ON g0_.region_id = r1_.id
Parameters:
[] |
| 9 | 2.91 ms |
SELECT t0_.id AS id_0, t0_.title_ka AS title_ka_1 FROM tag t0_
Parameters:
[] |
| 10 | 0.65 ms |
SELECT t0_.id AS id_0, t0_.title_ka AS title_ka_1 FROM tag t0_
Parameters:
[] |
| 11 | 0.73 ms |
SELECT r0_.id AS id_0, r0_.name_ka AS name_ka_1 FROM region r0_
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.
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. |
| App\Entity\Region | No errors. |
| App\Entity\MediaType | No errors. |
| App\Entity\GovernmentEntity | No errors. |
| App\Entity\Tag | No errors. |
| App\Entity\MediaOrganization | No errors. |