Query Metrics
8
Database Queries
8
Different statements
7.33 ms
Query time
0
Invalid entities
15
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
2.78 ms (37.96%) |
1 |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.image AS image_2, s0_.year AS year_3, s0_.sector AS sector_4, s0_.featured AS featured_5, s0_.active AS active_6, s0_.rank AS rank_7, s0_.updated_at AS updated_at_8, s0_.university_id AS university_id_9, s0_.course_id AS course_id_10 FROM student s0_ WHERE s0_.active = ? AND s0_.featured = ? AND s0_.sector = ? GROUP BY s0_.year ORDER BY s0_.year DESC LIMIT 6
Parameters:
[ 1 1 4 ]
|
||||||||||||||||||||||||||||||
|
1.02 ms (13.94%) |
1 |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.image AS image_2, s0_.description AS description_3, s0_.sectors AS sectors_4, s0_.type AS type_5, s0_.active AS active_6, s0_.position AS position_7, s0_.updated_at AS updated_at_8, s0_.job_id AS job_id_9 FROM staff s0_ WHERE s0_.sectors = ? AND s0_.type = ? AND s0_.active = ? ORDER BY s0_.position ASC, s0_.name ASC
Parameters:
[ 4 "teacher" 1 ]
|
||||||||||||||||||||||||||||||
|
0.73 ms (9.92%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.image AS image_4, t0.sector AS sector_5, t0.position AS position_6, t0.active AS active_7, t0.updated_at AS updated_at_8 FROM differential t0 WHERE t0.sector = ? AND t0.active = ? ORDER BY t0.position ASC
Parameters:
[ 4 1 ]
|
||||||||||||||||||||||||||||||
|
0.68 ms (9.27%) |
1 |
SELECT t0.id AS id_1, t0.sector AS sector_2, t0.top_title AS top_title_3, t0.top_text AS top_text_4, t0.banner_btn_text AS banner_btn_text_5, t0.banner_btn_link AS banner_btn_link_6, t0.study_title AS study_title_7, t0.study_text AS study_text_8 FROM segment_content t0 WHERE t0.sector = ? LIMIT 1
Parameters:
[
4
]
|
||||||||||||||||||||||||||||||
|
0.67 ms (9.12%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.link AS link_4, t0.sector AS sector_5, t0.active AS active_6, t0.position AS position_7, t0.updated_at AS updated_at_8 FROM banner t0 WHERE t0.sector = ? AND t0.active = ? ORDER BY t0.position ASC
Parameters:
[ 4 1 ]
|
||||||||||||||||||||||||||||||
|
0.66 ms (9.08%) |
1 |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.picture AS picture_3, t0_.sector AS sector_4, t0_.active AS active_5, t0_.date AS date_6, t0_.type AS type_7, t0_.updated_at AS updated_at_8 FROM testimony t0_ WHERE t0_.active = ? AND t0_.sector = ? ORDER BY t0_.date DESC LIMIT 3
Parameters:
[ 1 4 ]
|
||||||||||||||||||||||||||||||
|
0.56 ms (7.66%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.image AS image_4, t0.sector AS sector_5, t0.position AS position_6, t0.active AS active_7, t0.updated_at AS updated_at_8 FROM pedagogical_project t0 WHERE t0.sector = ? AND t0.active = ? ORDER BY t0.position ASC
Parameters:
[ 4 1 ]
|
||||||||||||||||||||||||||||||
|
0.22 ms (3.06%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.active AS active_3, t0.publish_date AS publish_date_4, t0.section AS section_5, t0.description AS description_6, t0.cover AS cover_7, t0.date AS date_8, t0.updated_at AS updated_at_9 FROM album t0 WHERE t0.title = ? LIMIT 1
Parameters:
[
"Nossa Estrutura"
]
|
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\Student | 6 |
| App\Entity\University | 3 |
| App\Entity\Testimony | 3 |
| App\Entity\Course | 2 |
| App\Entity\Banner | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\SegmentContent | No errors. |
| App\Entity\Banner | No errors. |
| App\Entity\Student | No errors. |
| App\Entity\University | No errors. |
| App\Entity\Course | No errors. |
| App\Entity\Differential | No errors. |
| App\Entity\PedagogicalProject | No errors. |
| App\Entity\Staff | No errors. |
| App\Entity\Job | No errors. |
| App\Entity\Testimony | No errors. |
| App\Entity\Album | No errors. |