Query Metrics
26
Database Queries
5
Different statements
57.82 ms
Query time
1
Invalid entities
Grouped Statements
| 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 |
|
| App\Entity\PositionGps | No errors. |
| App\Entity\Hobit | No errors. |
| App\Entity\HobitDate | No errors. |