GET http://test-ws-garmin.unicancer.fr/

Query Metrics

12 Database Queries
2 Different statements
5.16 ms Query time
0 Invalid entities
10 Managed entities

Queries

Group similar statements

default connection

# Time Info
1 1.72 ms
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 = '.,' NLS_DATE_LANGUAGE = 'AMERICAN'
Parameters:
[]
2 1.19 ms
SELECT a.* FROM (SELECT t0.locale AS LOCALE_1, t0.country AS COUNTRY_2, t0.lang AS LANG_3, t0.flag AS FLAG_4, t0.country_native AS COUNTRY_NATIVE_5, t0.sub_languages AS SUB_LANGUAGES_6 FROM LANGUAGES t0 WHERE t0.locale = ?) a WHERE ROWNUM <= 1
Parameters:
[
  "fr_fr"
]
3 0.28 ms
SELECT a.* FROM (SELECT t0.locale AS LOCALE_1, t0.country AS COUNTRY_2, t0.lang AS LANG_3, t0.flag AS FLAG_4, t0.country_native AS COUNTRY_NATIVE_5, t0.sub_languages AS SUB_LANGUAGES_6 FROM LANGUAGES t0 WHERE t0.locale = ?) a WHERE ROWNUM <= 1
Parameters:
[
  "en_gb"
]
4 0.22 ms
SELECT a.* FROM (SELECT t0.locale AS LOCALE_1, t0.country AS COUNTRY_2, t0.lang AS LANG_3, t0.flag AS FLAG_4, t0.country_native AS COUNTRY_NATIVE_5, t0.sub_languages AS SUB_LANGUAGES_6 FROM LANGUAGES t0 WHERE t0.locale = ?) a WHERE ROWNUM <= 1
Parameters:
[
  "it_it"
]
5 0.21 ms
SELECT a.* FROM (SELECT t0.locale AS LOCALE_1, t0.country AS COUNTRY_2, t0.lang AS LANG_3, t0.flag AS FLAG_4, t0.country_native AS COUNTRY_NATIVE_5, t0.sub_languages AS SUB_LANGUAGES_6 FROM LANGUAGES t0 WHERE t0.locale = ?) a WHERE ROWNUM <= 1
Parameters:
[
  "de_de"
]
6 0.22 ms
SELECT a.* FROM (SELECT t0.locale AS LOCALE_1, t0.country AS COUNTRY_2, t0.lang AS LANG_3, t0.flag AS FLAG_4, t0.country_native AS COUNTRY_NATIVE_5, t0.sub_languages AS SUB_LANGUAGES_6 FROM LANGUAGES t0 WHERE t0.locale = ?) a WHERE ROWNUM <= 1
Parameters:
[
  "es_es"
]
7 0.20 ms
SELECT a.* FROM (SELECT t0.locale AS LOCALE_1, t0.country AS COUNTRY_2, t0.lang AS LANG_3, t0.flag AS FLAG_4, t0.country_native AS COUNTRY_NATIVE_5, t0.sub_languages AS SUB_LANGUAGES_6 FROM LANGUAGES t0 WHERE t0.locale = ?) a WHERE ROWNUM <= 1
Parameters:
[
  "jp_jp"
]
8 0.22 ms
SELECT a.* FROM (SELECT t0.locale AS LOCALE_1, t0.country AS COUNTRY_2, t0.lang AS LANG_3, t0.flag AS FLAG_4, t0.country_native AS COUNTRY_NATIVE_5, t0.sub_languages AS SUB_LANGUAGES_6 FROM LANGUAGES t0 WHERE t0.locale = ?) a WHERE ROWNUM <= 1
Parameters:
[
  "nl_nl"
]
9 0.29 ms
SELECT a.* FROM (SELECT t0.locale AS LOCALE_1, t0.country AS COUNTRY_2, t0.lang AS LANG_3, t0.flag AS FLAG_4, t0.country_native AS COUNTRY_NATIVE_5, t0.sub_languages AS SUB_LANGUAGES_6 FROM LANGUAGES t0 WHERE t0.locale = ?) a WHERE ROWNUM <= 1
Parameters:
[
  "pt_pt"
]
10 0.22 ms
SELECT a.* FROM (SELECT t0.locale AS LOCALE_1, t0.country AS COUNTRY_2, t0.lang AS LANG_3, t0.flag AS FLAG_4, t0.country_native AS COUNTRY_NATIVE_5, t0.sub_languages AS SUB_LANGUAGES_6 FROM LANGUAGES t0 WHERE t0.locale = ?) a WHERE ROWNUM <= 1
Parameters:
[
  "pt_br"
]
11 0.20 ms
SELECT a.* FROM (SELECT t0.locale AS LOCALE_1, t0.country AS COUNTRY_2, t0.lang AS LANG_3, t0.flag AS FLAG_4, t0.country_native AS COUNTRY_NATIVE_5, t0.sub_languages AS SUB_LANGUAGES_6 FROM LANGUAGES t0 WHERE t0.locale = ?) a WHERE ROWNUM <= 1
Parameters:
[
  "pl_pl"
]
12 0.21 ms
SELECT a.* FROM (SELECT t0.locale AS LOCALE_1, t0.country AS COUNTRY_2, t0.lang AS LANG_3, t0.flag AS FLAG_4, t0.country_native AS COUNTRY_NATIVE_5, t0.sub_languages AS SUB_LANGUAGES_6 FROM LANGUAGES t0 WHERE t0.locale = ?) a WHERE ROWNUM <= 1
Parameters:
[
  "gr_el"
]

Database Connections

Name Service
default doctrine.dbal.default_connection
tiers_connection doctrine.dbal.tiers_connection_connection
reponses_connection doctrine.dbal.reponses_connection_connection
guests_connection doctrine.dbal.guests_connection_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
tiers_manager doctrine.orm.tiers_manager_entity_manager
reponses_manager doctrine.orm.reponses_manager_entity_manager
guests doctrine.orm.guests_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Meta\Languages 10

tiers_manager entity manager

Class Amount of managed objects

reponses_manager entity manager

Class Amount of managed objects

guests entity manager

Class Amount of managed objects

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\Default\Patient No errors.
App\Entity\Default\PatientPatient No errors.
App\Entity\Meta\Languages No errors.
App\Entity\Default\Facility No errors.

tiers_manager entity manager

Class Mapping errors
App\Entity\Tiers\PatientIdentity No errors.

reponses_manager entity manager

No loaded entities.

guests entity manager

No loaded entities.