Query Metrics
4
Database Queries
4
Different statements
180.46 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 133.71 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:
[ "rdri" 1 ] |
| 2 | 14.14 ms |
SELECT r0_.id AS id_0, r0_.gov_val AS gov_val_1, r0_.gov_desc AS gov_desc_2, r0_.pol_val AS pol_val_3, r0_.pol_desc AS pol_desc_4, r0_.med_val AS med_val_5, r0_.med_desc AS med_desc_6, r0_.soc_val AS soc_val_7, r0_.soc_desc AS soc_desc_8, r0_.gov_desc_ka AS gov_desc_ka_9, r0_.pol_desc_ka AS pol_desc_ka_10, r0_.med_desc_ka AS med_desc_ka_11, r0_.soc_desc_ka AS soc_desc_ka_12, r0_.score AS score_13, r0_.score_unit AS score_unit_14, r0_.gov_unit AS gov_unit_15, r0_.pol_unit AS pol_unit_16, r0_.med_unit AS med_unit_17, r0_.soc_unit AS soc_unit_18, r0_.total_score AS total_score_19, r0_.region_id AS region_id_20, r0_.project_id AS project_id_21 FROM region_data r0_ WHERE r0_.project_id = ? ORDER BY r0_.id ASC
Parameters:
[
1
]
|
| 3 | 21.90 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:
[
1
]
|
| 4 | 10.71 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:
[
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\RegionData | No errors. |
| App\Entity\Region | No errors. |