Symfony Profiler

Query Metrics

31 Database Queries
5 Different statements
50.36 ms Query time
0 Invalid entities
1 Managed entities
Queries


SELECT t0.id AS id_1, t0.token AS token_2, t0.platform AS platform_3, t0.app_version AS app_version_4, t0.os_version AS os_version_5, t0.locale AS locale_6, t0.external_user_id AS external_user_id_7, t0.app AS app_8, t0.apns_env AS apns_env_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.last_seen_at AS last_seen_at_13 FROM push_devices t0 WHERE t0.token = ? LIMIT 1
"START TRANSACTION"
UPDATE push_devices SET last_seen_at = ? WHERE id = ?
"COMMIT"
SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.error AS error_2, p0_.created_at AS created_at_3, p0_.delivered_at AS delivered_at_4, p0_.seen_at AS seen_at_5, p0_.notification_id AS notification_id_6, p0_.device_id AS device_id_7 FROM push_deliveries p0_ WHERE p0_.device_id = ? AND p0_.status = ? ORDER BY p0_.created_at DESC LIMIT 100
SELECT t0.id AS id_1, t0.token AS token_2, t0.platform AS platform_3, t0.app_version AS app_version_4, t0.os_version AS os_version_5, t0.locale AS locale_6, t0.external_user_id AS external_user_id_7, t0.app AS app_8, t0.apns_env AS apns_env_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.last_seen_at AS last_seen_at_13 FROM push_devices t0 WHERE t0.token = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.error AS error_2, p0_.created_at AS created_at_3, p0_.delivered_at AS delivered_at_4, p0_.seen_at AS seen_at_5, p0_.notification_id AS notification_id_6, p0_.device_id AS device_id_7 FROM push_deliveries p0_ WHERE p0_.device_id = ? AND p0_.status = ? ORDER BY p0_.created_at DESC LIMIT 100
SELECT t0.id AS id_1, t0.token AS token_2, t0.platform AS platform_3, t0.app_version AS app_version_4, t0.os_version AS os_version_5, t0.locale AS locale_6, t0.external_user_id AS external_user_id_7, t0.app AS app_8, t0.apns_env AS apns_env_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.last_seen_at AS last_seen_at_13 FROM push_devices t0 WHERE t0.token = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.error AS error_2, p0_.created_at AS created_at_3, p0_.delivered_at AS delivered_at_4, p0_.seen_at AS seen_at_5, p0_.notification_id AS notification_id_6, p0_.device_id AS device_id_7 FROM push_deliveries p0_ WHERE p0_.device_id = ? AND p0_.status = ? ORDER BY p0_.created_at DESC LIMIT 100
SELECT t0.id AS id_1, t0.token AS token_2, t0.platform AS platform_3, t0.app_version AS app_version_4, t0.os_version AS os_version_5, t0.locale AS locale_6, t0.external_user_id AS external_user_id_7, t0.app AS app_8, t0.apns_env AS apns_env_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.last_seen_at AS last_seen_at_13 FROM push_devices t0 WHERE t0.token = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.error AS error_2, p0_.created_at AS created_at_3, p0_.delivered_at AS delivered_at_4, p0_.seen_at AS seen_at_5, p0_.notification_id AS notification_id_6, p0_.device_id AS device_id_7 FROM push_deliveries p0_ WHERE p0_.device_id = ? AND p0_.status = ? ORDER BY p0_.created_at DESC LIMIT 100
SELECT t0.id AS id_1, t0.token AS token_2, t0.platform AS platform_3, t0.app_version AS app_version_4, t0.os_version AS os_version_5, t0.locale AS locale_6, t0.external_user_id AS external_user_id_7, t0.app AS app_8, t0.apns_env AS apns_env_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.last_seen_at AS last_seen_at_13 FROM push_devices t0 WHERE t0.token = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.error AS error_2, p0_.created_at AS created_at_3, p0_.delivered_at AS delivered_at_4, p0_.seen_at AS seen_at_5, p0_.notification_id AS notification_id_6, p0_.device_id AS device_id_7 FROM push_deliveries p0_ WHERE p0_.device_id = ? AND p0_.status = ? ORDER BY p0_.created_at DESC LIMIT 100
SELECT t0.id AS id_1, t0.token AS token_2, t0.platform AS platform_3, t0.app_version AS app_version_4, t0.os_version AS os_version_5, t0.locale AS locale_6, t0.external_user_id AS external_user_id_7, t0.app AS app_8, t0.apns_env AS apns_env_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.last_seen_at AS last_seen_at_13 FROM push_devices t0 WHERE t0.token = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.error AS error_2, p0_.created_at AS created_at_3, p0_.delivered_at AS delivered_at_4, p0_.seen_at AS seen_at_5, p0_.notification_id AS notification_id_6, p0_.device_id AS device_id_7 FROM push_deliveries p0_ WHERE p0_.device_id = ? AND p0_.status = ? ORDER BY p0_.created_at DESC LIMIT 100
SELECT t0.id AS id_1, t0.token AS token_2, t0.platform AS platform_3, t0.app_version AS app_version_4, t0.os_version AS os_version_5, t0.locale AS locale_6, t0.external_user_id AS external_user_id_7, t0.app AS app_8, t0.apns_env AS apns_env_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.last_seen_at AS last_seen_at_13 FROM push_devices t0 WHERE t0.token = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.error AS error_2, p0_.created_at AS created_at_3, p0_.delivered_at AS delivered_at_4, p0_.seen_at AS seen_at_5, p0_.notification_id AS notification_id_6, p0_.device_id AS device_id_7 FROM push_deliveries p0_ WHERE p0_.device_id = ? AND p0_.status = ? ORDER BY p0_.created_at DESC LIMIT 100
SELECT t0.id AS id_1, t0.token AS token_2, t0.platform AS platform_3, t0.app_version AS app_version_4, t0.os_version AS os_version_5, t0.locale AS locale_6, t0.external_user_id AS external_user_id_7, t0.app AS app_8, t0.apns_env AS apns_env_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.last_seen_at AS last_seen_at_13 FROM push_devices t0 WHERE t0.token = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.error AS error_2, p0_.created_at AS created_at_3, p0_.delivered_at AS delivered_at_4, p0_.seen_at AS seen_at_5, p0_.notification_id AS notification_id_6, p0_.device_id AS device_id_7 FROM push_deliveries p0_ WHERE p0_.device_id = ? AND p0_.status = ? ORDER BY p0_.created_at DESC LIMIT 100
SELECT t0.id AS id_1, t0.token AS token_2, t0.platform AS platform_3, t0.app_version AS app_version_4, t0.os_version AS os_version_5, t0.locale AS locale_6, t0.external_user_id AS external_user_id_7, t0.app AS app_8, t0.apns_env AS apns_env_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.last_seen_at AS last_seen_at_13 FROM push_devices t0 WHERE t0.token = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.error AS error_2, p0_.created_at AS created_at_3, p0_.delivered_at AS delivered_at_4, p0_.seen_at AS seen_at_5, p0_.notification_id AS notification_id_6, p0_.device_id AS device_id_7 FROM push_deliveries p0_ WHERE p0_.device_id = ? AND p0_.status = ? ORDER BY p0_.created_at DESC LIMIT 100
SELECT t0.id AS id_1, t0.token AS token_2, t0.platform AS platform_3, t0.app_version AS app_version_4, t0.os_version AS os_version_5, t0.locale AS locale_6, t0.external_user_id AS external_user_id_7, t0.app AS app_8, t0.apns_env AS apns_env_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.last_seen_at AS last_seen_at_13 FROM push_devices t0 WHERE t0.token = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.error AS error_2, p0_.created_at AS created_at_3, p0_.delivered_at AS delivered_at_4, p0_.seen_at AS seen_at_5, p0_.notification_id AS notification_id_6, p0_.device_id AS device_id_7 FROM push_deliveries p0_ WHERE p0_.device_id = ? AND p0_.status = ? ORDER BY p0_.created_at DESC LIMIT 100
SELECT t0.id AS id_1, t0.token AS token_2, t0.platform AS platform_3, t0.app_version AS app_version_4, t0.os_version AS os_version_5, t0.locale AS locale_6, t0.external_user_id AS external_user_id_7, t0.app AS app_8, t0.apns_env AS apns_env_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.last_seen_at AS last_seen_at_13 FROM push_devices t0 WHERE t0.token = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.error AS error_2, p0_.created_at AS created_at_3, p0_.delivered_at AS delivered_at_4, p0_.seen_at AS seen_at_5, p0_.notification_id AS notification_id_6, p0_.device_id AS device_id_7 FROM push_deliveries p0_ WHERE p0_.device_id = ? AND p0_.status = ? ORDER BY p0_.created_at DESC LIMIT 100
SELECT t0.id AS id_1, t0.token AS token_2, t0.platform AS platform_3, t0.app_version AS app_version_4, t0.os_version AS os_version_5, t0.locale AS locale_6, t0.external_user_id AS external_user_id_7, t0.app AS app_8, t0.apns_env AS apns_env_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.last_seen_at AS last_seen_at_13 FROM push_devices t0 WHERE t0.token = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.error AS error_2, p0_.created_at AS created_at_3, p0_.delivered_at AS delivered_at_4, p0_.seen_at AS seen_at_5, p0_.notification_id AS notification_id_6, p0_.device_id AS device_id_7 FROM push_deliveries p0_ WHERE p0_.device_id = ? AND p0_.status = ? ORDER BY p0_.created_at DESC LIMIT 100
SELECT t0.id AS id_1, t0.token AS token_2, t0.platform AS platform_3, t0.app_version AS app_version_4, t0.os_version AS os_version_5, t0.locale AS locale_6, t0.external_user_id AS external_user_id_7, t0.app AS app_8, t0.apns_env AS apns_env_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.last_seen_at AS last_seen_at_13 FROM push_devices t0 WHERE t0.token = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.error AS error_2, p0_.created_at AS created_at_3, p0_.delivered_at AS delivered_at_4, p0_.seen_at AS seen_at_5, p0_.notification_id AS notification_id_6, p0_.device_id AS device_id_7 FROM push_deliveries p0_ WHERE p0_.device_id = ? AND p0_.status = ? ORDER BY p0_.created_at DESC LIMIT 100
SELECT t0.id AS id_1, t0.token AS token_2, t0.platform AS platform_3, t0.app_version AS app_version_4, t0.os_version AS os_version_5, t0.locale AS locale_6, t0.external_user_id AS external_user_id_7, t0.app AS app_8, t0.apns_env AS apns_env_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.last_seen_at AS last_seen_at_13 FROM push_devices t0 WHERE t0.token = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.error AS error_2, p0_.created_at AS created_at_3, p0_.delivered_at AS delivered_at_4, p0_.seen_at AS seen_at_5, p0_.notification_id AS notification_id_6, p0_.device_id AS device_id_7 FROM push_deliveries p0_ WHERE p0_.device_id = ? AND p0_.status = ? ORDER BY p0_.created_at DESC LIMIT 100
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\PushDevice	1
Entities Mapping

Class	Mapping errors
App\Entity\PushDevice	No errors.
App\Entity\PushDelivery	No errors.
App\Entity\PushNotification	No errors.
Symfony Profiler

POST https://pushapp.webground.bg/api/notifications/poll

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping
