Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

1.25 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	1.25 ms	SELECT i0_.id AS id_0, i0_.ipAddress AS ipAddress_1, i0_.username AS username_2, i0_.failedCount AS failedCount_3, i0_.otpFailedCount AS otpFailedCount_4, i0_.firstAttempt AS firstAttempt_5, i0_.lastAttempt AS lastAttempt_6, i0_.successfulLoginTimeStamp AS successfulLoginTimeStamp_7 FROM IPFailedLogins i0_ WHERE i0_.ipAddress = ? ORDER BY i0_.lastAttempt DESC LIMIT 1 Parameters: [`"172.19.0.1"`] View formatted query View runnable query Explain query SELECT i0_.id AS id_0, i0_.ipAddress AS ipAddress_1, i0_.username AS username_2, i0_.failedCount AS failedCount_3, i0_.otpFailedCount AS otpFailedCount_4, i0_.firstAttempt AS firstAttempt_5, i0_.lastAttempt AS lastAttempt_6, i0_.successfulLoginTimeStamp AS successfulLoginTimeStamp_7 FROM IPFailedLogins i0_ WHERE i0_.ipAddress = ? ORDER BY i0_.lastAttempt DESC LIMIT 1 SELECT i0_.id AS id_0, i0_.ipAddress AS ipAddress_1, i0_.username AS username_2, i0_.failedCount AS failedCount_3, i0_.otpFailedCount AS otpFailedCount_4, i0_.firstAttempt AS firstAttempt_5, i0_.lastAttempt AS lastAttempt_6, i0_.successfulLoginTimeStamp AS successfulLoginTimeStamp_7 FROM IPFailedLogins i0_ WHERE i0_.ipAddress = '172.19.0.1' ORDER BY i0_.lastAttempt DESC LIMIT 1;

#▲

Time

Info

1.25 ms

SELECT i0_.id AS id_0, i0_.ipAddress AS ipAddress_1, i0_.username AS username_2, i0_.failedCount AS failedCount_3, i0_.otpFailedCount AS otpFailedCount_4, i0_.firstAttempt AS firstAttempt_5, i0_.lastAttempt AS lastAttempt_6, i0_.successfulLoginTimeStamp AS successfulLoginTimeStamp_7 FROM IPFailedLogins i0_ WHERE i0_.ipAddress = ? ORDER BY i0_.lastAttempt DESC LIMIT 1

Parameters:

[
  "172.19.0.1"
]

View formatted query View runnable query Explain query

SELECT
  i0_.id AS id_0,
  i0_.ipAddress AS ipAddress_1,
  i0_.username AS username_2,
  i0_.failedCount AS failedCount_3,
  i0_.otpFailedCount AS otpFailedCount_4,
  i0_.firstAttempt AS firstAttempt_5,
  i0_.lastAttempt AS lastAttempt_6,
  i0_.successfulLoginTimeStamp AS successfulLoginTimeStamp_7
FROM
  IPFailedLogins i0_
WHERE
  i0_.ipAddress = ?
ORDER BY
  i0_.lastAttempt DESC
LIMIT
  1

SELECT i0_.id AS id_0, i0_.ipAddress AS ipAddress_1, i0_.username AS username_2, i0_.failedCount AS failedCount_3, i0_.otpFailedCount AS otpFailedCount_4, i0_.firstAttempt AS firstAttempt_5, i0_.lastAttempt AS lastAttempt_6, i0_.successfulLoginTimeStamp AS successfulLoginTimeStamp_7 FROM IPFailedLogins i0_ WHERE i0_.ipAddress = '172.19.0.1' ORDER BY i0_.lastAttempt DESC LIMIT 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
MedBrief\MSR\Entity\Project	No errors.
MedBrief\MSR\Entity\Account	No errors.
MedBrief\MSR\Entity\ExpertAgency	No errors.
MedBrief\MSR\Entity\Document	The field MedBrief\MSR\Entity\Document#sortingSessionStack is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity MedBrief\MSR\Entity\SortingSessionStack#document does not contain the required 'inversedBy="sortingSessionStack"' attribute.
MedBrief\MSR\Entity\Invoice	No errors.
MedBrief\MSR\Entity\UserFailedLogins	No errors.
MedBrief\MSR\Entity\IPFailedLogins	No errors.
MedBrief\MSR\Entity\AccountAuthSettings	No errors.
MedBrief\MSR\Entity\User	No errors.

Symfony Profiler

https://zac-dev.medbrief.net/login

Configuration Settings

Theme