Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

1.15 ms Query time

0 Invalid entities

Queries

Group similar statements

company_group connection

#▲	Time	Info
1	0.54 ms	SELECT id, title, body, target_route, target_url, notification_ts, seen_flag FROM entity_notification WHERE user_id = ? ORDER BY notification_ts DESC, id DESC LIMIT 15 Parameters: [`6916`] View formatted query View runnable query Explain query SELECT id, title, body, target_route, target_url, notification_ts, seen_flag FROM entity_notification WHERE user_id = ? ORDER BY notification_ts DESC, id DESC LIMIT 15 SELECT id, title, body, target_route, target_url, notification_ts, seen_flag FROM entity_notification WHERE user_id = 6916 ORDER BY notification_ts DESC, id DESC LIMIT 15;
2	0.24 ms	SELECT COUNT() FROM entity_notification WHERE user_id = ? AND seen_flag = 0 Parameters: [`6916`] View formatted query View runnable query Explain query SELECT COUNT() FROM entity_notification WHERE user_id = ? AND seen_flag = 0 SELECT COUNT(*) FROM entity_notification WHERE user_id = 6916 AND seen_flag = 0;

#▲

Time

Info

0.54 ms

SELECT id, title, body, target_route, target_url, notification_ts, seen_flag
                 FROM entity_notification
                 WHERE user_id = ?
                 ORDER BY notification_ts DESC, id DESC
                 LIMIT 15

Parameters:

[
  6916
]

View formatted query View runnable query Explain query

SELECT
  id,
  title,
  body,
  target_route,
  target_url,
  notification_ts,
  seen_flag
FROM
  entity_notification
WHERE
  user_id = ?
ORDER BY
  notification_ts DESC,
  id DESC
LIMIT
  15

SELECT id, title, body, target_route, target_url, notification_ts, seen_flag
                 FROM entity_notification
                 WHERE user_id = 6916
                 ORDER BY notification_ts DESC, id DESC
                 LIMIT 15;

0.24 ms

SELECT COUNT(*) FROM entity_notification WHERE user_id = ? AND seen_flag = 0

Parameters:

[
  6916
]

View formatted query View runnable query Explain query

SELECT
  COUNT(*)
FROM
  entity_notification
WHERE
  user_id = ?
  AND seen_flag = 0

SELECT COUNT(*) FROM entity_notification WHERE user_id = 6916 AND seen_flag = 0;

default connection

#▲	Time	Info
1	0.37 ms	SELECT data FROM acc_setting WHERE name = 'cors_extra_origins' ORDER BY id DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT data FROM acc_setting WHERE name = 'cors_extra_origins' ORDER BY id DESC LIMIT 1 SELECT data FROM acc_setting WHERE name = 'cors_extra_origins' ORDER BY id DESC LIMIT 1;

#▲

Time

Info

0.37 ms

SELECT data FROM acc_setting WHERE name = 'cors_extra_origins' ORDER BY id DESC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  data
FROM
  acc_setting
WHERE
  name = 'cors_extra_origins'
ORDER BY
  id DESC
LIMIT
  1

SELECT data FROM acc_setting WHERE name = 'cors_extra_origins' ORDER BY id DESC LIMIT 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
company_group	doctrine.dbal.company_group_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
company_group	doctrine.orm.company_group_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

No loaded entities.

company_group entity manager

No loaded entities.

Symfony Profiler

https://ourhoneybee.eu/api/notifications/recent

Configuration Settings

Theme

Page Width

Query Metrics

Queries

company_group connection

default connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

default entity manager

company_group entity manager