Query Metrics
28
Database Queries
15
Different statements
62.81 ms
Query time
5
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
11.56 ms (18.40%) |
6 |
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
]
|
11.36 ms (18.08%) |
6 |
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 WHERE t0.id = ?
Parameters:
[
1
]
|
6.60 ms (10.51%) |
3 |
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
Parameters:
[] |
4.52 ms (7.19%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.alias AS alias_3, t0.description AS description_4, t0.slug AS slug_5, t0.lat AS lat_6, t0.lon AS lon_7, t0.zoom AS zoom_8, t0.coordinates AS coordinates_9, t0.searchable AS searchable_10, t0.home_filter AS home_filter_11, t0.statistics_filter AS statistics_filter_12, t0.neighborhood_filter AS neighborhood_filter_13, t0.compound_filter AS compound_filter_14, t0.estimate AS estimate_15, t0.disabled AS disabled_16, t0.synced AS synced_17, t0.level AS level_18, t0._left AS _left_19, t0._right AS _right_20, t0.root AS root_21, t0.leads_counter AS leads_counter_22, t0.listings_counter AS listings_counter_23, t0.keyword AS keyword_24, t0.full_path AS full_path_25, t0.reference_id AS reference_id_26, t0.type AS type_27, t0.eligible_for_mortgage AS eligible_for_mortgage_28, t0.is_compound_location AS is_compound_location_29, t0.parent_id AS parent_id_30, t0.location_compound_id AS location_compound_id_31, t0.rating_id AS rating_id_32, t0.listing_id AS listing_id_33 FROM locations t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"alexandria-smouha"
]
|
4.48 ms (7.14%) |
2 |
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:
[
13
]
|
3.40 ms (5.42%) |
1 |
SELECT COUNT(*) FROM listings t0 WHERE t0.section_id = ? AND t0.property_type_id = ? AND t0.status = ? AND t0.featured IN (?) AND ((t0.deleted_at IS NULL))
Parameters:
[ 1 13 2 [ 1 10 9 7 8 3 ] ] |
2.95 ms (4.70%) |
1 |
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.paragraph AS paragraph_2, c0_.place AS place_3, c0_.is_published AS is_published_4, c0_.photo AS photo_5 FROM custom_paragraphs c0_ INNER JOIN paragraphs_property_types p2_ ON c0_.id = p2_.paragraph_id INNER JOIN property_types p1_ ON p1_.id = p2_.property_type_id AND (p1_.deleted_at IS NULL) INNER JOIN paragraphs_sections p4_ ON c0_.id = p4_.paragraph_id INNER JOIN sections s3_ ON s3_.id = p4_.section_id WHERE p1_.id IN (?) AND s3_.id = ? AND c0_.place = ? AND (SELECT COUNT(*) FROM paragraphs_locations p5_ WHERE p5_.paragraph_id = c0_.id) = 0 AND (SELECT COUNT(*) FROM paragraphs_compound_locations p6_ WHERE p6_.paragraph_id = c0_.id) = 0 LIMIT 1
Parameters:
[ 13 1 1 ] |
2.62 ms (4.17%) |
1 |
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_.id IN (?)) AND (p0_.deleted_at IS NULL) ORDER BY FIELD(p0_.id, ?) ASC
Parameters:
[ [ 13 ] [ 13 ] ] |
2.51 ms (4.00%) |
1 |
SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.alias AS alias_2, l0_.description AS description_3, l0_.slug AS slug_4, l0_.lat AS lat_5, l0_.lon AS lon_6, l0_.zoom AS zoom_7, l0_.coordinates AS coordinates_8, l0_.searchable AS searchable_9, l0_.home_filter AS home_filter_10, l0_.statistics_filter AS statistics_filter_11, l0_.neighborhood_filter AS neighborhood_filter_12, l0_.compound_filter AS compound_filter_13, l0_.estimate AS estimate_14, l0_.disabled AS disabled_15, l0_.synced AS synced_16, l0_.level AS level_17, l0_._left AS _left_18, l0_._right AS _right_19, l0_.root AS root_20, l0_.leads_counter AS leads_counter_21, l0_.listings_counter AS listings_counter_22, l0_.keyword AS keyword_23, l0_.full_path AS full_path_24, l0_.reference_id AS reference_id_25, l0_.type AS type_26, l0_.eligible_for_mortgage AS eligible_for_mortgage_27, l0_.is_compound_location AS is_compound_location_28, l0_.parent_id AS parent_id_29, l0_.location_compound_id AS location_compound_id_30, l0_.rating_id AS rating_id_31, l0_.listing_id AS listing_id_32 FROM locations l0_ WHERE l0_.slug IN (?)
Parameters:
[
[
"alexandria-smouha"
]
]
|
2.36 ms (3.76%) |
1 |
SELECT u0_.full_name AS full_name_0 FROM top_customers t1_ INNER JOIN users u0_ ON t1_.user_id = u0_.id WHERE t1_.section_id = 1 AND t1_.property_type_id = 1 AND t1_.parent_id IS NULL AND t1_.is_company = ? AND t1_.live_listings_count <> ? AND t1_.is_valid = ? GROUP BY t1_.user_id ORDER BY t1_.live_listings_count DESC LIMIT 5
Parameters:
[ true 0 true ] |
2.24 ms (3.57%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.private AS private_4, t0.level AS level_5, t0._left AS _left_6, t0._right AS _right_7, t0.root AS root_8, t0.compound_related AS compound_related_9, t0.reference_id AS reference_id_10, t0.exchangeable AS exchangeable_11, t0.is_evaluable AS is_evaluable_12, t0.synced AS synced_13, t0.searchable AS searchable_14, t0.deleted_at AS deleted_at_15, t0.custom_order AS custom_order_16, t0.parent_id AS parent_id_17 FROM property_types t0 WHERE t0.slug = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
"mall"
]
|
2.17 ms (3.45%) |
1 |
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 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"for-sale"
]
|
2.14 ms (3.41%) |
1 |
SELECT t0.id AS id_1, t0.growth AS growth_2, t0.avg_price AS avg_price_3, t0.demand_heat AS demand_heat_4, t0.ppm_min AS ppm_min_5, t0.ppm_max AS ppm_max_6, t0.updated_at AS updated_at_7, t0.section_id AS section_id_8, t0.property_type_id AS property_type_id_9, t0.location_id AS location_id_10 FROM locations_statistics t0 WHERE t0.section_id = ? AND t0.property_type_id = ? ORDER BY t0.updated_at DESC LIMIT 1
Parameters:
[ 1 13 ] |
1.97 ms (3.13%) |
1 |
SELECT p0_.content AS content_0 FROM property_types p1_ INNER JOIN property_types_translations p0_ ON p1_.id = p0_.property_type_id WHERE (p1_.parent_id = 13 AND p0_.field = ? AND p0_.locale = ? AND p1_.private = ?) AND (p1_.deleted_at IS NULL)
Parameters:
[ "title" "en" 0 ] |
1.93 ms (3.08%) |
1 |
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.meta_title AS meta_title_3, s0_.meta_description AS meta_description_4, s0_.main AS main_5, s0_.searchable AS searchable_6, s0_.slug AS slug_7, s0_.synced AS synced_8, s0_.reference_id AS reference_id_9, s0_.meta_search_description AS meta_search_description_10 FROM sections s0_ WHERE s0_.searchable = 1
Parameters:
[] |
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\NeighborhoodBundle\Entity\LocationCompound | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\LocationRating | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\SectionTranslation | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\PriceFilter | No errors. |
Aqarmap\Bundle\ExchangeBundle\Entity\ExchangeRequest | 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\ListingBundle\Entity\CompoundAveragePrice | No errors. |