GET https://ccert.edu.in/computer-franchise-in-nigeria.html

Response
200 OK
IP
216.73.217.122
Profiled on
Token
0f63a5

Query Metrics

19 Database Queries
6 Different statements
8.02 ms Query time
0 Invalid entities
56 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.95 ms 
SELECT c0_.guid AS guid_0, c0_.id AS id_1, c0_.name AS name_2, c0_.iso AS iso_3, c0_.iso2 AS iso2_4, c0_.iso_numeric AS iso_numeric_5, c0_.phone_code AS phone_code_6, c0_.currency_iso AS currency_iso_7, c0_.activation_fee AS activation_fee_8, c0_.renewal_fee AS renewal_fee_9, c0_.minimum_fund_allowed AS minimum_fund_allowed_10, c0_.capital_city AS capital_city_11, c0_.is_active AS is_active_12, c0_.created_at AS created_at_13, c0_.updated_at AS updated_at_14 FROM country c0_ WHERE LOWER(c0_.iso2) = ? OR LOWER(c0_.iso) = ? OR LOWER(c0_.name) = ? LIMIT 1
Parameters: 
[
  "nigeria"
  "nigeria"
  "nigeria"
]
View formatted query    View runnable query    Explain query
2 1.62 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_ INNER JOIN course_country c1_ ON c0_.id = c1_.course_id AND (c1_.country_id = ?) WHERE c0_.status = ? AND c0_.is_public = ? ORDER BY c0_.name ASC
Parameters: 
[
  3
  "a"
  1
]
View formatted query    View runnable query    Explain query
3 0.76 ms 
SELECT c0_.course_id AS sclr_0, c0_.fee AS fee_1 FROM course_country_fee c0_ WHERE c0_.course_id IN (?, ?, ?, ?, ?, ?, ?, ?) AND c0_.country_id = ?
Parameters: 
[
  62
  60
  10
  9
  30
  61
  6
  14
  3
]
View formatted query    View runnable query    Explain query
4 0.50 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
5 0.39 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
6 0.29 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
7 0.28 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
8 0.30 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
9 0.22 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
10 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
11 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: 
[
  9
]
View formatted query    View runnable query    Explain query
12 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: 
[
  13
]
View formatted query    View runnable query    Explain query
13 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: 
[
  17
]
View formatted query    View runnable query    Explain query
14 0.22 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
15 0.49 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
16 0.27 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
17 0.29 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
18 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: 
[
  19
]
View formatted query    View runnable query    Explain query
19 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: 
[
  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\Page 32
App\Entity\Menu 14
App\Entity\Course 8
App\Entity\Country 2

Entities Mapping

Class Mapping errors
App\Entity\Country No errors.
App\Entity\Course No errors.
App\Entity\CourseCountry No errors.
App\Entity\CourseBookMapper No errors.
App\Entity\CourseCountryFee 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.