Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

0.74 ms Query time

0 Invalid entities

Queries

Group similar statements

company_group connection

#▲	Time	Info
1	0.37 ms	SELECT COUNT() FROM entity_notification WHERE user_id = ? AND company_id = ? AND seen_flag = 0 AND (expire_ts = 0 OR expire_ts > ?) Parameters: [`52 0 1785851047`] View formatted query View runnable query Explain query SELECT COUNT() FROM entity_notification WHERE user_id = ? AND company_id = ? AND seen_flag = 0 AND ( expire_ts = 0 OR expire_ts > ? ) SELECT COUNT(*) FROM entity_notification WHERE user_id = 52 AND company_id = 0 AND seen_flag = 0 AND (expire_ts = 0 OR expire_ts > 1785851047);

#▲

Time

Info

0.37 ms

SELECT COUNT(*) FROM entity_notification
                 WHERE user_id = ? AND company_id = ? AND seen_flag = 0
                   AND (expire_ts = 0 OR expire_ts > ?)

Parameters:

View formatted query View runnable query Explain query

SELECT
  COUNT(*)
FROM
  entity_notification
WHERE
  user_id = ?
  AND company_id = ?
  AND seen_flag = 0
  AND (
    expire_ts = 0
    OR expire_ts > ?
  )

SELECT COUNT(*) FROM entity_notification
                 WHERE user_id = 52 AND company_id = 0 AND seen_flag = 0
                   AND (expire_ts = 0 OR expire_ts > 1785851047);

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