Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

0.74 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

company_group connection

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

Count

Info

0.37 ms
(49.86%)

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

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