GET https://constellation.constellation.cool/

Query Metrics

9 Database Queries
5 Different statements
8.98 ms Query time
0 Invalid entities
6 Managed entities
1 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

# Time Info
1 0.45 ms
SELECT DATABASE()
Parameters:
[]
2 2.67 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"
]
3 0.52 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:
[]
4 0.50 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:
[
  "2026-04-21 07:12:54"
  "2026-04-21 07:12:54"
]
5 0.42 ms
SELECT DATABASE()
Parameters:
[]
6 2.60 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"
]
7 0.49 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:
[]
8 0.45 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:
[
  "2026-04-21 07:12:54"
  "2026-04-21 07:12:54"
]
9 0.88 ms
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
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
NanomonxManager doctrine.orm.NanomonxManager_entity_manager

Second Level Cache

1 Hits
0 Misses
0 Puts

Number of cache hits

Region Hits
nanomonx 1

Managed Entities

NanomonxManager entity manager

Class Amount of managed objects
App\Entity\Maintenance 3
App\Entity\Language 2
App\Entity\TranslationFile 1

Entities Mapping

Class Mapping errors
App\Entity\Family\Family No errors.
App\Entity\TranslationFile No errors.
App\Entity\Modules\Module No errors.
App\Entity\SchoolCalendar No errors.
App\Entity\Maintenance No errors.
App\Entity\Language No errors.