GET https://troubadour.constellation.cool/theme/time-travelers

Query Metrics

13 Database Queries
9 Different statements
70.08 ms Query time
0 Invalid entities
16 Managed entities
2 Cache hits
0 Cache misses
0 Cache puts

Grouped Statements

Show all queries

Time Count Info
15.19 ms
(21.67%)
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
]
11.58 ms
(16.52%)
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:
[]
10.57 ms
(15.08%)
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_TROUBADOUR"
]
10.15 ms
(14.48%)
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
]
8.70 ms
(12.42%)
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"
]
5.25 ms
(7.49%)
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
]
3.59 ms
(5.13%)
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:
[]
2.79 ms
(3.98%)
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:
[
  "2025-12-02 05:12:02"
  "2025-12-02 05:12:02"
]
2.27 ms
(3.23%)
2
SELECT DATABASE()
Parameters:
[]

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

Managed Entities

NanomonxManager entity manager

Class Amount of managed objects
App\Entity\PageContentManager\SideMenuOption 4
App\Entity\PageContentManager\InformationPageTranslation 4
App\Entity\Maintenance 3
App\Entity\Language 2
App\Entity\PageContentManager\InformationPage 2
App\Entity\TranslationFile 1