POST https://troubadour.constellation.cool/rest/report-inactivity

Query Metrics

12 Database Queries
7 Different statements
14.26 ms Query time
0 Invalid entities
2 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

# Time Info
1 5.40 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.50 ms
SELECT DATABASE()
Parameters:
[]
3 2.28 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.47 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.48 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-10-22 13:31:01"
  "2024-10-22 13:31:01"
]
6 0.30 ms
SELECT DATABASE()
Parameters:
[]
7 2.01 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.39 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 0.44 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-10-22 13:31:01"
  "2024-10-22 13:31:01"
]
10 0.90 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.57 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.51 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