https://follow.webpro-developpement.fr/hobit/sync

Query Metrics

3 Database Queries
3 Different statements
1.85 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.71 ms
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.email AS email_3, t0.username AS username_4, t0.password AS password_5, t0.last_name AS last_name_6, t0.first_name AS first_name_7, t0.phone AS phone_8, t0.token_reset AS token_reset_9, t0.status AS status_10, t0.roles AS roles_11, t0.device AS device_12 FROM lf_users t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.46 ms
SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.speed AS speed_4, t0.speed_accuracy AS speed_accuracy_5, t0.altitude_ellipsoidal AS altitude_ellipsoidal_6, t0.floor AS floor_7, t0.heading_accuracy AS heading_accuracy_8, t0.heading AS heading_9, t0.altitude_accuracy AS altitude_accuracy_10, t0.altitude AS altitude_11, t0.accuracy AS accuracy_12, t0.bearing AS bearing_13, t0.location_provider AS location_provider_14, t0.provider AS provider_15, t0.datePrinted AS datePrinted_16, t0.dateCreatedByServer AS dateCreatedByServer_17, t0.mock AS mock_18, t0.is_moving AS is_moving_19, t0.event AS event_20, t0.odometer AS odometer_21, t0.uuid AS uuid_22, t0.activity_type AS activity_type_23, t0.activity_confidence AS activity_confidence_24, t0.battery_level AS battery_level_25, t0.battery_is_charging AS battery_is_charging_26, t0.withFail AS withFail_27, t0.sync AS sync_28, t0.groupe_id AS groupe_id_29, t0.user_id AS user_id_30 FROM lf_posiiton_gps t0 WHERE t0.sync = ? AND t0.user_id = ? AND t0.activity_type = ? ORDER BY t0.datePrinted ASC, t0.dateCreatedByServer ASC LIMIT 50000
Parameters:
[
  0
  1
  "still"
]
3 0.68 ms
SELECT t0.id AS id_1, t0.dateCreatedByServer AS dateCreatedByServer_2, t0.name AS name_3, t0.group_name AS group_name_4, t0.activity_type AS activity_type_5, t0.group_verif AS group_verif_6, t0.address AS address_7, t0.street AS street_8, t0.number_street AS number_street_9, t0.city AS city_10, t0.postal_code AS postal_code_11, t0.country AS country_12, t0.latitude AS latitude_13, t0.longitude AS longitude_14, t0.type AS type_15, t0.location_type AS location_type_16, t0.id_place AS id_place_17, t0.status AS status_18, t0.dateStartHobit AS dateStartHobit_19, t0.dateEndHobit AS dateEndHobit_20, t0.numberRequest AS numberRequest_21, t0.parent AS parent_22, t0.user_id AS user_id_23 FROM lf_hobit t0 WHERE t0.status = ? AND t0.user_id = ?
Parameters:
[
  "NOW"
  1
]

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\User
  • The mappings App\Entity\User#hobits and App\Entity\Hobit#user are inconsistent with each other.
App\Entity\PositionGps No errors.
App\Entity\Hobit No errors.