GET https://new-mash-test.itlabs.top/api/terminals/status?ulid=01KATYMRPX6VP1ZWE8T5E1SA84

Query Metrics

6 Database Queries
6 Different statements
131.59 ms Query time
0 Invalid entities
3 Managed entities

Queries

Group similar statements

# Time Info
1 0.65 ms
SELECT t0.id AS id_1, t0.ulid AS ulid_2, t0.name AS name_3, t0.type AS type_4, t0.last_sync_at AS last_sync_at_5, t0.last_seen AS last_seen_6, t0.description AS description_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.info_center_calls AS info_center_calls_10, t0.security_control_calls AS security_control_calls_11, t0.ip_address AS ip_address_12, t0.offline_alert_latched AS offline_alert_latched_13, t0.camera AS camera_14, t0.target AS target_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17 FROM terminals t0 WHERE t0.ulid = ? LIMIT 1
Parameters:
[
  b"\x01šµêbÝ6ì\x1FñÈÑ\\x1C©\x04"
]
2 0.20 ms
"START TRANSACTION"
Parameters:
[]
3 0.44 ms
UPDATE terminals SET last_sync_at = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "2026-04-18 07:45:21"
  "2026-04-18 07:45:21"
  27
]
4 129.45 ms
"COMMIT"
Parameters:
[]
5 0.41 ms
SELECT t0.id AS id_1, t0.time AS time_2, t0.terminal_network_online_time AS terminal_network_online_time_3 FROM settings t0 LIMIT 1
Parameters:
[]
6 0.43 ms
SELECT t0_.id AS id_0, t0_.source AS source_1, t0_.status AS status_2, t0_.created_at AS created_at_3, t0_.updated_at AS updated_at_4, t0_.terminal_id AS terminal_id_5 FROM terminal_status_event t0_ WHERE t0_.terminal_id = ? ORDER BY t0_.created_at DESC LIMIT 1
Parameters:
[
  27
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Terminal 1
App\Entity\Settings 1
App\Entity\TerminalStatusEvent 1

Entities Mapping

Class Mapping errors
App\Entity\Settings No errors.
App\Entity\AvatarCategory No errors.
App\Entity\RussPassImage No errors.
App\Entity\Session No errors.
App\Entity\Door No errors.
App\Entity\AvatarVideo No errors.
App\Entity\Poi No errors.
App\Entity\Schedule No errors.
App\Entity\Log No errors.
App\Entity\TerminalStatistic No errors.
App\Entity\SearchQuery No errors.
App\Entity\RussPassBaseObject No errors.
App\Entity\RussPassRestaurant No errors.
App\Entity\ObjectCategory No errors.
App\Entity\ObjectCategoryTranslation No errors.
App\Entity\ContentGroup No errors.
App\Entity\PanoramaPoint No errors.
App\Entity\SearchSuggestion No errors.
App\Entity\AvatarVideoTranslation No errors.
App\Entity\User No errors.
App\Entity\SearchClickThrough No errors.
App\Entity\StaticMedia No errors.
App\Entity\Panorama No errors.
App\Entity\NavigationRoute No errors.
App\Entity\ContentItem No errors.
App\Entity\Bugs No errors.
App\Entity\Terminal No errors.
App\Entity\RussPassEvent No errors.
App\Entity\Feedback No errors.
App\Entity\Building No errors.
App\Entity\ContactInfo No errors.
App\Entity\Instruction No errors.
App\Entity\Event No errors.
App\Entity\EventTranslation No errors.
App\Entity\Camera No errors.
App\Entity\Map No errors.
App\Entity\RussPassTag No errors.
App\Entity\TerminalGroup No errors.
App\Entity\EventImage No errors.
App\Entity\TerminalStatusEvent No errors.
App\Entity\MapImage No errors.
App\Entity\PanoramaImage No errors.
App\Entity\TransitionCategory No errors.
App\Entity\PoiTranslation No errors.
App\Entity\ScheduleContent No errors.
App\Entity\ContentGroupPosition No errors.
App\Entity\InformationVideo No errors.
App\Entity\Media No errors.
Vich\UploaderBundle\Entity\File No errors.