http://connect.vackelys.fr/api/commande?commandeId=9628&method=getOriginInstanceSite

Query Metrics

9 Database Queries
9 Different statements
11.64 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 1.11 ms
SELECT a0_.id AS id_0, a0_.token AS token_1, a0_.expires_at AS expires_at_2, a0_.user_id AS user_id_3 FROM api_token a0_ WHERE a0_.token = ?
Parameters:
[
  "o56dfg9s6p-pfrtn58d63-utr5d8r669-0dpm56q3e7-8v5f2g6s48"
]
2 1.68 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.username AS username_4, t0.email AS email_5, t0.password AS password_6, t0.salt AS salt_7, t0.last_link_requested_at AS last_link_requested_at_8, t0.instance_id AS instance_id_9, t0.role_group_id AS role_group_id_10 FROM user t0 WHERE t0.id = ?
Parameters:
[
  44
]
3 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.rolename AS rolename_3 FROM role_group t0 WHERE t0.id = ?
Parameters:
[
  1
]
4 0.78 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.module AS module_3 FROM role t0 INNER JOIN role_role_group ON t0.id = role_role_group.role_id WHERE role_role_group.role_group_id = ?
Parameters:
[
  1
]
5 0.55 ms
SELECT t0.id AS id_1, t0.hash_value AS hash_value_2, t0.execute AS execute_3, t0.status AS status_4, t0.commande_id AS commande_id_5, t0.allow_execute AS allow_execute_6, t0.sejour_id AS sejour_id_7, t0.instance_id AS instance_id_8 FROM commande t0 WHERE t0.id = ?
Parameters:
[
  "9628"
]
6 1.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.dbname AS dbname_3, t0.host AS host_4, t0.password AS password_5, t0.dbuser AS dbuser_6, t0.site AS site_7, t0.allow_sync_commande AS allow_sync_commande_8 FROM instance t0 WHERE t0.id = ?
Parameters:
[
  2
]
7 0.75 ms
"START TRANSACTION"
Parameters:
[]
8 0.64 ms
INSERT INTO api_logs (date_time, url, method, request_ip, api_key, authenticated, ressource, ressource_id, params, has_exception, exception_class, exception_message, exception_code, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "2026-03-26 09:56:00"
  2 => "/api/commande?method=getOriginInstanceSite&commandeId=9628"
  3 => "GET"
  4 => "10.42.158.175"
  5 => "o56dfg9s6p-pfrtn58d63-utr5d8r669-0dpm56q3e7-8v5f2g6s48"
  6 => 1
  7 => "commande"
  8 => null
  9 => "a:2:{s:3:"get";a:2:{s:6:"method";s:21:"getOriginInstanceSite";s:10:"commandeId";s:4:"9628";}s:4:"post";a:0:{}}"
  10 => 0
  11 => null
  12 => null
  13 => null
  14 => 44
]
9 4.46 ms
"COMMIT"
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\ApiToken No errors.
App\Entity\User No errors.
App\Entity\Instance No errors.
App\Entity\RoleGroup No errors.
App\Entity\Role No errors.
App\Entity\ApiLogs No errors.
App\Entity\Commande No errors.
App\Entity\Sejour
  • The association App\Entity\Sejour#organisateur refers to the inverse side field App\Entity\Organisateur#sejour which does not exist.
  • The association App\Entity\Sejour#destination refers to the inverse side field App\Entity\Destination#sejour which does not exist.
App\Entity\Organisateur
  • The association App\Entity\Organisateur#users refers to the owning side field App\Entity\User#organisateur which does not exist.
App\Entity\PartageSejour No errors.
App\Entity\PartageSejourAlert No errors.
App\Entity\Enseigne No errors.
App\Entity\CommandeClient No errors.