Query Metrics
323
Database Queries
25
Different statements
993.84 ms
Query time
0
Invalid entities
2
Cache hits
298
Cache misses
298
Cache puts
Grouped Statements
Time▼ | Count | Info |
---|---|---|
193.00 ms (19.42%) |
2 |
SELECT t0.id AS id_4, t0.name AS name_5, t0.version AS version_6, t0.is_marked_as_deleted AS is_marked_as_deleted_7, t0.deleted_at AS deleted_at_8, t0.discr, t1.student_id AS student_id_9, t2.public AS public_10, t2.description AS description_11, t2.island_type AS island_type_12, t2.created_at AS created_at_13, t2.manager_id AS manager_id_14, t2.classroom_id AS classroom_id_15, t2.template_id AS template_id_16, t3.description AS description_17, t3.island_type AS island_type_18, t3.creator_id AS creator_id_19, t3.template_id AS template_id_20 FROM `World` t0 LEFT JOIN `StudentWorld` t1 ON t0.id = t1.id LEFT JOIN `TeacherWorld` t2 ON t0.id = t2.id LEFT JOIN `ReadingTemplateWorld` t3 ON t0.id = t3.id WHERE t0.id = ?
Parameters:
[
6528
]
|
178.59 ms (17.97%) |
1 |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.`translations` AS translations_2 FROM `Subject` s0_
Parameters:
[] |
174.01 ms (17.51%) |
1 |
SELECT e0_.id AS id_0, e0_.display_name AS display_name_1, e0_.`translations` AS translations_2 FROM `EducationalPathway` e0_
Parameters:
[] |
102.65 ms (10.33%) |
94 |
SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.zoho_name AS zoho_name_3 FROM `DifficultyLevel` t0 INNER JOIN challengeTemplateAssociation_difficultyLevel ON t0.id = challengeTemplateAssociation_difficultyLevel.association_id WHERE challengeTemplateAssociation_difficultyLevel.difficulty_level_id = ?
Parameters:
[
2
]
|
93.48 ms (9.41%) |
94 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.teacher_description AS teacher_description_4, t0.educational_intent AS educational_intent_5, t0.additional_activities AS additional_activities_6, t0.expected_duration AS expected_duration_7, t0.is_reading_challenge AS is_reading_challenge_8, t0.printable_questionnaire AS printable_questionnaire_9, t0.answer_key AS answer_key_10, t0.images AS images_11, t0.rules AS rules_12, t0.disabled AS disabled_13, t0.island_type AS island_type_14, t0.is_highlighted AS is_highlighted_15, t0.is_marked_as_deleted AS is_marked_as_deleted_16, t0.deleted_at AS deleted_at_17, t0.language_id AS language_id_18, t0.content_world AS content_world_19, t0.original_world_id AS original_world_id_20 FROM `ChallengeTemplate` t0 WHERE t0.id = ?
Parameters:
[
9
]
|
61.26 ms (6.16%) |
94 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.`translations` AS translations_3 FROM `Subject` t0 INNER JOIN challengeTemplates_subjects ON t0.id = challengeTemplates_subjects.subject_id WHERE challengeTemplates_subjects.template_id = ?
Parameters:
[
9
]
|
46.96 ms (4.73%) |
1 |
SELECT c0_.id AS id_0, c0_.challenge_template_id AS challenge_template_id_1, c0_.educational_pathway_id AS educational_pathway_id_2 FROM `ChallengeTemplateAssociation` c0_ WHERE c0_.educational_pathway_id = ?
Parameters:
[
2
]
|
34.51 ms (3.47%) |
1 |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.is_historical AS is_historical_2, t0_.is_forDefaultChallenge AS is_forDefaultChallenge_3, t0_.`translations` AS translations_4, t0_.client_id AS client_id_5 FROM `Theme` t0_
Parameters:
[] |
18.80 ms (1.89%) |
9 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.tag AS tag_3, t0.currency AS currency_4, t0.currency_symbol AS currency_symbol_5, t0.is_default AS is_default_6, t0.`translations` AS translations_7, t0.school_calendar_id AS school_calendar_id_8 FROM `Country` t0 INNER JOIN countries_educationalPathways ON t0.id = countries_educationalPathways.country_id WHERE countries_educationalPathways.educational_pathway_id = ?
Parameters:
[
1
]
|
13.39 ms (1.35%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.tag AS tag_2, c0_.currency AS currency_3, c0_.currency_symbol AS currency_symbol_4, c0_.is_default AS is_default_5, c0_.`translations` AS translations_6, c0_.school_calendar_id AS school_calendar_id_7 FROM `Country` c0_ WHERE c0_.tag = ? LIMIT 1
Parameters:
[
"US"
]
|
12.69 ms (1.28%) |
1 |
SELECT l0_.id AS id_0, l0_.language AS language_1, l0_.displayName AS displayName_2, l0_.tag AS tag_3, l0_.isActive AS isActive_4, l0_.noun_sample AS noun_sample_5, l0_.adjective_sample AS adjective_sample_6 FROM `Language` l0_
Parameters:
[] |
11.84 ms (1.19%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.display_order AS display_order_3, t0.translations AS translations_4, t0.description AS description_5, t0.educational_pathway_id AS educational_pathway_id_6 FROM `GradeLevel` t0 WHERE t0.educational_pathway_id = ?
Parameters:
[
2
]
|
9.45 ms (0.95%) |
1 |
SELECT s0_.id AS id_0, s0_.environment AS environment_1, s0_.label AS label_2, s0_.url AS url_3, s0_.icon AS icon_4, s0_.flow AS flow_5, s0_.position AS position_6, s0_.is_published AS is_published_7 FROM `SideMenuOption` s0_ WHERE s0_.environment = ? ORDER BY s0_.position ASC
Parameters:
[
"ENV_CONSTELLATION"
]
|
8.38 ms (0.84%) |
6 |
SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.zoho_name AS zoho_name_3 FROM `DifficultyLevel` t0 INNER JOIN gradeLevel_difficultyLevel ON t0.id = gradeLevel_difficultyLevel.difficulty_level_id WHERE gradeLevel_difficultyLevel.grade_level_id = ?
Parameters:
[
19
]
|
8.34 ms (0.84%) |
1 |
SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.is_crawlable AS is_crawlable_2, i0_.is_legal_document AS is_legal_document_3, i0_.asked_for_validation_on AS asked_for_validation_on_4, i0_.is_default_user_agreement AS is_default_user_agreement_5, i0_.is_default_privacy_policy AS is_default_privacy_policy_6, i0_.is_marketing_privacy_policy AS is_marketing_privacy_policy_7, i0_.is_marked_as_deleted AS is_marked_as_deleted_8, i0_.deleted_at AS deleted_at_9 FROM `InformationPage` i0_ WHERE i0_.is_default_privacy_policy = ? AND i0_.is_marked_as_deleted = 0 LIMIT 1
Parameters:
[
1
]
|
6.07 ms (0.61%) |
2 |
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.url AS url_2, t0_.route AS route_3, t0_.is_active AS is_active_4, t0_.display_on_first_time AS display_on_first_time_5 FROM `TutorialPanel` t0_ WHERE t0_.route = ? AND t0_.is_active = ?
Parameters:
[ "constellation_site_catalog_.en-CA" 1 ] |
5.13 ms (0.52%) |
1 |
SELECT i0_.id AS id_0, i0_.title AS title_1, i0_.text AS text_2, i0_.image AS image_3, i0_.icon_class AS icon_class_4, i0_.route AS route_5, i0_.is_active AS is_active_6, i0_.translations AS translations_7 FROM `InformationPanel` i0_ WHERE i0_.route = ? AND i0_.is_active = ? LIMIT 1
Parameters:
[ "constellation_site_catalog_" 1 ] |
4.56 ms (0.46%) |
1 |
SELECT t0_.id AS id_0, t0_.`content` AS content_1, t0_.lastTranslationUpdate AS lastTranslationUpdate_2, t0_.lastTranslationPageAccess AS lastTranslationPageAccess_3, t0_.lastTranslationPageToken AS lastTranslationPageToken_4, t0_.firstTranslationUpdate AS firstTranslationUpdate_5 FROM `TranslationFile` t0_ ORDER BY t0_.id DESC LIMIT 1
Parameters:
[] |
4.55 ms (0.46%) |
2 |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"nano_ca_dev_merged"
]
|
2.13 ms (0.21%) |
1 |
SELECT l0_.id AS id_0, l0_.language AS language_1, l0_.displayName AS displayName_2, l0_.tag AS tag_3, l0_.isActive AS isActive_4, l0_.noun_sample AS noun_sample_5, l0_.adjective_sample AS adjective_sample_6 FROM `Language` l0_ WHERE l0_.isActive = ?
Parameters:
[
1
]
|
1.02 ms (0.10%) |
2 |
SELECT DATABASE()
Parameters:
[] |
0.94 ms (0.09%) |
2 |
SELECT m0_.id AS id_0, m0_.starting_date AS starting_date_1, m0_.ending_date AS ending_date_2, m0_.is_completed AS is_completed_3 FROM `Maintenance` m0_ WHERE m0_.starting_date < ? AND m0_.ending_date > ? AND m0_.is_completed = 0
Parameters:
[ "2024-10-18 03:01:38" "2024-10-18 03:01:38" ] |
0.93 ms (0.09%) |
2 |
SELECT m0_.id AS id_0, m0_.starting_date AS starting_date_1, m0_.ending_date AS ending_date_2, m0_.is_completed AS is_completed_3 FROM `Maintenance` m0_
Parameters:
[] |
0.59 ms (0.06%) |
1 |
SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.is_crawlable AS is_crawlable_2, i0_.is_legal_document AS is_legal_document_3, i0_.asked_for_validation_on AS asked_for_validation_on_4, i0_.is_default_user_agreement AS is_default_user_agreement_5, i0_.is_default_privacy_policy AS is_default_privacy_policy_6, i0_.is_marketing_privacy_policy AS is_marketing_privacy_policy_7, i0_.is_marked_as_deleted AS is_marked_as_deleted_8, i0_.deleted_at AS deleted_at_9 FROM `InformationPage` i0_ WHERE i0_.is_default_user_agreement = ? AND i0_.is_marked_as_deleted = 0 LIMIT 1
Parameters:
[
1
]
|
0.57 ms (0.06%) |
1 |
SELECT l0_.id AS id_0, l0_.language AS language_1, l0_.displayName AS displayName_2, l0_.tag AS tag_3, l0_.isActive AS isActive_4, l0_.noun_sample AS noun_sample_5, l0_.adjective_sample AS adjective_sample_6 FROM `Language` l0_ WHERE l0_.tag = ?
Parameters:
[
"en-CA"
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
NanomonxManager | doctrine.orm.NanomonxManager_entity_manager |
Second Level Cache
2
Hits
298
Misses
298
Puts
Number of cache hits
Region | Hits |
---|---|
nanomonx | 2 |
Number of cache misses
Region | Misses |
---|---|
nanomonx | 298 |
Number of cache puts
Region | Puts |
---|---|
nanomonx | 298 |