POST https://dev-siae2025.appsalon.fr/webservice/app-salon-update-device

Query Metrics

3 Database Queries
2 Different statements
2.77 ms Query time
3 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 1.58 ms
SELECT t0.id AS id_1, t0.identifiant AS identifiant_2, t0.sync_exposant AS sync_exposant_3, t0.sync_conf AS sync_conf_4, t0.active AS active_5, t0.date AS date_6, t0.version AS version_7, t0.delta_img AS delta_img_8, t0.step AS step_9, t0.steplock AS steplock_10, t0.message AS message_11, t0.light AS light_12, t0.delta_sqlite_filename AS delta_sqlite_filename_13 FROM sync t0 WHERE t0.active = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  1
]
2 0.56 ms
SELECT t0.id AS id_1, t0.identifiant AS identifiant_2, t0.sync_exposant AS sync_exposant_3, t0.sync_conf AS sync_conf_4, t0.active AS active_5, t0.date AS date_6, t0.version AS version_7, t0.delta_img AS delta_img_8, t0.step AS step_9, t0.steplock AS steplock_10, t0.message AS message_11, t0.light AS light_12, t0.delta_sqlite_filename AS delta_sqlite_filename_13 FROM sync t0 WHERE t0.active = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  1
]
3 0.63 ms
SELECT t0.id AS id_1, t0.identifiant AS identifiant_2, t0.token AS token_3, t0.etat AS etat_4, t0.active AS active_5, t0.module AS module_6, t0.position AS position_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.json_config AS json_config_10, t0.json_data_status AS json_data_status_11, t0.first_connection AS first_connection_12, t0.last_connection AS last_connection_13, t0.last_update AS last_update_14, t0.update_version AS update_version_15, t0.is_updated AS is_updated_16, t0.maparea AS maparea_17, t0.zoom AS zoom_18, t0.angle AS angle_19, t0.project_id_id AS project_id_id_20, t0.salle_id AS salle_id_21, t0.map_id AS map_id_22, t0.chart_id AS chart_id_23, t0.appfiltersalon_id AS appfiltersalon_id_24 FROM device t0 WHERE t0.id = ?
Parameters:
[
  31
]

Database Connections

Name Service
default doctrine.dbal.default_connection
urlappsalon doctrine.dbal.urlappsalon_connection
sqlite doctrine.dbal.sqlite_connection

Entity Managers

Name Service
urlappsalon doctrine.orm.urlappsalon_entity_manager
default doctrine.orm.default_entity_manager
sqlite doctrine.orm.sqlite_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

urlappsalon entity manager

No loaded entities.

default entity manager

Class Mapping errors
App\Entity\Sync No errors.
App\Entity\Device No errors.
App\Entity\Salon No errors.
App\Entity\TSalle No errors.
App\Entity\TMap
  • The field App\Entity\TMap#halls is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\THall#tMap does not contain the required 'inversedBy="halls"' attribute.
  • The field App\Entity\TMap#tMapParcours is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\TMapParcours#tMap does not contain the required 'inversedBy="tMapParcours"' attribute.
  • The field App\Entity\TMap#service is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Service#tMap does not contain the required 'inversedBy="service"' attribute.
App\Entity\Chart
  • The mappings App\Entity\Chart#charteImages and App\Entity\ChartImage#chart are inconsistent with each other.
  • The mappings App\Entity\Chart#charteLangues and App\Entity\ChartLangue#chart are inconsistent with each other.
App\Entity\AppFilter
  • The mappings App\Entity\AppFilter#products and App\Entity\TMateriel#appFilters are inconsistent with each other.

sqlite entity manager

No loaded entities.