GET https://www.ccert.in/public/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CDefaultController%253A%253AnavAction

Response
200 OK
IP
216.73.217.176
Profiled on
Token
4bca4e

Query Metrics

13 Database Queries
4 Different statements
48.47 ms Query time
0 Invalid entities
112 Managed entities

Queries

Group similar statements

#▲ Time Info
1 30.28 ms 
SELECT c0_.id AS id_0, c0_.guid AS guid_1, c0_.code AS code_2, c0_.name AS name_3, c0_.months AS months_4, c0_.hours AS hours_5, c0_.status AS status_6, c0_.fee AS fee_7, c0_.eligibility AS eligibility_8, c0_.book AS book_9, c0_.file AS file_10, c0_.file_type AS file_type_11, c0_.old_id AS old_id_12, c0_.syllabus AS syllabus_13, c0_.description AS description_14, c0_.online_test AS online_test_15, c0_.page_body AS page_body_16, c0_.title AS title_17, c0_.keywords AS keywords_18, c0_.is_public AS is_public_19, c0_.job_opportunities AS job_opportunities_20 FROM course c0_ WHERE c0_.status = ? ORDER BY c0_.name ASC
Parameters: 
[
  "a"
]
View formatted query    View runnable query    Explain query
2 5.56 ms 
SELECT c0_.id AS id_0, c0_.guid AS guid_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, c0_.course_id AS course_id_4, c0_.country_id AS country_id_5 FROM course_country c0_ INNER JOIN country c1_ ON c0_.country_id = c1_.id INNER JOIN course c2_ ON c0_.course_id = c2_.id WHERE c1_.is_active = ? AND c2_.status = ? AND c2_.is_public = ? ORDER BY c1_.name ASC
Parameters: 
[
  1
  "a"
  1
]
View formatted query    View runnable query    Explain query
3 1.82 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.location AS location_3, t0.rank AS rank_4, t0.old_id AS old_id_5 FROM menu t0 WHERE t0.location = ? ORDER BY t0.rank ASC
Parameters: 
[
  "top"
]
View formatted query    View runnable query    Explain query
4 2.45 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.body AS body_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.url AS url_7, t0.target AS target_8, t0.is_home AS is_home_9, t0.rank AS rank_10, t0.is_published AS is_published_11, t0.old_id AS old_id_12, t0.menu_id AS menu_id_13 FROM page t0 WHERE t0.menu_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
5 1.73 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.body AS body_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.url AS url_7, t0.target AS target_8, t0.is_home AS is_home_9, t0.rank AS rank_10, t0.is_published AS is_published_11, t0.old_id AS old_id_12, t0.menu_id AS menu_id_13 FROM page t0 WHERE t0.menu_id = ?
Parameters: 
[
  15
]
View formatted query    View runnable query    Explain query
6 0.26 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.body AS body_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.url AS url_7, t0.target AS target_8, t0.is_home AS is_home_9, t0.rank AS rank_10, t0.is_published AS is_published_11, t0.old_id AS old_id_12, t0.menu_id AS menu_id_13 FROM page t0 WHERE t0.menu_id = ?
Parameters: 
[
  22
]
View formatted query    View runnable query    Explain query
7 0.24 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.body AS body_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.url AS url_7, t0.target AS target_8, t0.is_home AS is_home_9, t0.rank AS rank_10, t0.is_published AS is_published_11, t0.old_id AS old_id_12, t0.menu_id AS menu_id_13 FROM page t0 WHERE t0.menu_id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
8 1.06 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.body AS body_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.url AS url_7, t0.target AS target_8, t0.is_home AS is_home_9, t0.rank AS rank_10, t0.is_published AS is_published_11, t0.old_id AS old_id_12, t0.menu_id AS menu_id_13 FROM page t0 WHERE t0.menu_id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
9 0.25 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.body AS body_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.url AS url_7, t0.target AS target_8, t0.is_home AS is_home_9, t0.rank AS rank_10, t0.is_published AS is_published_11, t0.old_id AS old_id_12, t0.menu_id AS menu_id_13 FROM page t0 WHERE t0.menu_id = ?
Parameters: 
[
  7
]
View formatted query    View runnable query    Explain query
10 2.48 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.body AS body_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.url AS url_7, t0.target AS target_8, t0.is_home AS is_home_9, t0.rank AS rank_10, t0.is_published AS is_published_11, t0.old_id AS old_id_12, t0.menu_id AS menu_id_13 FROM page t0 WHERE t0.menu_id = ?
Parameters: 
[
  9
]
View formatted query    View runnable query    Explain query
11 1.85 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.body AS body_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.url AS url_7, t0.target AS target_8, t0.is_home AS is_home_9, t0.rank AS rank_10, t0.is_published AS is_published_11, t0.old_id AS old_id_12, t0.menu_id AS menu_id_13 FROM page t0 WHERE t0.menu_id = ?
Parameters: 
[
  13
]
View formatted query    View runnable query    Explain query
12 0.27 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.body AS body_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.url AS url_7, t0.target AS target_8, t0.is_home AS is_home_9, t0.rank AS rank_10, t0.is_published AS is_published_11, t0.old_id AS old_id_12, t0.menu_id AS menu_id_13 FROM page t0 WHERE t0.menu_id = ?
Parameters: 
[
  17
]
View formatted query    View runnable query    Explain query
13 0.23 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.body AS body_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.url AS url_7, t0.target AS target_8, t0.is_home AS is_home_9, t0.rank AS rank_10, t0.is_published AS is_published_11, t0.old_id AS old_id_12, t0.menu_id AS menu_id_13 FROM page t0 WHERE t0.menu_id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query

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\Course 51
App\Entity\Page 27
App\Entity\CourseCountry 21
App\Entity\Menu 11
App\Entity\Country 2

Entities Mapping

Class Mapping errors
App\Entity\Course No errors.
App\Entity\CourseBookMapper No errors.
App\Entity\CourseCountry No errors.
App\Entity\CourseCountryFee No errors.
App\Entity\Country No errors.
App\Entity\Menu No errors.
App\Entity\Page No errors.