Query Metrics

6 Database Queries
6 Different statements
5.20 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.20 ms
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.date_of_birth AS date_of_birth_14, t0.firstname AS firstname_15, t0.lastname AS lastname_16, t0.website AS website_17, t0.biography AS biography_18, t0.gender AS gender_19, t0.locale AS locale_20, t0.timezone AS timezone_21, t0.phone AS phone_22, t0.facebook_uid AS facebook_uid_23, t0.facebook_name AS facebook_name_24, t0.facebook_data AS facebook_data_25, t0.twitter_uid AS twitter_uid_26, t0.twitter_name AS twitter_name_27, t0.twitter_data AS twitter_data_28, t0.gplus_uid AS gplus_uid_29, t0.gplus_name AS gplus_name_30, t0.gplus_data AS gplus_data_31, t0.token AS token_32, t0.two_step_code AS two_step_code_33, t0.id AS id_34, t0.nickname AS nickname_35, t0.genre AS genre_36, t0.cpf AS cpf_37, t0.rg AS rg_38, t0.number AS number_39, t0.creci AS creci_40, t0.operator_id AS operator_id_41, t0.department_id AS department_id_42, t0.media_id AS media_id_43, t0.address_id AS address_id_44, t0.image_id AS image_id_45 FROM fos_user_user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  29
]
2 0.68 ms
SELECT t0.name AS name_1, t0.roles AS roles_2, t0.id AS id_3 FROM fos_user_group t0 INNER JOIN fos_user_user_group ON t0.id = fos_user_user_group.group_id WHERE fos_user_user_group.user_id = ?
Parameters:
[
  29
]
3 0.79 ms
SELECT t0.percent AS percent_1, t0.turn AS turn_2, t0.extraLeads AS extraLeads_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7, t0.realEstate_id AS realEstate_id_8 FROM internit_lead_realstate_percent t0 WHERE t0.product_id = ? AND t0.realEstate_id = ? LIMIT 1
Parameters:
[
  "4"
  "14"
]
4 0.15 ms
"START TRANSACTION"
Parameters:
[]
5 0.59 ms
UPDATE internit_lead_realstate_percent SET extraLeads = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "-173"
  "2024-11-25 20:22:02"
  1565
]
6 1.79 ms
"COMMIT"
Parameters:
[]

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
FOS\UserBundle\Model\User No errors.
Sonata\UserBundle\Entity\BaseUser No errors.
App\Application\Sonata\UserBundle\Entity\User No errors.
Sonata\MediaBundle\Entity\BaseMedia No errors.
App\Application\Sonata\MediaBundle\Entity\Media No errors.
App\Application\Internit\ContentBundle\Entity\Entity No errors.
App\Application\Internit\ContentBundle\Entity\Address No errors.
App\Application\Internit\RealEstateBundle\Entity\RealEstate
  • The mappings App\Application\Internit\RealEstateBundle\Entity\RealEstate#realys and App\Application\Internit\RealEstateBundle\Entity\Realty#realEstates are inconsistent with each other.
FOS\UserBundle\Model\Group No errors.
Sonata\UserBundle\Entity\BaseGroup No errors.
App\Application\Sonata\UserBundle\Entity\Group No errors.
App\Application\Internit\SecurityBundle\Entity\Hierarchy No errors.
App\Application\Internit\LeadBundle\Entity\realStatePercent No errors.
App\Application\Internit\LeadBundle\Entity\Product No errors.
App\Application\Internit\ContentBundle\Entity\State No errors.
App\Application\Internit\ContentBundle\Entity\City No errors.