http://calper.descomplicavendas.com.br/admin/internit/lead/product/4/edit

Query Metrics

95 Database Queries
9 Different statements
70.45 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
32.61 ms
(46.29%)
1
SELECT t0.name AS name_1, t0.email AS email_2, t0.phone AS phone_3, t0.fixedPhone AS fixedPhone_4, t0.leadGroup AS leadGroup_5, t0.origem AS origem_6, t0.empreendimento AS empreendimento_7, t0.broker_email AS broker_email_8, t0.broker_realState AS broker_realState_9, t0.utm_source AS utm_source_10, t0.utm_medium AS utm_medium_11, t0.utm_campaign AS utm_campaign_12, t0.message AS message_13, t0.id AS id_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.product_id AS product_id_17 FROM internit_lead_lead t0 WHERE t0.product_id = ?
Parameters:
[
  4
]
27.57 ms
(39.13%)
73
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 = ?
Parameters:
[
  59
]
3.83 ms
(5.44%)
14
SELECT t0.name AS name_1, t0.corporateName AS corporateName_2, t0.cnpj AS cnpj_3, t0.creci AS creci_4, t0.phone AS phone_5, t0.email AS email_6, t0.receive_lead AS receive_lead_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.logo_id AS logo_id_11, t0.address_id AS address_id_12 FROM internit_realestate_realestate t0 WHERE t0.id = ?
Parameters:
[
  8
]
1.91 ms
(2.70%)
1
SELECT f0_.id AS id_0, f0_.firstname AS firstname_1, i1_.name AS name_2, i1_.id AS id_3 FROM fos_user_user f0_ INNER JOIN fos_user_user_group f3_ ON f0_.id = f3_.user_id INNER JOIN fos_user_group f2_ ON f2_.id = f3_.group_id INNER JOIN internit_realestate_users_as_realestate i4_ ON f0_.id = i4_.user_id INNER JOIN internit_realestate_realestate i1_ ON i1_.id = i4_.real_estate_id WHERE f2_.name = 'Corretor' ORDER BY i1_.name ASC
Parameters:
[]
1.38 ms
(1.95%)
1
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
]
1.12 ms
(1.59%)
2
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 = ? ORDER BY t0.percent DESC
Parameters:
[
  4
]
0.93 ms
(1.32%)
1
SELECT t0.position AS position_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.user_id AS user_id_6, t0.realEstate_id AS realEstate_id_7 FROM internit_lead_product_user t0 WHERE t0.product_id = ? ORDER BY t0.position ASC
Parameters:
[
  4
]
0.57 ms
(0.81%)
1
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
]
0.53 ms
(0.76%)
1
SELECT t0.name AS name_1, t0.description AS description_2, t0.token AS token_3, t0.viva_real AS viva_real_4, t0.zap AS zap_5, t0.olx AS olx_6, t0.turn AS turn_7, t0.email AS email_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM internit_lead_product t0 WHERE t0.id = ?
Parameters:
[
  "4"
]

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\Product No errors.
App\Application\Internit\LeadBundle\Entity\ProductUser No errors.
App\Application\Internit\LeadBundle\Entity\Lead No errors.
App\Application\Internit\LeadBundle\Entity\realStatePercent No errors.
App\Application\Internit\CommunicationBundle\Entity\Communication
  • The field App\Application\Internit\CommunicationBundle\Entity\Communication#communicationUsers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Application\Internit\CommunicationBundle\Entity\CommunicationUser#communication does not contain the required 'inversedBy="communicationUsers"' attribute.
App\Application\Internit\RealEstateBundle\Entity\Realty
  • The association App\Application\Internit\RealEstateBundle\Entity\Realty#realEstates refers to the inverse side field App\Application\Internit\RealEstateBundle\Entity\RealEstate#realtys which does not exist.
  • The field App\Application\Internit\RealEstateBundle\Entity\Realty#proposals is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Application\Internit\ProposalBundle\Entity\Proposal#realty does not contain the required 'inversedBy="proposals"' attribute.
  • The mappings App\Application\Internit\RealEstateBundle\Entity\Realty#videos and App\Application\Internit\RealEstateBundle\Entity\Video#realty are inconsistent with each other.
  • The mappings App\Application\Internit\RealEstateBundle\Entity\Realty#gallerysFiles and App\Application\Internit\RealEstateBundle\Entity\GalleryFile#realty are inconsistent with each other.
  • The mappings App\Application\Internit\RealEstateBundle\Entity\Realty#suites and App\Application\Internit\RealEstateBundle\Entity\RealtySuite#realtys are inconsistent with each other.
  • The mappings App\Application\Internit\RealEstateBundle\Entity\Realty#vacancies and App\Application\Internit\RealEstateBundle\Entity\RealtyVacancy#realtys are inconsistent with each other.