Query Metrics
12
Database Queries
7
Different statements
18.52 ms
Query time
0
Invalid entities
2
Cache hits
0
Cache misses
0
Cache puts
Queries
#▲ | Time | Info |
---|---|---|
1 | 5.88 ms |
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:
[] |
2 | 0.77 ms |
SELECT DATABASE()
Parameters:
[] |
3 | 2.58 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"nano_ca_dev_merged"
]
|
4 | 0.78 ms |
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:
[] |
5 | 0.81 ms |
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-12-18 12:37:46" "2024-12-18 12:37:46" ] |
6 | 0.60 ms |
SELECT DATABASE()
Parameters:
[] |
7 | 2.64 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"nano_ca_dev_merged"
]
|
8 | 0.71 ms |
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:
[] |
9 | 1.04 ms |
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-12-18 12:37:46" "2024-12-18 12:37:46" ] |
10 | 1.06 ms |
SELECT t0.id AS id_1, t0.plguser_state AS plguser_state_2, t0.plgusage_status AS plgusage_status_3, t0.plgonboarding_step AS plgonboarding_step_4, t0.job_title AS job_title_5, t0.organization_type AS organization_type_6, t0.province AS province_7, t0.landing_page_origin AS landing_page_origin_8, t0.is_decision_maker AS is_decision_maker_9, t0.is_troubadour_user AS is_troubadour_user_10, t0.subscription_pending AS subscription_pending_11, t0.subscriptions_used AS subscriptions_used_12, t0.has_valid_subscription AS has_valid_subscription_13, t0.is_freemium AS is_freemium_14, t0.is_school_user AS is_school_user_15, t0.is_family_user AS is_family_user_16, t0.is_dirty AS is_dirty_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.using_activation_code AS using_activation_code_20, t0.manager AS manager_21, t0.pending_account AS pending_account_22 FROM ZohoState t0 WHERE t0.manager = ?
Parameters:
[
89
]
|
11 | 0.90 ms |
SELECT m0_.id AS id_0, m0_.lastChallengeSubmitted AS lastChallengeSubmitted_1, m0_.lastUserChallengeParticipation AS lastUserChallengeParticipation_2, m0_.last_challenge_created AS last_challenge_created_3, m0_.last_user_challenge_review AS last_user_challenge_review_4, m0_.last_product_used AS last_product_used_5, m0_.manager_id AS manager_id_6 FROM `ManagerStats` m0_ WHERE m0_.manager_id = ? LIMIT 1
Parameters:
[
89
]
|
12 | 0.76 ms |
SELECT m0_.id AS id_0, m0_.lastChallengeSubmitted AS lastChallengeSubmitted_1, m0_.lastUserChallengeParticipation AS lastUserChallengeParticipation_2, m0_.last_challenge_created AS last_challenge_created_3, m0_.last_user_challenge_review AS last_user_challenge_review_4, m0_.last_product_used AS last_product_used_5, m0_.manager_id AS manager_id_6 FROM `ManagerStats` m0_ WHERE m0_.manager_id = ? LIMIT 1
Parameters:
[
89
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
NanomonxManager | doctrine.orm.NanomonxManager_entity_manager |
Second Level Cache
2
Hits
0
Misses
0
Puts
Number of cache hits
Region | Hits |
---|---|
nanomonx | 2 |
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\TranslationFile | No errors. |
App\Entity\Troubadour\Challenge | No errors. |
App\Entity\Maintenance | No errors. |
App\Entity\BaseUser | No errors. |
App\Entity\Manager | No errors. |
App\Entity\Country | No errors. |
App\Entity\Catalog\ScholarLevel | No errors. |
App\Entity\UsageType | No errors. |
App\Entity\Language | No errors. |
App\Entity\OnBoardingStatus | No errors. |
App\Entity\Purchases\GroupLicence | No errors. |
App\Entity\Purchases\Subscriptions\Subscription | No errors. |
App\Entity\Purchases\Subscriptions\PackageSubscription | No errors. |
App\Entity\WhiteListedDomain | No errors. |
App\Entity\WhiteListedUser | No errors. |
App\Entity\SchoolYear | No errors. |
App\Entity\PageContentManager\TutorialPanel | No errors. |
App\Entity\UsernameChange | No errors. |
App\Entity\UserRegion | No errors. |
App\Entity\Troubadour\Babillard\Babillard | No errors. |
App\Entity\Zoho\ZohoState | No errors. |
App\Entity\PendingAccount | No errors. |
App\Entity\EducationalInstitution | No errors. |
App\Entity\ManagerStats | No errors. |