Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

6 Database Queries

5 Different statements

6.66 ms Query time

0 Invalid entities

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

#▲

Time

Info

3.19 ms

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

Parameters:

[
  "205.210.31.23"
]

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

1.80 ms

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

Parameters:

[
  "c92cjmjnjjgq6of8q8t4d0npv3"
]

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

#▲	Time	Info
1	0.49 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.40 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.46 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.