Query Metrics
7
Database Queries
7
Different statements
3.17 ms
Query time
2
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.34 ms |
SELECT i0_.id AS id_0, i0_.name AS name_1 FROM internit_realestate_realestate i0_
Parameters:
[] |
2 | 0.82 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.45 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.49 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.42 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.43 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.23 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 |
|
App\Application\Internit\RealEstateBundle\Entity\RealEstate |
|
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. |