GET https://ccert.edu.in/course/list

Response
200 OK
IP
216.73.217.122
Profiled on
Token
597082

Query Metrics

20 Database Queries
6 Different statements
15.53 ms Query time
0 Invalid entities
120 Managed entities

Queries

Group similar statements

#▲ Time Info
1 10.58 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 1.04 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 0.41 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 0.34 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 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: 
[
  15
]
View formatted query    View runnable query    Explain query
6 0.19 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.21 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 0.19 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.17 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 0.16 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 0.20 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.18 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.16 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
14 0.28 ms 
SELECT t0.guid AS guid_1, t0.id AS id_2, t0.name AS name_3, t0.iso AS iso_4, t0.iso2 AS iso2_5, t0.iso_numeric AS iso_numeric_6, t0.phone_code AS phone_code_7, t0.currency_iso AS currency_iso_8, t0.activation_fee AS activation_fee_9, t0.renewal_fee AS renewal_fee_10, t0.minimum_fund_allowed AS minimum_fund_allowed_11, t0.capital_city AS capital_city_12, t0.is_active AS is_active_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM country t0 WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
15 0.19 ms 
SELECT t0.guid AS guid_1, t0.id AS id_2, t0.name AS name_3, t0.iso AS iso_4, t0.iso2 AS iso2_5, t0.iso_numeric AS iso_numeric_6, t0.phone_code AS phone_code_7, t0.currency_iso AS currency_iso_8, t0.activation_fee AS activation_fee_9, t0.renewal_fee AS renewal_fee_10, t0.minimum_fund_allowed AS minimum_fund_allowed_11, t0.capital_city AS capital_city_12, t0.is_active AS is_active_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM country t0 WHERE t0.id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
16 0.27 ms 
SELECT t0.guid AS guid_1, t0.id AS id_2, t0.name AS name_3, t0.iso AS iso_4, t0.iso2 AS iso2_5, t0.iso_numeric AS iso_numeric_6, t0.phone_code AS phone_code_7, t0.currency_iso AS currency_iso_8, t0.activation_fee AS activation_fee_9, t0.renewal_fee AS renewal_fee_10, t0.minimum_fund_allowed AS minimum_fund_allowed_11, t0.capital_city AS capital_city_12, t0.is_active AS is_active_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM country t0 WHERE t0.is_active = ? ORDER BY t0.name ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
17 0.19 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: 
[
  "bottom"
]
View formatted query    View runnable query    Explain query
18 0.21 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: 
[
  18
]
View formatted query    View runnable query    Explain query
19 0.17 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: 
[
  19
]
View formatted query    View runnable query    Explain query
20 0.17 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: 
[
  20
]
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 32
App\Entity\CourseCountry 21
App\Entity\Menu 14
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.
App\Entity\Ebook No errors.
App\Entity\EbookChapter No errors.
App\Entity\EbookSection No errors.