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

Method
GET
HTTP Status
302
IP
216.73.216.114
Profiled on
Token
20d394

Query Metrics

45 Database Queries
12 Different statements
61.17 ms Query time
1 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.99 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: 
[
  4
]
View formatted query    View runnable query    Explain query
2 0.98 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
  4
  "still"
]
View formatted query    View runnable query    Explain query
3 1.42 ms 
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
]
View formatted query    View runnable query    Explain query
4 1.39 ms 
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
  82403
  150
]
View formatted query    View runnable query    Explain query
5 1.25 ms 
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
  82404
  150
]
View formatted query    View runnable query    Explain query
6 1.17 ms 
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
  82405
  150
]
View formatted query    View runnable query    Explain query
7 1.20 ms 
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
  82406
  150
]
View formatted query    View runnable query    Explain query
8 1.14 ms 
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
  82410
  150
]
View formatted query    View runnable query    Explain query
9 1.12 ms 
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
  82413
  150
]
View formatted query    View runnable query    Explain query
10 1.09 ms 
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
  82446
  150
]
View formatted query    View runnable query    Explain query
11 1.14 ms 
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
  82447
  150
]
View formatted query    View runnable query    Explain query
12 1.12 ms 
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
  82448
  150
]
View formatted query    View runnable query    Explain query
13 1.05 ms 
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
  82449
  150
]
View formatted query    View runnable query    Explain query
14 0.91 ms 
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
  82502
  150
]
View formatted query    View runnable query    Explain query
15 1.01 ms 
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
  82505
  150
]
View formatted query    View runnable query    Explain query
16 0.90 ms 
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
  82506
  150
]
View formatted query    View runnable query    Explain query
17 0.89 ms 
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
  82507
  150
]
View formatted query    View runnable query    Explain query
18 0.85 ms 
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
  82536
  150
]
View formatted query    View runnable query    Explain query
19 0.83 ms 
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
  82537
  150
]
View formatted query    View runnable query    Explain query
20 0.89 ms 
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
  82538
  150
]
View formatted query    View runnable query    Explain query
21 0.89 ms 
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
  82539
  150
]
View formatted query    View runnable query    Explain query
22 0.94 ms 
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
  82540
  150
]
View formatted query    View runnable query    Explain query
23 0.76 ms 
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
  82615
  150
]
View formatted query    View runnable query    Explain query
24 0.45 ms 
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
  82772
  150
]
View formatted query    View runnable query    Explain query
25 0.80 ms 
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"
]
View formatted query    View runnable query    Explain query
26 0.16 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
27 1.60 ms 
UPDATE lf_posiiton_gps SET sync = ? WHERE id = ?
Parameters: 
[
  1
  82615
]
View formatted query    View runnable query    Explain query
28 1.03 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
29 12.06 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"
  4
]
View formatted query    View runnable query    Explain query
30 0.61 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.user_id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
31 7.71 ms 
SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.status AS status_4, t0.dateCreatedByServer AS dateCreatedByServer_5, t0.dateStartHobit AS dateStartHobit_6, t0.dateEndHobit AS dateEndHobit_7, t0.numberRequest AS numberRequest_8, t0.parent AS parent_9 FROM lf_hobit_date t0 WHERE t0.parent = ? AND t0.status = ? LIMIT 1
Parameters: 
[
  10
  "LAST"
]
View formatted query    View runnable query    Explain query
32 0.25 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
33 1.71 ms 
UPDATE lf_hobit_date SET status = ? WHERE id = ?
Parameters: 
[
  "HISTORY"
  42
]
View formatted query    View runnable query    Explain query
34 1.40 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
35 0.28 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
36 1.39 ms 
INSERT INTO lf_hobit_date (latitude, longitude, status, dateCreatedByServer, dateStartHobit, dateEndHobit, numberRequest, parent) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  "44.426710299574"
  "1.4414094339194"
  "LAST"
  "2025-11-08 09:26:12"
  "2025-06-06 10:04:18"
  "2025-06-06 11:22:16"
  null
  10
]
View formatted query    View runnable query    Explain query
37 1.26 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
38 0.55 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.user_id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
39 2.45 ms 
SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.status AS status_4, t0.dateCreatedByServer AS dateCreatedByServer_5, t0.dateStartHobit AS dateStartHobit_6, t0.dateEndHobit AS dateEndHobit_7, t0.numberRequest AS numberRequest_8, t0.parent AS parent_9 FROM lf_hobit_date t0 WHERE t0.parent = ? AND t0.status = ? LIMIT 1
Parameters: 
[
  8
  "LAST"
]
View formatted query    View runnable query    Explain query
40 0.19 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
41 0.38 ms 
UPDATE lf_hobit_date SET status = ? WHERE id = ?
Parameters: 
[
  "HISTORY"
  43
]
View formatted query    View runnable query    Explain query
42 1.18 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
43 0.17 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
44 0.36 ms 
INSERT INTO lf_hobit_date (latitude, longitude, status, dateCreatedByServer, dateStartHobit, dateEndHobit, numberRequest, parent) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  "44.44402594523"
  "1.4412443302343"
  "NOW"
  "2025-11-08 09:26:12"
  "2025-06-06 11:22:16"
  "2025-11-08 09:26:12"
  null
  8
]
View formatted query    View runnable query    Explain query
45 1.27 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query

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.
App\Entity\HobitDate No errors.