Query Metrics
5
Database Queries
3
Different statements
58.79 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 42.74 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.visible = ? ORDER BY t0.pub_date DESC
Parameters:
[
1
]
|
| 2 | 9.17 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 | 5.53 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 | 0.59 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
]
|
| 5 | 0.77 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. |