http://calper.descomplicavendas.com.br/

Query Metrics

4 Database Queries
4 Different statements
2.87 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.52 ms
SELECT i0_.id AS id_0, i0_.name AS name_1 FROM internit_realestate_realestate i0_
Parameters:
[]
2 1.12 ms
SELECT t0.name AS name_1, t0.phone AS phone_2, t0.whatsapp AS whatsapp_3, t0.siteUrl AS siteUrl_4, t0.mapLink AS mapLink_5, t0.openingHours AS openingHours_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.logo_id AS logo_id_10, t0.address_id AS address_id_11 FROM internit_builder_builder t0 WHERE t0.id = ?
Parameters:
[
  1
]
3 0.64 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  3
]
4 0.58 ms
SELECT t0.url AS url_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM internit_builder_email t0 INNER JOIN internit_builder_builder_has_contactEmails ON t0.id = internit_builder_builder_has_contactEmails.email_id WHERE internit_builder_builder_has_contactEmails.builder_id = ?
Parameters:
[
  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
App\Application\Internit\ContentBundle\Entity\Entity No errors.
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.
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.
App\Application\Internit\BuilderBundle\Entity\Builder No errors.
Sonata\MediaBundle\Entity\BaseMedia No errors.
App\Application\Sonata\MediaBundle\Entity\Media No errors.
App\Application\Internit\ContentBundle\Entity\Address No errors.
App\Application\Internit\BuilderBundle\Entity\Email No errors.
Sonata\MediaBundle\Entity\BaseGalleryHasMedia No errors.
App\Application\Sonata\MediaBundle\Entity\GalleryHasMedia No errors.