http://homologvolendam.descomplicavendas.com.br/

Query Metrics

7 Database Queries
7 Different statements
3.48 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.43 ms
SELECT i0_.id AS id_0, i0_.name AS name_1 FROM internit_realestate_realestate i0_
Parameters:
[]
2 0.96 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.47 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:
[
  412
]
4 0.50 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
]
5 0.44 ms
SELECT t0.typeStreet AS typeStreet_1, t0.street AS street_2, t0.number AS number_3, t0.zipCode AS zipCode_4, t0.neighbourhood AS neighbourhood_5, t0.complement AS complement_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.state_id AS state_id_10, t0.city_id AS city_id_11 FROM internit_content_address t0 WHERE t0.id = ?
Parameters:
[
  22
]
6 0.41 ms
SELECT t0.name AS name_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.state_id AS state_id_5 FROM internit_content_city t0 WHERE t0.id = ?
Parameters:
[
  3602
]
7 0.28 ms
SELECT t0.name AS name_1, t0.uf AS uf_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM internit_content_state t0 WHERE t0.id = ?
Parameters:
[
  19
]

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 field App\Application\Internit\RealEstateBundle\Entity\Realty#vendas is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Application\Internit\ConsultaVendasBundle\Entity\Vendas#empreendimento does not contain the required 'inversedBy="vendas"' 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.
App\Application\Internit\ContentBundle\Entity\State No errors.
App\Application\Internit\ContentBundle\Entity\City No errors.