GET https://conexao.wab.com.br/ensino-medio

Query Metrics

9 Database Queries
9 Different statements
5.52 ms Query time
0 Invalid entities
21 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.83 ms
(33.14%)
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
  3
]
0.76 ms
(13.72%)
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:
[
  3
  1
]
0.72 ms
(13.05%)
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:
[
  3
  "teacher"
  1
]
0.57 ms
(10.26%)
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:
[
  3
]
0.53 ms
(9.60%)
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
  3
]
0.41 ms
(7.41%)
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:
[
  3
  1
]
0.31 ms
(5.67%)
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:
[
  3
  1
]
0.23 ms
(4.17%)
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"
]
0.16 ms
(2.97%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.active AS active_4, t0.section AS section_5 FROM video t0 WHERE t0.active = ? ORDER BY t0.id DESC LIMIT 6
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Student 6
App\Entity\Video 6
App\Entity\University 4
App\Entity\Testimony 3
App\Entity\Banner 1
App\Entity\Course 1

Entities Mapping

Class Mapping errors
App\Entity\SegmentContent No errors.
App\Entity\Banner No errors.
App\Entity\Staff No errors.
App\Entity\Job No errors.
App\Entity\Testimony 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\Video No errors.
App\Entity\Album No errors.