Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

6 Database Queries

5 Different statements

4.70 ms Query time

0 Invalid entities

#▲	Time	Info
1	2.24 ms	SELECT TIME_TO_SEC(TIMEDIFF( expiryTime, now() )) as remainingTime FROM tbl_incoming_actions WHERE ipAddress=?; Parameters: [`"216.73.216.40"`] 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.40';;
2	1.17 ms	UPDATE tbl_user_sessions SET logoutDT=NOW() WHERE sessionID = ?; Parameters: [`"ckbh5gv9q9im9gnsl7n3rgnvlr"`] 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 = 'ckbh5gv9q9im9gnsl7n3rgnvlr';;

#▲

Time

Info

2.24 ms

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

Parameters:

[
  "216.73.216.40"
]

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.40';;

1.17 ms

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

Parameters:

[
  "ckbh5gv9q9im9gnsl7n3rgnvlr"
]

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 = 'ckbh5gv9q9im9gnsl7n3rgnvlr';;

#▲	Time	Info
1	0.33 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.29 ms	SELECT * FROM tbl_organizations WHERE orgDomain=?; Parameters: [`"44.224.79.56"`] View formatted query View runnable query Explain query SELECT * FROM tbl_organizations WHERE orgDomain = ?; SELECT * FROM tbl_organizations WHERE orgDomain='44.224.79.56';;
3	0.31 ms	SELECT * FROM tbl_organizations WHERE orgID=? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM tbl_organizations WHERE orgID = ? SELECT * FROM tbl_organizations WHERE orgID=1;
4	0.36 ms	SELECT * FROM tbl_organizations WHERE orgDomain=?; Parameters: [`"44.224.79.56"`] View formatted query View runnable query Explain query SELECT * FROM tbl_organizations WHERE orgDomain = ?; SELECT * FROM tbl_organizations WHERE orgDomain='44.224.79.56';;

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

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

No loaded entities.