Query Metrics

26 Database Queries
5 Different statements
57.82 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
34.18 ms
(59.11%)
22
SELECT l0_.id AS id_0, l0_.latitude AS latitude_1, l0_.longitude AS longitude_2, l0_.speed AS speed_3, l0_.speed_accuracy AS speed_accuracy_4, l0_.altitude_ellipsoidal AS altitude_ellipsoidal_5, l0_.floor AS floor_6, l0_.heading_accuracy AS heading_accuracy_7, l0_.heading AS heading_8, l0_.altitude_accuracy AS altitude_accuracy_9, l0_.altitude AS altitude_10, l0_.accuracy AS accuracy_11, l0_.bearing AS bearing_12, l0_.location_provider AS location_provider_13, l0_.provider AS provider_14, l0_.datePrinted AS datePrinted_15, l0_.dateCreatedByServer AS dateCreatedByServer_16, l0_.mock AS mock_17, l0_.is_moving AS is_moving_18, l0_.event AS event_19, l0_.odometer AS odometer_20, l0_.uuid AS uuid_21, l0_.activity_type AS activity_type_22, l0_.activity_confidence AS activity_confidence_23, l0_.battery_level AS battery_level_24, l0_.battery_is_charging AS battery_is_charging_25, l0_.withFail AS withFail_26, l0_.sync AS sync_27, l0_.groupe_id AS groupe_id_28, l0_.user_id AS user_id_29 FROM lf_posiiton_gps l0_ WHERE l0_.sync LIKE ? AND l0_.user_id = ? AND l0_.id > ? AND l0_.accuracy < ? ORDER BY l0_.datePrinted ASC, l0_.dateCreatedByServer ASC LIMIT 1
Parameters:
[
  0
  4
  82402
  150
]
14.13 ms
(24.44%)
1
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
  4
  "still"
]
7.21 ms
(12.47%)
1
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
Parameters:
[]
1.22 ms
(2.12%)
1
SELECT l0_.id AS id_0, l0_.latitude AS latitude_1, l0_.longitude AS longitude_2, l0_.speed AS speed_3, l0_.speed_accuracy AS speed_accuracy_4, l0_.altitude_ellipsoidal AS altitude_ellipsoidal_5, l0_.floor AS floor_6, l0_.heading_accuracy AS heading_accuracy_7, l0_.heading AS heading_8, l0_.altitude_accuracy AS altitude_accuracy_9, l0_.altitude AS altitude_10, l0_.accuracy AS accuracy_11, l0_.bearing AS bearing_12, l0_.location_provider AS location_provider_13, l0_.provider AS provider_14, l0_.datePrinted AS datePrinted_15, l0_.dateCreatedByServer AS dateCreatedByServer_16, l0_.mock AS mock_17, l0_.is_moving AS is_moving_18, l0_.event AS event_19, l0_.odometer AS odometer_20, l0_.uuid AS uuid_21, l0_.activity_type AS activity_type_22, l0_.activity_confidence AS activity_confidence_23, l0_.battery_level AS battery_level_24, l0_.battery_is_charging AS battery_is_charging_25, l0_.withFail AS withFail_26, l0_.sync AS sync_27, l0_.groupe_id AS groupe_id_28, l0_.user_id AS user_id_29 FROM lf_posiiton_gps l0_ WHERE l0_.sync LIKE ? AND l0_.user_id = ? AND l0_.activity_confidence = ? AND l0_.id > ? AND l0_.id < ? AND l0_.accuracy < ? AND l0_.activity_type <> ? ORDER BY l0_.datePrinted ASC, l0_.dateCreatedByServer ASC LIMIT 200000
Parameters:
[
  0
  4
  100
  82615
  82853
  150
  "still"
]
1.07 ms
(1.86%)
1
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:
[
  4
]

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.