Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

425.70 ms Query time

6 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
215.68 ms (0.00%)	1	SELECT DISTINCT c0_.id AS id_0, c0_.id AS id_1 FROM customer c0_ WHERE (LOWER(c0_.email) LIKE ? OR LOWER(c0_.email) IN (?) OR LOWER(c0_.username) LIKE ? OR LOWER(c0_.username) IN (?) OR LOWER(c0_.plain_password) LIKE ? OR LOWER(c0_.plain_password) IN (?) OR LOWER(c0_.name) LIKE ? OR LOWER(c0_.name) IN (?) OR LOWER(c0_.surname) LIKE ? OR LOWER(c0_.surname) IN (?) OR LOWER(c0_.address) LIKE ? OR LOWER(c0_.address) IN (?) OR LOWER(c0_.celular) LIKE ? OR LOWER(c0_.celular) IN (?) OR LOWER(c0_.image) LIKE ? OR LOWER(c0_.image) IN (?) OR LOWER(c0_.type_account) LIKE ? OR LOWER(c0_.type_account) IN (?) OR LOWER(c0_.purchase) LIKE ? OR LOWER(c0_.purchase) IN (?) OR LOWER(c0_.purchase_platform) LIKE ? OR LOWER(c0_.purchase_platform) IN (?) OR LOWER(c0_.membership_id) LIKE ? OR LOWER(c0_.membership_id) IN (?) OR LOWER(c0_.phone) LIKE ? OR LOWER(c0_.phone) IN (?) OR LOWER(c0_.google_auth_code) LIKE ? OR LOWER(c0_.google_auth_code) IN (?)) AND (c0_.deleted_at IS NOT NULL AND c0_.is_deleted IS NULL) ORDER BY c0_.id DESC LIMIT 100 Parameters: [`"%electrici%" [ "electrici" ] "%electrici%" [ "electrici" ] "%electrici%" [ "electrici" ] "%electrici%" [ "electrici" ] "%electrici%" [ "electrici" ] "%electrici%" [ "electrici" ] "%electrici%" [ "electrici" ] "%electrici%" [ "electrici" ] "%electrici%" [ "electrici" ] "%electrici%" [ "electrici" ] "%electrici%" [ "electrici" ] "%electrici%" [ "electrici" ] "%electrici%" [ "electrici" ] "%electrici%" [ "electrici" ]`] View formatted query View runnable query Explain query SELECT DISTINCT c0_.id AS id_0, c0_.id AS id_1 FROM customer c0_ WHERE ( LOWER(c0_.email) LIKE ? OR LOWER(c0_.email) IN (?) OR LOWER(c0_.username) LIKE ? OR LOWER(c0_.username) IN (?) OR LOWER(c0_.plain_password) LIKE ? OR LOWER(c0_.plain_password) IN (?) OR LOWER(c0_.name) LIKE ? OR LOWER(c0_.name) IN (?) OR LOWER(c0_.surname) LIKE ? OR LOWER(c0_.surname) IN (?) OR LOWER(c0_.address) LIKE ? OR LOWER(c0_.address) IN (?) OR LOWER(c0_.celular) LIKE ? OR LOWER(c0_.celular) IN (?) OR LOWER(c0_.image) LIKE ? OR LOWER(c0_.image) IN (?) OR LOWER(c0_.type_account) LIKE ? OR LOWER(c0_.type_account) IN (?) OR LOWER(c0_.purchase) LIKE ? OR LOWER(c0_.purchase) IN (?) OR LOWER(c0_.purchase_platform) LIKE ? OR LOWER(c0_.purchase_platform) IN (?) OR LOWER(c0_.membership_id) LIKE ? OR LOWER(c0_.membership_id) IN (?) OR LOWER(c0_.phone) LIKE ? OR LOWER(c0_.phone) IN (?) OR LOWER(c0_.google_auth_code) LIKE ? OR LOWER(c0_.google_auth_code) IN (?) ) AND ( c0_.deleted_at IS NOT NULL AND c0_.is_deleted IS NULL ) ORDER BY c0_.id DESC LIMIT 100 SELECT DISTINCT c0_.id AS id_0, c0_.id AS id_1 FROM customer c0_ WHERE (LOWER(c0_.email) LIKE '%electrici%' OR LOWER(c0_.email) IN ('electrici') OR LOWER(c0_.username) LIKE '%electrici%' OR LOWER(c0_.username) IN ('electrici') OR LOWER(c0_.plain_password) LIKE '%electrici%' OR LOWER(c0_.plain_password) IN ('electrici') OR LOWER(c0_.name) LIKE '%electrici%' OR LOWER(c0_.name) IN ('electrici') OR LOWER(c0_.surname) LIKE '%electrici%' OR LOWER(c0_.surname) IN ('electrici') OR LOWER(c0_.address) LIKE '%electrici%' OR LOWER(c0_.address) IN ('electrici') OR LOWER(c0_.celular) LIKE '%electrici%' OR LOWER(c0_.celular) IN ('electrici') OR LOWER(c0_.image) LIKE '%electrici%' OR LOWER(c0_.image) IN ('electrici') OR LOWER(c0_.type_account) LIKE '%electrici%' OR LOWER(c0_.type_account) IN ('electrici') OR LOWER(c0_.purchase) LIKE '%electrici%' OR LOWER(c0_.purchase) IN ('electrici') OR LOWER(c0_.purchase_platform) LIKE '%electrici%' OR LOWER(c0_.purchase_platform) IN ('electrici') OR LOWER(c0_.membership_id) LIKE '%electrici%' OR LOWER(c0_.membership_id) IN ('electrici') OR LOWER(c0_.phone) LIKE '%electrici%' OR LOWER(c0_.phone) IN ('electrici') OR LOWER(c0_.google_auth_code) LIKE '%electrici%' OR LOWER(c0_.google_auth_code) IN ('electrici')) AND (c0_.deleted_at IS NOT NULL AND c0_.is_deleted IS NULL) ORDER BY c0_.id DESC LIMIT 100;
205.35 ms (0.00%)	1	SELECT COUNT(c0_.id) AS sclr_0 FROM customer c0_ WHERE (LOWER(c0_.email) LIKE ? OR LOWER(c0_.email) IN (?) OR LOWER(c0_.username) LIKE ? OR LOWER(c0_.username) IN (?) OR LOWER(c0_.plain_password) LIKE ? OR LOWER(c0_.plain_password) IN (?) OR LOWER(c0_.name) LIKE ? OR LOWER(c0_.name) IN (?) OR LOWER(c0_.surname) LIKE ? OR LOWER(c0_.surname) IN (?) OR LOWER(c0_.address) LIKE ? OR LOWER(c0_.address) IN (?) OR LOWER(c0_.celular) LIKE ? OR LOWER(c0_.celular) IN (?) OR LOWER(c0_.image) LIKE ? OR LOWER(c0_.image) IN (?) OR LOWER(c0_.type_account) LIKE ? OR LOWER(c0_.type_account) IN (?) OR LOWER(c0_.purchase) LIKE ? OR LOWER(c0_.purchase) IN (?) OR LOWER(c0_.purchase_platform) LIKE ? OR LOWER(c0_.purchase_platform) IN (?) OR LOWER(c0_.membership_id) LIKE ? OR LOWER(c0_.membership_id) IN (?) OR LOWER(c0_.phone) LIKE ? OR LOWER(c0_.phone) IN (?) OR LOWER(c0_.google_auth_code) LIKE ? OR LOWER(c0_.google_auth_code) IN (?)) AND (c0_.deleted_at IS NOT NULL AND c0_.is_deleted IS NULL) Parameters: [`"%electrici%" [ "electrici" ] "%electrici%" [ "electrici" ] "%electrici%" [ "electrici" ] "%electrici%" [ "electrici" ] "%electrici%" [ "electrici" ] "%electrici%" [ "electrici" ] "%electrici%" [ "electrici" ] "%electrici%" [ "electrici" ] "%electrici%" [ "electrici" ] "%electrici%" [ "electrici" ] "%electrici%" [ "electrici" ] "%electrici%" [ "electrici" ] "%electrici%" [ "electrici" ] "%electrici%" [ "electrici" ]`] View formatted query View runnable query Explain query SELECT COUNT(c0_.id) AS sclr_0 FROM customer c0_ WHERE ( LOWER(c0_.email) LIKE ? OR LOWER(c0_.email) IN (?) OR LOWER(c0_.username) LIKE ? OR LOWER(c0_.username) IN (?) OR LOWER(c0_.plain_password) LIKE ? OR LOWER(c0_.plain_password) IN (?) OR LOWER(c0_.name) LIKE ? OR LOWER(c0_.name) IN (?) OR LOWER(c0_.surname) LIKE ? OR LOWER(c0_.surname) IN (?) OR LOWER(c0_.address) LIKE ? OR LOWER(c0_.address) IN (?) OR LOWER(c0_.celular) LIKE ? OR LOWER(c0_.celular) IN (?) OR LOWER(c0_.image) LIKE ? OR LOWER(c0_.image) IN (?) OR LOWER(c0_.type_account) LIKE ? OR LOWER(c0_.type_account) IN (?) OR LOWER(c0_.purchase) LIKE ? OR LOWER(c0_.purchase) IN (?) OR LOWER(c0_.purchase_platform) LIKE ? OR LOWER(c0_.purchase_platform) IN (?) OR LOWER(c0_.membership_id) LIKE ? OR LOWER(c0_.membership_id) IN (?) OR LOWER(c0_.phone) LIKE ? OR LOWER(c0_.phone) IN (?) OR LOWER(c0_.google_auth_code) LIKE ? OR LOWER(c0_.google_auth_code) IN (?) ) AND ( c0_.deleted_at IS NOT NULL AND c0_.is_deleted IS NULL ) SELECT COUNT(c0_.id) AS sclr_0 FROM customer c0_ WHERE (LOWER(c0_.email) LIKE '%electrici%' OR LOWER(c0_.email) IN ('electrici') OR LOWER(c0_.username) LIKE '%electrici%' OR LOWER(c0_.username) IN ('electrici') OR LOWER(c0_.plain_password) LIKE '%electrici%' OR LOWER(c0_.plain_password) IN ('electrici') OR LOWER(c0_.name) LIKE '%electrici%' OR LOWER(c0_.name) IN ('electrici') OR LOWER(c0_.surname) LIKE '%electrici%' OR LOWER(c0_.surname) IN ('electrici') OR LOWER(c0_.address) LIKE '%electrici%' OR LOWER(c0_.address) IN ('electrici') OR LOWER(c0_.celular) LIKE '%electrici%' OR LOWER(c0_.celular) IN ('electrici') OR LOWER(c0_.image) LIKE '%electrici%' OR LOWER(c0_.image) IN ('electrici') OR LOWER(c0_.type_account) LIKE '%electrici%' OR LOWER(c0_.type_account) IN ('electrici') OR LOWER(c0_.purchase) LIKE '%electrici%' OR LOWER(c0_.purchase) IN ('electrici') OR LOWER(c0_.purchase_platform) LIKE '%electrici%' OR LOWER(c0_.purchase_platform) IN ('electrici') OR LOWER(c0_.membership_id) LIKE '%electrici%' OR LOWER(c0_.membership_id) IN ('electrici') OR LOWER(c0_.phone) LIKE '%electrici%' OR LOWER(c0_.phone) IN ('electrici') OR LOWER(c0_.google_auth_code) LIKE '%electrici%' OR LOWER(c0_.google_auth_code) IN ('electrici')) AND (c0_.deleted_at IS NOT NULL AND c0_.is_deleted IS NULL);
4.66 ms (0.00%)	1	SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.enabled AS enabled_5, t0.name AS name_6, t0.celular AS celular_7 FROM user t0 WHERE t0.id = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.enabled AS enabled_5, t0.name AS name_6, t0.celular AS celular_7 FROM user t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.enabled AS enabled_5, t0.name AS name_6, t0.celular AS celular_7 FROM user t0 WHERE t0.id = 3;

Time▼

Count

Info

215.68 ms
(0.00%)

SELECT DISTINCT c0_.id AS id_0, c0_.id AS id_1 FROM customer c0_ WHERE (LOWER(c0_.email) LIKE ? OR LOWER(c0_.email) IN (?) OR LOWER(c0_.username) LIKE ? OR LOWER(c0_.username) IN (?) OR LOWER(c0_.plain_password) LIKE ? OR LOWER(c0_.plain_password) IN (?) OR LOWER(c0_.name) LIKE ? OR LOWER(c0_.name) IN (?) OR LOWER(c0_.surname) LIKE ? OR LOWER(c0_.surname) IN (?) OR LOWER(c0_.address) LIKE ? OR LOWER(c0_.address) IN (?) OR LOWER(c0_.celular) LIKE ? OR LOWER(c0_.celular) IN (?) OR LOWER(c0_.image) LIKE ? OR LOWER(c0_.image) IN (?) OR LOWER(c0_.type_account) LIKE ? OR LOWER(c0_.type_account) IN (?) OR LOWER(c0_.purchase) LIKE ? OR LOWER(c0_.purchase) IN (?) OR LOWER(c0_.purchase_platform) LIKE ? OR LOWER(c0_.purchase_platform) IN (?) OR LOWER(c0_.membership_id) LIKE ? OR LOWER(c0_.membership_id) IN (?) OR LOWER(c0_.phone) LIKE ? OR LOWER(c0_.phone) IN (?) OR LOWER(c0_.google_auth_code) LIKE ? OR LOWER(c0_.google_auth_code) IN (?)) AND (c0_.deleted_at IS NOT NULL AND c0_.is_deleted IS NULL) ORDER BY c0_.id DESC LIMIT 100

Parameters:

[
  "%electrici%"
  [
    "electrici"
  ]
  "%electrici%"
  [
    "electrici"
  ]
  "%electrici%"
  [
    "electrici"
  ]
  "%electrici%"
  [
    "electrici"
  ]
  "%electrici%"
  [
    "electrici"
  ]
  "%electrici%"
  [
    "electrici"
  ]
  "%electrici%"
  [
    "electrici"
  ]
  "%electrici%"
  [
    "electrici"
  ]
  "%electrici%"
  [
    "electrici"
  ]
  "%electrici%"
  [
    "electrici"
  ]
  "%electrici%"
  [
    "electrici"
  ]
  "%electrici%"
  [
    "electrici"
  ]
  "%electrici%"
  [
    "electrici"
  ]
  "%electrici%"
  [
    "electrici"
  ]
]

View formatted query View runnable query Explain query

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.id AS id_1
FROM
  customer c0_
WHERE
  (
    LOWER(c0_.email) LIKE ?
    OR LOWER(c0_.email) IN (?)
    OR LOWER(c0_.username) LIKE ?
    OR LOWER(c0_.username) IN (?)
    OR LOWER(c0_.plain_password) LIKE ?
    OR LOWER(c0_.plain_password) IN (?)
    OR LOWER(c0_.name) LIKE ?
    OR LOWER(c0_.name) IN (?)
    OR LOWER(c0_.surname) LIKE ?
    OR LOWER(c0_.surname) IN (?)
    OR LOWER(c0_.address) LIKE ?
    OR LOWER(c0_.address) IN (?)
    OR LOWER(c0_.celular) LIKE ?
    OR LOWER(c0_.celular) IN (?)
    OR LOWER(c0_.image) LIKE ?
    OR LOWER(c0_.image) IN (?)
    OR LOWER(c0_.type_account) LIKE ?
    OR LOWER(c0_.type_account) IN (?)
    OR LOWER(c0_.purchase) LIKE ?
    OR LOWER(c0_.purchase) IN (?)
    OR LOWER(c0_.purchase_platform) LIKE ?
    OR LOWER(c0_.purchase_platform) IN (?)
    OR LOWER(c0_.membership_id) LIKE ?
    OR LOWER(c0_.membership_id) IN (?)
    OR LOWER(c0_.phone) LIKE ?
    OR LOWER(c0_.phone) IN (?)
    OR LOWER(c0_.google_auth_code) LIKE ?
    OR LOWER(c0_.google_auth_code) IN (?)
  )
  AND (
    c0_.deleted_at IS NOT NULL
    AND c0_.is_deleted IS NULL
  )
ORDER BY
  c0_.id DESC
LIMIT
  100

SELECT DISTINCT c0_.id AS id_0, c0_.id AS id_1 FROM customer c0_ WHERE (LOWER(c0_.email) LIKE '%electrici%' OR LOWER(c0_.email) IN ('electrici') OR LOWER(c0_.username) LIKE '%electrici%' OR LOWER(c0_.username) IN ('electrici') OR LOWER(c0_.plain_password) LIKE '%electrici%' OR LOWER(c0_.plain_password) IN ('electrici') OR LOWER(c0_.name) LIKE '%electrici%' OR LOWER(c0_.name) IN ('electrici') OR LOWER(c0_.surname) LIKE '%electrici%' OR LOWER(c0_.surname) IN ('electrici') OR LOWER(c0_.address) LIKE '%electrici%' OR LOWER(c0_.address) IN ('electrici') OR LOWER(c0_.celular) LIKE '%electrici%' OR LOWER(c0_.celular) IN ('electrici') OR LOWER(c0_.image) LIKE '%electrici%' OR LOWER(c0_.image) IN ('electrici') OR LOWER(c0_.type_account) LIKE '%electrici%' OR LOWER(c0_.type_account) IN ('electrici') OR LOWER(c0_.purchase) LIKE '%electrici%' OR LOWER(c0_.purchase) IN ('electrici') OR LOWER(c0_.purchase_platform) LIKE '%electrici%' OR LOWER(c0_.purchase_platform) IN ('electrici') OR LOWER(c0_.membership_id) LIKE '%electrici%' OR LOWER(c0_.membership_id) IN ('electrici') OR LOWER(c0_.phone) LIKE '%electrici%' OR LOWER(c0_.phone) IN ('electrici') OR LOWER(c0_.google_auth_code) LIKE '%electrici%' OR LOWER(c0_.google_auth_code) IN ('electrici')) AND (c0_.deleted_at IS NOT NULL AND c0_.is_deleted IS NULL) ORDER BY c0_.id DESC LIMIT 100;

205.35 ms
(0.00%)

SELECT COUNT(c0_.id) AS sclr_0 FROM customer c0_ WHERE (LOWER(c0_.email) LIKE ? OR LOWER(c0_.email) IN (?) OR LOWER(c0_.username) LIKE ? OR LOWER(c0_.username) IN (?) OR LOWER(c0_.plain_password) LIKE ? OR LOWER(c0_.plain_password) IN (?) OR LOWER(c0_.name) LIKE ? OR LOWER(c0_.name) IN (?) OR LOWER(c0_.surname) LIKE ? OR LOWER(c0_.surname) IN (?) OR LOWER(c0_.address) LIKE ? OR LOWER(c0_.address) IN (?) OR LOWER(c0_.celular) LIKE ? OR LOWER(c0_.celular) IN (?) OR LOWER(c0_.image) LIKE ? OR LOWER(c0_.image) IN (?) OR LOWER(c0_.type_account) LIKE ? OR LOWER(c0_.type_account) IN (?) OR LOWER(c0_.purchase) LIKE ? OR LOWER(c0_.purchase) IN (?) OR LOWER(c0_.purchase_platform) LIKE ? OR LOWER(c0_.purchase_platform) IN (?) OR LOWER(c0_.membership_id) LIKE ? OR LOWER(c0_.membership_id) IN (?) OR LOWER(c0_.phone) LIKE ? OR LOWER(c0_.phone) IN (?) OR LOWER(c0_.google_auth_code) LIKE ? OR LOWER(c0_.google_auth_code) IN (?)) AND (c0_.deleted_at IS NOT NULL AND c0_.is_deleted IS NULL)

Parameters:

[
  "%electrici%"
  [
    "electrici"
  ]
  "%electrici%"
  [
    "electrici"
  ]
  "%electrici%"
  [
    "electrici"
  ]
  "%electrici%"
  [
    "electrici"
  ]
  "%electrici%"
  [
    "electrici"
  ]
  "%electrici%"
  [
    "electrici"
  ]
  "%electrici%"
  [
    "electrici"
  ]
  "%electrici%"
  [
    "electrici"
  ]
  "%electrici%"
  [
    "electrici"
  ]
  "%electrici%"
  [
    "electrici"
  ]
  "%electrici%"
  [
    "electrici"
  ]
  "%electrici%"
  [
    "electrici"
  ]
  "%electrici%"
  [
    "electrici"
  ]
  "%electrici%"
  [
    "electrici"
  ]
]

View formatted query View runnable query Explain query

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  customer c0_
WHERE
  (
    LOWER(c0_.email) LIKE ?
    OR LOWER(c0_.email) IN (?)
    OR LOWER(c0_.username) LIKE ?
    OR LOWER(c0_.username) IN (?)
    OR LOWER(c0_.plain_password) LIKE ?
    OR LOWER(c0_.plain_password) IN (?)
    OR LOWER(c0_.name) LIKE ?
    OR LOWER(c0_.name) IN (?)
    OR LOWER(c0_.surname) LIKE ?
    OR LOWER(c0_.surname) IN (?)
    OR LOWER(c0_.address) LIKE ?
    OR LOWER(c0_.address) IN (?)
    OR LOWER(c0_.celular) LIKE ?
    OR LOWER(c0_.celular) IN (?)
    OR LOWER(c0_.image) LIKE ?
    OR LOWER(c0_.image) IN (?)
    OR LOWER(c0_.type_account) LIKE ?
    OR LOWER(c0_.type_account) IN (?)
    OR LOWER(c0_.purchase) LIKE ?
    OR LOWER(c0_.purchase) IN (?)
    OR LOWER(c0_.purchase_platform) LIKE ?
    OR LOWER(c0_.purchase_platform) IN (?)
    OR LOWER(c0_.membership_id) LIKE ?
    OR LOWER(c0_.membership_id) IN (?)
    OR LOWER(c0_.phone) LIKE ?
    OR LOWER(c0_.phone) IN (?)
    OR LOWER(c0_.google_auth_code) LIKE ?
    OR LOWER(c0_.google_auth_code) IN (?)
  )
  AND (
    c0_.deleted_at IS NOT NULL
    AND c0_.is_deleted IS NULL
  )

SELECT COUNT(c0_.id) AS sclr_0 FROM customer c0_ WHERE (LOWER(c0_.email) LIKE '%electrici%' OR LOWER(c0_.email) IN ('electrici') OR LOWER(c0_.username) LIKE '%electrici%' OR LOWER(c0_.username) IN ('electrici') OR LOWER(c0_.plain_password) LIKE '%electrici%' OR LOWER(c0_.plain_password) IN ('electrici') OR LOWER(c0_.name) LIKE '%electrici%' OR LOWER(c0_.name) IN ('electrici') OR LOWER(c0_.surname) LIKE '%electrici%' OR LOWER(c0_.surname) IN ('electrici') OR LOWER(c0_.address) LIKE '%electrici%' OR LOWER(c0_.address) IN ('electrici') OR LOWER(c0_.celular) LIKE '%electrici%' OR LOWER(c0_.celular) IN ('electrici') OR LOWER(c0_.image) LIKE '%electrici%' OR LOWER(c0_.image) IN ('electrici') OR LOWER(c0_.type_account) LIKE '%electrici%' OR LOWER(c0_.type_account) IN ('electrici') OR LOWER(c0_.purchase) LIKE '%electrici%' OR LOWER(c0_.purchase) IN ('electrici') OR LOWER(c0_.purchase_platform) LIKE '%electrici%' OR LOWER(c0_.purchase_platform) IN ('electrici') OR LOWER(c0_.membership_id) LIKE '%electrici%' OR LOWER(c0_.membership_id) IN ('electrici') OR LOWER(c0_.phone) LIKE '%electrici%' OR LOWER(c0_.phone) IN ('electrici') OR LOWER(c0_.google_auth_code) LIKE '%electrici%' OR LOWER(c0_.google_auth_code) IN ('electrici')) AND (c0_.deleted_at IS NOT NULL AND c0_.is_deleted IS NULL);

4.66 ms
(0.00%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.enabled AS enabled_5, t0.name AS name_6, t0.celular AS celular_7 FROM user t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.enabled AS enabled_5,
  t0.name AS name_6,
  t0.celular AS celular_7
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.enabled AS enabled_5, t0.name AS name_6, t0.celular AS celular_7 FROM user t0 WHERE t0.id = 3;

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
App\Entity\User	No errors.
App\Entity\Customer	The association App\Entity\Customer#exerciseQualifications refers to the owning side field App\Entity\ExerciseQualification#customer_id which does not exist.
App\Entity\AppModule	The association App\Entity\AppModule#supports refers to the owning side field App\Entity\Support#app_module which does not exist.
App\Entity\Support	The mappings App\Entity\Support#AppModule and App\Entity\AppModule#supports are inconsistent with each other. The mappings App\Entity\Support#supportFilesTemplate and App\Entity\SupportFile#Support are inconsistent with each other.
App\Entity\Tactic	No errors.
App\Entity\TypeNotification	No errors.
App\Entity\TypeSoccer	No errors.
App\Entity\Category	No errors.
App\Entity\Collaborator	No errors.
App\Entity\Competition	No errors.
App\Entity\Config	No errors.
App\Entity\Country	No errors.
App\Entity\Coupon	No errors.
App\Entity\CouponCustomer	No errors.
App\Entity\Difficulty	No errors.
App\Entity\Exercise	The field App\Entity\Exercise#notes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\NoteExercise#exercise does not contain the required 'inversedBy="notes"' attribute. The mappings App\Entity\Exercise#exerciseQualifications and App\Entity\ExerciseQualification#exercise are inconsistent with each other.
App\Entity\JustificationType	No errors.
App\Entity\Locality	No errors.
App\Entity\Material	No errors.
App\Entity\Membership	No errors.
App\Entity\MembershipAttr	No errors.
App\Entity\MembershipDesc	No errors.
App\Entity\MembershipItems	The field App\Entity\MembershipItems#translatable_id is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Membership#membershipItems does not contain the required 'inversedBy="translatable_id"' attribute. The association App\Entity\MembershipItems#membershipTranslation refers to the inverse side field App\Entity\MembershipTranslation#membership_id which does not exist.
App\Entity\Notification	No errors.
App\Entity\NotificationAutomaticMessage	No errors.
App\Entity\NotificationAutomaticTranslation	No errors.
App\Entity\Position	No errors.
App\Entity\Suggestion	No errors.
App\Entity\Team	The association App\Entity\Team#typeSoccer refers to the inverse side field App\Entity\TypeSoccer#teams which does not exist.
App\Entity\AppModuleTranslation	No errors.
App\Entity\TypeNotificationTranslation	No errors.
App\Entity\CategoryTranslation	No errors.
App\Entity\CompetitionTranslation	No errors.
App\Entity\DifficultyTranslation	No errors.
App\Entity\ExerciseTranslation	No errors.
App\Entity\JustificationTypeTranslation	No errors.
App\Entity\LocalityTranslation	No errors.
App\Entity\MaterialTranslation	No errors.
App\Entity\MembershipTranslation	No errors.
App\Entity\MembershipAttrTranslation	No errors.
App\Entity\MembershipDescTranslation	No errors.
App\Entity\NotificationTranslation	No errors.
App\Entity\PositionTranslation	No errors.

Symfony Profiler

https://prod.golmanagerpanel.com/admin/?action=search&entity=AccountsRemove&menuIndex=3&p=admin%2F&page=1&query=electrici&sortDirection=DESC&sortField=id&submenuIndex=1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping