Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

1.15 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

company_group connection

Time▼	Count	Info
0.54 ms (47.39%)	1	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 (20.76%)	1	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▼

Count

Info

0.54 ms
(47.39%)

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
(20.76%)

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▼	Count	Info
0.37 ms (31.85%)	1	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▼

Count

Info

0.37 ms
(31.85%)

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

Grouped Statements

company_group connection

default connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

default entity manager

company_group entity manager