Query Metrics
6
Database Queries
6
Different statements
14.04 ms
Query time
5
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 2.72 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.private AS private_3, p0_.level AS level_4, p0_._left AS _left_5, p0_._right AS _right_6, p0_.root AS root_7, p0_.compound_related AS compound_related_8, p0_.reference_id AS reference_id_9, p0_.exchangeable AS exchangeable_10, p0_.is_evaluable AS is_evaluable_11, p0_.synced AS synced_12, p0_.searchable AS searchable_13, p0_.deleted_at AS deleted_at_14, p0_.custom_order AS custom_order_15, p0_.parent_id AS parent_id_16 FROM property_types p0_ WHERE (p0_.parent_id IS NULL) AND (p0_.deleted_at IS NULL) ORDER BY p0_._left ASC LIMIT 1
Parameters:
[] |
2 | 2.12 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.property_type_id AS property_type_id_5 FROM property_types_translations t0 WHERE t0.property_type_id = ?
Parameters:
[
1
]
|
3 | 2.10 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.main AS main_6, t0.searchable AS searchable_7, t0.slug AS slug_8, t0.synced AS synced_9, t0.reference_id AS reference_id_10, t0.meta_search_description AS meta_search_description_11 FROM sections t0 LIMIT 1
Parameters:
[] |
4 | 2.23 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.section_id AS section_id_5 FROM sections_translations t0 WHERE t0.section_id = ?
Parameters:
[
1
]
|
5 | 2.34 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.url AS url_2, a0_.description AS description_3, a0_.customer_title AS customer_title_4, a0_.customer_url AS customer_url_5, a0_.customer_description AS customer_description_6, a0_.end_at AS end_at_7, a0_.start_at AS start_at_8, a0_.color AS color_9, a0_.counter AS counter_10, a0_.top_bar AS top_bar_11, a0_.appear_on_mobile AS appear_on_mobile_12 FROM announcements a0_ WHERE a0_.top_bar IN (?) AND a0_.end_at >= ?
Parameters:
[ 1 "2025-01-18 07:50:22" ] |
6 | 2.54 ms |
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.identifier AS identifier_2, f0_.description AS description_3, f0_.toggle_owner AS toggle_owner_4, f0_.status AS status_5, f0_.category AS category_6, f0_.added_at_date AS added_at_date_7, f0_.updated_at_date AS updated_at_date_8 FROM features_toggles f0_ WHERE f0_.identifier = ?
Parameters:
[
"web.enable.expo.testimonials"
]
|
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 |
---|---|
Aqarmap\Bundle\ListingBundle\Entity\Listing |
|
App\Entity\Lead\Lead | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\Location |
|
Aqarmap\Bundle\ListingBundle\Entity\Phone | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\UserPhone | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\ListingPhone | No errors. |
Aqarmap\Bundle\UserBundle\Entity\UserServices | No errors. |
Aqarmap\Bundle\UserBundle\Entity\User |
|
Aqarmap\Bundle\ListingBundle\Entity\PropertyType | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\CompoundLocation | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\Rule | No errors. |
Aqarmap\Bundle\UserBundle\Entity\UserPackages | No errors. |
Aqarmap\Bundle\CreditBundle\Entity\Credit |
|
Aqarmap\Bundle\PaymentBundle\Entity\Payment |
|
Aqarmap\Bundle\FeatureToggleBundle\Entity\FeatureToggle | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\ListingLead | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\TopSellerLead | No errors. |
Aqarmap\Bundle\NeighborhoodBundle\Entity\LocationStatistics | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\TopCustomer | No errors. |
Aqarmap\Bundle\MessageBundle\Entity\Message | No errors. |
Aqarmap\Bundle\MessageBundle\Entity\Conversation | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\ListingPhoto | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\Interaction | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\Favourite | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\CallRequestLead | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\PhoneLead | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\MessageLead | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\FreeListing | No errors. |
Aqarmap\Bundle\MainBundle\Entity\CustomParagraph | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\TargetUserPhoneLead | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\TargetUserMessageLead | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\TargetUserLead | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\SimilarListingsLead | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\UserDomainPhoneLead | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\UserDomainMessageLead | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\WhatsAppLead | No errors. |
Aqarmap\Bundle\UserBundle\Entity\UserInterest | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\Section | No errors. |
Aqarmap\Bundle\MainBundle\Entity\Setting | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\Lead | No errors. |
Aqarmap\Bundle\MessageBundle\Entity\Recipient | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\CallRequest | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\ListingFeature | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\CustomField | No errors. |
Aqarmap\Bundle\SearchBundle\Entity\SearchResultCombinations | No errors. |
Aqarmap\Bundle\UserBundle\Entity\Group | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\Rejection | No errors. |
Aqarmap\Bundle\AnnouncementBundle\Entity\Announcement | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\PropertyTypeTranslation | No errors. |
Aqarmap\Bundle\NeighborhoodBundle\Entity\LocationCompoundSize | No errors. |
Aqarmap\Bundle\NotifierBundle\Entity\Notifier | No errors. |
Aqarmap\Bundle\ExchangeBundle\Entity\ExchangeRequest | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\CompoundAveragePrice | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\SectionTranslation | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\PriceFilter | No errors. |