GET https://dev-ligams.mapyourdream.com/

Query Metrics

4 Database Queries
3 Different statements
30.80 ms Query time
0 Invalid entities
4 Managed entities

Grouped Statements

Show all queries

Time Count Info
25.01 ms
(81.19%)
1
SELECT CONCAT(ordre, ' - ', nom_relais), id
    FROM public.search_relais
    WHERE id_edition = ?
    ORDER BY ordre, nom_relais ASC
Parameters:
[
  5
]
3.89 ms
(12.61%)
2
SELECT e0_.id AS id_0, e0_.nom_edition AS nom_edition_1, e0_.date_debut AS date_debut_2, e0_.date_fin AS date_fin_3, e0_.reference_uuid AS reference_uuid_4 FROM edition e0_ WHERE e0_.archived = ? AND (e0_.date_fin IS NULL OR e0_.date_fin >= '2026-03-30') ORDER BY e0_.date_debut DESC LIMIT 1
Parameters:
[
  0
]
1.91 ms
(6.20%)
1
SELECT c0_.id AS id_0, c0_.entitled AS entitled_1, c0_.description AS description_2, c0_.vitesse AS vitesse_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.archived AS archived_6, c0_.file_name AS file_name_7, c0_.file_original_name AS file_original_name_8, c0_.file_mime_type AS file_mime_type_9, c0_.file_size AS file_size_10, c0_.file_dimensions AS file_dimensions_11, c0_.category_id AS category_id_12, c0_.edition_id AS edition_id_13, c0_.created_by AS created_by_14, c0_.updated_by AS updated_by_15 FROM custom_list_item c0_ INNER JOIN custom_list_category c1_ ON c0_.category_id = c1_.id WHERE c1_.code = ? AND c0_.archived = ?
Parameters:
[
  "evenement_type"
  0
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\CustomListItem 1
App\Entity\CustomListCategory 1
App\Entity\Edition 1
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\Edition No errors.
Vich\UploaderBundle\Entity\File No errors.
App\Entity\CustomListItem No errors.
App\Entity\CustomListCategory No errors.
App\Entity\User No errors.
App\Entity\Account No errors.
App\Entity\Evenement No errors.
App\Entity\Relais No errors.