Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

5 Database Queries

4 Different statements

9.79 ms Query time

0 Invalid entities

Queries

Group similar statements

audit connection

#▲	Time	Info
1	6.14 ms	SELECT TIME_TO_SEC(TIMEDIFF( expiryTime, now() )) as remainingTime FROM tbl_incoming_actions WHERE ipAddress=?; Parameters: [`"216.73.216.171"`] View formatted query View runnable query Explain query SELECT TIME_TO_SEC( TIMEDIFF( expiryTime, now() ) ) as remainingTime FROM tbl_incoming_actions WHERE ipAddress = ?; SELECT TIME_TO_SEC(TIMEDIFF( expiryTime, now() )) as remainingTime FROM tbl_incoming_actions WHERE ipAddress='216.73.216.171';;
2	2.28 ms	UPDATE tbl_user_sessions SET logoutDT=NOW() WHERE sessionID = ?; Parameters: [`"fjabf26ld3gfj5eqd45kpf0eo9"`] View formatted query View runnable query Explain query UPDATE tbl_user_sessions SET logoutDT = NOW() WHERE sessionID = ?; UPDATE tbl_user_sessions SET logoutDT=NOW() WHERE sessionID = 'fjabf26ld3gfj5eqd45kpf0eo9';;

#▲

Time

Info

6.14 ms

SELECT TIME_TO_SEC(TIMEDIFF( expiryTime, now() )) as remainingTime FROM  tbl_incoming_actions WHERE ipAddress=?;

Parameters:

[
  "216.73.216.171"
]

View formatted query View runnable query Explain query

SELECT
  TIME_TO_SEC(
    TIMEDIFF(
      expiryTime,
      now()
    )
  ) as remainingTime
FROM
  tbl_incoming_actions
WHERE
  ipAddress = ?;

SELECT TIME_TO_SEC(TIMEDIFF( expiryTime, now() )) as remainingTime FROM  tbl_incoming_actions WHERE ipAddress='216.73.216.171';;

2.28 ms

UPDATE tbl_user_sessions SET logoutDT=NOW() WHERE sessionID = ?;

Parameters:

[
  "fjabf26ld3gfj5eqd45kpf0eo9"
]

View formatted query View runnable query Explain query

UPDATE
  tbl_user_sessions
SET
  logoutDT = NOW()
WHERE
  sessionID = ?;

UPDATE tbl_user_sessions SET logoutDT=NOW() WHERE sessionID = 'fjabf26ld3gfj5eqd45kpf0eo9';;

core connection

#▲	Time	Info
1	0.52 ms	SELECT * FROM tbl_bundle WHERE bundleDescription LIKE ? ORDER BY orderby ASC Parameters: [`"%showModule%"`] View formatted query View runnable query Explain query SELECT * FROM tbl_bundle WHERE bundleDescription LIKE ? ORDER BY orderby ASC SELECT * FROM tbl_bundle WHERE bundleDescription LIKE '%showModule%' ORDER BY orderby ASC;
2	0.39 ms	SELECT * FROM tbl_organizations WHERE orgDomain=?; Parameters: [`"stage.centralstage.io"`] View formatted query View runnable query Explain query SELECT * FROM tbl_organizations WHERE orgDomain = ?; SELECT * FROM tbl_organizations WHERE orgDomain='stage.centralstage.io';;
3	0.46 ms	SELECT * FROM tbl_organizations WHERE orgDomain=?; Parameters: [`"stage.centralstage.io"`] View formatted query View runnable query Explain query SELECT * FROM tbl_organizations WHERE orgDomain = ?; SELECT * FROM tbl_organizations WHERE orgDomain='stage.centralstage.io';;

#▲

Time

Info

0.52 ms

SELECT * FROM tbl_bundle WHERE bundleDescription LIKE ? ORDER BY orderby ASC

Parameters:

[
  "%showModule%"
]

View formatted query View runnable query Explain query

SELECT
  *
FROM
  tbl_bundle
WHERE
  bundleDescription LIKE ?
ORDER BY
  orderby ASC

SELECT * FROM tbl_bundle WHERE bundleDescription LIKE '%showModule%' ORDER BY orderby ASC;

0.39 ms

SELECT * FROM tbl_organizations WHERE orgDomain=?;

Parameters:

[
  "stage.centralstage.io"
]

View formatted query View runnable query Explain query

SELECT
  *
FROM
  tbl_organizations
WHERE
  orgDomain = ?;

SELECT * FROM tbl_organizations WHERE orgDomain='stage.centralstage.io';;

0.46 ms

SELECT * FROM tbl_organizations WHERE orgDomain=?;

Parameters:

[
  "stage.centralstage.io"
]

View formatted query View runnable query Explain query

SELECT
  *
FROM
  tbl_organizations
WHERE
  orgDomain = ?;

SELECT * FROM tbl_organizations WHERE orgDomain='stage.centralstage.io';;

Database Connections

Name	Service
core	doctrine.dbal.core_connection
data	doctrine.dbal.data_connection
audit	doctrine.dbal.audit_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No loaded entities.

Symfony Profiler

https://stage.centralstage.io/login

Configuration Settings

Theme

Page Width

Query Metrics

Queries

audit connection

core connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping