Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

5 Database Queries

4 Different statements

4.19 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

audit connection

Time▼	Count	Info
1.94 ms (46.29%)	1	SELECT TIME_TO_SEC(TIMEDIFF( expiryTime, now() )) as remainingTime FROM tbl_incoming_actions WHERE ipAddress=?; Parameters: [`"54.163.13.199"`] 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='54.163.13.199';;
1.22 ms (29.06%)	1	UPDATE tbl_user_sessions SET logoutDT=NOW() WHERE sessionID = ?; Parameters: [`"hejulm4cah318ljs0bo7hvsgc8"`] 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 = 'hejulm4cah318ljs0bo7hvsgc8';;

Time▼

Count

Info

1.94 ms
(46.29%)

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

Parameters:

[
  "54.163.13.199"
]

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

1.22 ms
(29.06%)

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

Parameters:

[
  "hejulm4cah318ljs0bo7hvsgc8"
]

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

core connection

Time▼	Count	Info
0.68 ms (16.31%)	2	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';;
0.35 ms (8.34%)	1	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;

Time▼

Count

Info

0.68 ms
(16.31%)

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

0.35 ms
(8.34%)

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;

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

http://44.224.79.56/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

audit connection

core connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping