Symfony Profiler

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

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 0 AND l0_.user_id = 4 AND l0_.id > 82402 AND l0_.accuracy < 150 ORDER BY l0_.datePrinted ASC, l0_.dateCreatedByServer ASC LIMIT 1;

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 = ?

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 = 'NOW' AND t0.user_id = 4;

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

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 = 10 AND t0.status = 'LAST' LIMIT 1;

"COMMIT"

"COMMIT";

UPDATE
  lf_hobit_date
SET
  status = ?
WHERE
  id = ?

UPDATE lf_hobit_date SET status = 'HISTORY' WHERE id = 42;

INSERT INTO lf_hobit_date (
  latitude, longitude, status, dateCreatedByServer,
  dateStartHobit, dateEndHobit, numberRequest,
  parent
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO lf_hobit_date (latitude, longitude, status, dateCreatedByServer, dateStartHobit, dateEndHobit, numberRequest, parent) VALUES ('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);

UPDATE
  lf_posiiton_gps
SET
  sync = ?
WHERE
  id = ?

UPDATE lf_posiiton_gps SET sync = 1 WHERE id = 82615;

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 = ?

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 = 4;

"START TRANSACTION"

"START TRANSACTION";

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 = ?

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 = 4;

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

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 = 0 AND t0.user_id = 4 AND t0.activity_type = 'still' ORDER BY t0.datePrinted ASC, t0.dateCreatedByServer ASC LIMIT 50000;

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

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 0 AND l0_.user_id = 4 AND l0_.activity_confidence = 100 AND l0_.id > 82615 AND l0_.id < 82853 AND l0_.accuracy < 150 AND l0_.activity_type <> 'still' ORDER BY l0_.datePrinted ASC, l0_.dateCreatedByServer ASC LIMIT 200000;