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

Query Metrics

133 Database Queries
7 Different statements
1463.01 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1433.72 ms
(98.00%)
127
SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.email AS email_2, i0_.leadGroup AS leadGroup_3, i0_.phone AS phone_4, i0_.broker_email AS broker_email_5, i0_.origem AS origem_6, i0_.created_at AS created_at_7, i0_.broker_realState AS broker_realState_8, i0_.utm_campaign AS utm_campaign_9, i0_.utm_medium AS utm_medium_10, i0_.utm_source AS utm_source_11 FROM internit_lead_lead i0_ INNER JOIN internit_lead_product i1_ ON i0_.product_id = i1_.id WHERE i1_.id = ? AND i0_.leadGroup = ? GROUP BY i0_.id
Parameters:
[
  4
  "[Advantage+][Feed + Stories]"
]
23.47 ms
(1.60%)
1
SELECT i0_.leadGroup AS leadGroup_0, count(i0_.id) AS sclr_1 FROM internit_lead_lead i0_ LEFT JOIN internit_lead_product i1_ ON i0_.product_id = i1_.id WHERE i1_.id = ? GROUP BY i0_.leadGroup
Parameters:
[
  4
]
2.13 ms
(0.15%)
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
Parameters:
[]
1.36 ms
(0.09%)
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.04 ms
(0.07%)
1
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 ORDER BY t0.id DESC
Parameters:
[]
0.69 ms
(0.05%)
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"
]
0.61 ms
(0.04%)
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
]

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.