http://cartevisite.ensam.eu/v/card/refreshpending

Query Metrics

2 Database Queries
2 Different statements
29.83 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
28.74 ms
(96.36%)
1
select *
			from vcard
			order by rank() over (partition by ide_dossier order by d_modification desc)
			fetch first row with ties
Parameters:
[]
1.09 ms
(3.64%)
1
ALTER SESSION SET NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,'
Parameters:
[]

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.

Entities Mapping

Class Mapping errors
App\Entity\VCard No errors.