Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

1.35 ms Query time

3 Invalid entities

4 Managed entities

Queries

Group similar statements

default connection

#▲	Time	Info
1	0.51 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`] View formatted query View runnable query Explain query 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 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 = 1 ORDER BY t0.id DESC LIMIT 1;
2	0.32 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`] View formatted query View runnable query Explain query 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 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 = 1 ORDER BY t0.id DESC LIMIT 1;
3	0.51 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.wall AS wall_7, t0.position AS position_8, t0.latitude AS latitude_9, t0.latitude_globale AS latitude_globale_10, t0.longitude_globale AS longitude_globale_11, t0.longitude AS longitude_12, t0.json_config AS json_config_13, t0.json_data_status AS json_data_status_14, t0.first_connection AS first_connection_15, t0.last_connection AS last_connection_16, t0.last_update AS last_update_17, t0.update_version AS update_version_18, t0.is_updated AS is_updated_19, t0.maparea AS maparea_20, t0.zoom AS zoom_21, t0.angle AS angle_22, t0.project_id_id AS project_id_id_23, t0.salle_id AS salle_id_24, t0.map_id AS map_id_25, t0.chart_id AS chart_id_26, t0.appfiltersalon_id AS appfiltersalon_id_27 FROM device t0 WHERE t0.id = ? Parameters: [`193`] View formatted query View runnable query Explain query 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.wall AS wall_7, t0.position AS position_8, t0.latitude AS latitude_9, t0.latitude_globale AS latitude_globale_10, t0.longitude_globale AS longitude_globale_11, t0.longitude AS longitude_12, t0.json_config AS json_config_13, t0.json_data_status AS json_data_status_14, t0.first_connection AS first_connection_15, t0.last_connection AS last_connection_16, t0.last_update AS last_update_17, t0.update_version AS update_version_18, t0.is_updated AS is_updated_19, t0.maparea AS maparea_20, t0.zoom AS zoom_21, t0.angle AS angle_22, t0.project_id_id AS project_id_id_23, t0.salle_id AS salle_id_24, t0.map_id AS map_id_25, t0.chart_id AS chart_id_26, t0.appfiltersalon_id AS appfiltersalon_id_27 FROM device t0 WHERE t0.id = ? 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.wall AS wall_7, t0.position AS position_8, t0.latitude AS latitude_9, t0.latitude_globale AS latitude_globale_10, t0.longitude_globale AS longitude_globale_11, t0.longitude AS longitude_12, t0.json_config AS json_config_13, t0.json_data_status AS json_data_status_14, t0.first_connection AS first_connection_15, t0.last_connection AS last_connection_16, t0.last_update AS last_update_17, t0.update_version AS update_version_18, t0.is_updated AS is_updated_19, t0.maparea AS maparea_20, t0.zoom AS zoom_21, t0.angle AS angle_22, t0.project_id_id AS project_id_id_23, t0.salle_id AS salle_id_24, t0.map_id AS map_id_25, t0.chart_id AS chart_id_26, t0.appfiltersalon_id AS appfiltersalon_id_27 FROM device t0 WHERE t0.id = 193;

#▲

Time

Info

0.51 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
]

View formatted query View runnable query Explain query

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

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 = 1 ORDER BY t0.id DESC LIMIT 1;

0.32 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
]

View formatted query View runnable query Explain query

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

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 = 1 ORDER BY t0.id DESC LIMIT 1;

0.51 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.wall AS wall_7, t0.position AS position_8, t0.latitude AS latitude_9, t0.latitude_globale AS latitude_globale_10, t0.longitude_globale AS longitude_globale_11, t0.longitude AS longitude_12, t0.json_config AS json_config_13, t0.json_data_status AS json_data_status_14, t0.first_connection AS first_connection_15, t0.last_connection AS last_connection_16, t0.last_update AS last_update_17, t0.update_version AS update_version_18, t0.is_updated AS is_updated_19, t0.maparea AS maparea_20, t0.zoom AS zoom_21, t0.angle AS angle_22, t0.project_id_id AS project_id_id_23, t0.salle_id AS salle_id_24, t0.map_id AS map_id_25, t0.chart_id AS chart_id_26, t0.appfiltersalon_id AS appfiltersalon_id_27 FROM device t0 WHERE t0.id = ?

Parameters:

[
  193
]

View formatted query View runnable query Explain query

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.wall AS wall_7,
  t0.position AS position_8,
  t0.latitude AS latitude_9,
  t0.latitude_globale AS latitude_globale_10,
  t0.longitude_globale AS longitude_globale_11,
  t0.longitude AS longitude_12,
  t0.json_config AS json_config_13,
  t0.json_data_status AS json_data_status_14,
  t0.first_connection AS first_connection_15,
  t0.last_connection AS last_connection_16,
  t0.last_update AS last_update_17,
  t0.update_version AS update_version_18,
  t0.is_updated AS is_updated_19,
  t0.maparea AS maparea_20,
  t0.zoom AS zoom_21,
  t0.angle AS angle_22,
  t0.project_id_id AS project_id_id_23,
  t0.salle_id AS salle_id_24,
  t0.map_id AS map_id_25,
  t0.chart_id AS chart_id_26,
  t0.appfiltersalon_id AS appfiltersalon_id_27
FROM
  device t0
WHERE
  t0.id = ?

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.wall AS wall_7, t0.position AS position_8, t0.latitude AS latitude_9, t0.latitude_globale AS latitude_globale_10, t0.longitude_globale AS longitude_globale_11, t0.longitude AS longitude_12, t0.json_config AS json_config_13, t0.json_data_status AS json_data_status_14, t0.first_connection AS first_connection_15, t0.last_connection AS last_connection_16, t0.last_update AS last_update_17, t0.update_version AS update_version_18, t0.is_updated AS is_updated_19, t0.maparea AS maparea_20, t0.zoom AS zoom_21, t0.angle AS angle_22, t0.project_id_id AS project_id_id_23, t0.salle_id AS salle_id_24, t0.map_id AS map_id_25, t0.chart_id AS chart_id_26, t0.appfiltersalon_id AS appfiltersalon_id_27 FROM device t0 WHERE t0.id = 193;

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.

Managed Entities

urlappsalon entity manager

Class	Amount of managed objects

default entity manager

Class	Amount of managed objects
App\Entity\Sync	1
App\Entity\Device	1
App\Entity\Salon	1
App\Entity\Chart	1

sqlite entity manager

Class	Amount of managed objects

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.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

urlappsalon entity manager

default entity manager

sqlite entity manager

Entities Mapping

urlappsalon entity manager

default entity manager

sqlite entity manager