Query Metrics

14 Database Queries
11 Different statements
33.14 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
29.71 ms
(89.63%)
1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.publish_at AS publish_at_4, p0_.type AS type_5, p0_.display AS display_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.image_id AS image_id_9, p0_.area_id AS area_id_10 FROM publication p0_ LEFT JOIN area a1_ ON p0_.area_id = a1_.id AND (a1_.region_id = '1') WHERE p0_.type = 'overview' AND p0_.display = 1 AND (a1_.id IS NULL OR (a1_.paid = 1 AND a1_.display = 1)) ORDER BY RAND() ASC LIMIT 3
Parameters:
[]
1.07 ms
(3.23%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.publish_at AS publish_at_5, t0.type AS type_6, t0.display AS display_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.image_id AS image_id_10, t0.area_id AS area_id_11 FROM publication t0 WHERE t0.slug = ? AND t0.type = ? AND t0.display = ? LIMIT 1
Parameters:
[
  "svadba-v-khamovnikakh-khoroshaia-primeta-top-15-restoranov-s-vysokim-reitingom"
  "overview"
  1
]
0.47 ms
(1.43%)
1
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.enabled_at AS enabled_at_1, a0_.disabled_at AS disabled_at_2, a0_.recommended AS recommended_3, a0_.best_for_wedding AS best_for_wedding_4, a0_.best_for_corporate AS best_for_corporate_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a1_.id AS id_8, a1_.name AS name_9, a1_.slug AS slug_10, a1_.email AS email_11, a1_.site AS site_12, a1_.you_tube_movie AS you_tube_movie_13, a1_.description AS description_14, a1_.manager_info AS manager_info_15, a1_.contact_info AS contact_info_16, a1_.closing_condition AS closing_condition_17, a1_.closing_condition_comment AS closing_condition_comment_18, a1_.address AS address_19, a1_.latitude AS latitude_20, a1_.longitude AS longitude_21, a1_.expired_at AS expired_at_22, a1_.placement_period AS placement_period_23, a1_.placement_date AS placement_date_24, a1_.min_price AS min_price_25, a1_.min_capacity AS min_capacity_26, a1_.max_capacity AS max_capacity_27, a1_.view AS view_28, a1_.phone_view AS phone_view_29, a1_.site_view AS site_view_30, a1_.address_view AS address_view_31, a1_.booking_count AS booking_count_32, a1_.award_participating AS award_participating_33, a1_.paid AS paid_34, a1_.display AS display_35, a1_.created_at AS created_at_36, a1_.updated_at AS updated_at_37, f2_.id AS id_38, f2_.title AS title_39, f2_.slug AS slug_40, f2_.genitive_title AS genitive_title_41, f2_.dative_title AS dative_title_42, f2_.accusative_title AS accusative_title_43, f2_.instrumental_title AS instrumental_title_44, f2_.prepositional_title AS prepositional_title_45, f2_.created_at AS created_at_46, f2_.updated_at AS updated_at_47 FROM advertising_top a0_ INNER JOIN area a1_ ON a0_.area_id = a1_.id AND (a1_.region_id = '1') INNER JOIN region r3_ ON a0_.region_id = r3_.id LEFT JOIN filter_metro_area f4_ ON a1_.id = f4_.area_id LEFT JOIN filter_metro f2_ ON f2_.id = f4_.filter_metro_id LEFT JOIN file f5_ ON a1_.image_id = f5_.id LEFT JOIN file f6_ ON a1_.appearance_image_id = f6_.id LEFT JOIN file f7_ ON a1_.interior_image_id = f7_.id WHERE (a0_.enabled_at < NOW() AND a0_.disabled_at > NOW() AND a0_.recommended = 1) AND (a0_.region_id = '1') ORDER BY RAND() ASC) dctrn_result) dctrn_table
Parameters:
[]
0.40 ms
(1.20%)
4
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.genitive_title AS genitive_title_4, t0.dative_title AS dative_title_5, t0.accusative_title AS accusative_title_6, t0.instrumental_title AS instrumental_title_7, t0.prepositional_title AS prepositional_title_8, t0.default AS default_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM region t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "msk"
]
0.39 ms
(1.16%)
1
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, RAND() FROM (SELECT a0_.id AS id_0, a0_.enabled_at AS enabled_at_1, a0_.disabled_at AS disabled_at_2, a0_.recommended AS recommended_3, a0_.best_for_wedding AS best_for_wedding_4, a0_.best_for_corporate AS best_for_corporate_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a1_.id AS id_8, a1_.name AS name_9, a1_.slug AS slug_10, a1_.email AS email_11, a1_.site AS site_12, a1_.you_tube_movie AS you_tube_movie_13, a1_.description AS description_14, a1_.manager_info AS manager_info_15, a1_.contact_info AS contact_info_16, a1_.closing_condition AS closing_condition_17, a1_.closing_condition_comment AS closing_condition_comment_18, a1_.address AS address_19, a1_.latitude AS latitude_20, a1_.longitude AS longitude_21, a1_.expired_at AS expired_at_22, a1_.placement_period AS placement_period_23, a1_.placement_date AS placement_date_24, a1_.min_price AS min_price_25, a1_.min_capacity AS min_capacity_26, a1_.max_capacity AS max_capacity_27, a1_.view AS view_28, a1_.phone_view AS phone_view_29, a1_.site_view AS site_view_30, a1_.address_view AS address_view_31, a1_.booking_count AS booking_count_32, a1_.award_participating AS award_participating_33, a1_.paid AS paid_34, a1_.display AS display_35, a1_.created_at AS created_at_36, a1_.updated_at AS updated_at_37, f2_.id AS id_38, f2_.title AS title_39, f2_.slug AS slug_40, f2_.genitive_title AS genitive_title_41, f2_.dative_title AS dative_title_42, f2_.accusative_title AS accusative_title_43, f2_.instrumental_title AS instrumental_title_44, f2_.prepositional_title AS prepositional_title_45, f2_.created_at AS created_at_46, f2_.updated_at AS updated_at_47 FROM advertising_top a0_ INNER JOIN area a1_ ON a0_.area_id = a1_.id AND (a1_.region_id = '1') INNER JOIN region r3_ ON a0_.region_id = r3_.id LEFT JOIN filter_metro_area f4_ ON a1_.id = f4_.area_id LEFT JOIN filter_metro f2_ ON f2_.id = f4_.filter_metro_id LEFT JOIN file f5_ ON a1_.image_id = f5_.id LEFT JOIN file f6_ ON a1_.appearance_image_id = f6_.id LEFT JOIN file f7_ ON a1_.interior_image_id = f7_.id WHERE (a0_.enabled_at < NOW() AND a0_.disabled_at > NOW() AND a0_.recommended = 1) AND (a0_.region_id = '1')) dctrn_result_inner ORDER BY RAND() ASC) dctrn_result LIMIT 8
Parameters:
[]
0.33 ms
(0.99%)
1
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.link AS link_2, a0_.display AS display_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, f1_.id AS id_6, f1_.hash AS hash_7, f1_.path AS path_8, f1_.link AS link_9, f1_.name AS name_10, f1_.file_name AS file_name_11, f1_.mime_type AS mime_type_12, f1_.size AS size_13, f1_.created_at AS created_at_14, f1_.updated_at AS updated_at_15, a0_.image_id AS image_id_16 FROM advertising_homepage_tag a0_ LEFT JOIN file f1_ ON a0_.image_id = f1_.id WHERE a0_.display = 1 ORDER BY RAND() ASC LIMIT 14
Parameters:
[]
0.29 ms
(0.86%)
1
SELECT t0.id AS id_1, t0.link AS link_2, t0.title AS title_3, t0.h1 AS h1_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM seo_static_meta t0 WHERE t0.link = ? LIMIT 1
Parameters:
[
  "/msk/publication/overview/svadba-v-khamovnikakh-khoroshaia-primeta-top-15-restoranov-s-vysokim-reitingom"
]
0.18 ms
(0.53%)
1
SELECT t0.id AS id_1, t0.hash AS hash_2, t0.path AS path_3, t0.link AS link_4, t0.name AS name_5, t0.file_name AS file_name_6, t0.mime_type AS mime_type_7, t0.size AS size_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM file t0 WHERE t0.id = ?
Parameters:
[
  16445
]
0.13 ms
(0.38%)
1
SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.name AS name_2, a0_.description AS description_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, a0_.event_id AS event_id_6 FROM area_event_selection a0_
Parameters:
[]
0.11 ms
(0.34%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.active AS active_3, t0.archive AS archive_4, t0.about AS about_5, t0.destinations AS destinations_6, t0.start AS start_7, t0.end AS end_8, t0.application_end AS application_end_9, t0.voting_start AS voting_start_10, t0.voting_end AS voting_end_11, t0.create_short_list_start AS create_short_list_start_12, t0.create_short_list_end AS create_short_list_end_13, t0.adjudicator_voting_start AS adjudicator_voting_start_14, t0.adjudicator_voting_end AS adjudicator_voting_end_15, t0.rewarding AS rewarding_16, t0.phone AS phone_17, t0.email AS email_18, t0.whats_app AS whats_app_19, t0.website AS website_20, t0.position AS position_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.about_image_id AS about_image_id_24, t0.destinations_image_id AS destinations_image_id_25, t0.stages_image_id AS stages_image_id_26, t0.banner_image_id AS banner_image_id_27, t0.presentation_id AS presentation_id_28, t0.regulations_id AS regulations_id_29 FROM award t0 WHERE t0.active = ? LIMIT 1
Parameters:
[
  1
]
0.08 ms
(0.24%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.genitive_title AS genitive_title_4, t0.dative_title AS dative_title_5, t0.accusative_title AS accusative_title_6, t0.instrumental_title AS instrumental_title_7, t0.prepositional_title AS prepositional_title_8, t0.default AS default_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM region t0
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
App\Entity\Region No errors.
App\Entity\Area\Area No errors.
App\Entity\Filter\Filter No errors.
App\Entity\Filter\FilterCity No errors.
App\Entity\Advertising\AdvertisingTop No errors.
App\Entity\Publication No errors.
App\Entity\File No errors.
App\Entity\SeoStaticMeta No errors.
App\Entity\Award\Award No errors.
App\Entity\Award\AwardAdjudicator No errors.
App\Entity\Award\AwardAdjudicatorType No errors.
App\Entity\Award\AwardAdjudicatorVote No errors.
App\Entity\Award\AwardApplication No errors.
App\Entity\Award\AwardContact No errors.
App\Entity\Award\AwardCriterion No errors.
App\Entity\Award\AwardNomination No errors.
App\Entity\Award\AwardParticipant No errors.
App\Entity\Award\AwardPartner No errors.
App\Entity\Award\AwardPartnerType No errors.
App\Entity\Award\AwardQuote No errors.
App\Entity\Award\AwardVote No errors.
App\Entity\Advertising\AdvertisingHomepageTag No errors.
App\Entity\Account No errors.
App\Entity\Advertising\AdvertisingBanner No errors.
App\Entity\Advertising\AdvertisingSelectionItem No errors.
App\Entity\Advertising\AdvertisingSlider No errors.
App\Entity\Area\AreaHall No errors.
App\Entity\IntegrationCRM No errors.
App\Entity\Area\AreaCrmEvent No errors.
App\Entity\Area\AreaEvent No errors.
App\Entity\Area\AreaEventSelectionArea No errors.
App\Entity\Area\AreaManagerRequest No errors.
App\Entity\Area\AreaPhone No errors.
App\Entity\Area\AreaReview No errors.
App\Entity\Filter\FilterCapability No errors.
App\Entity\Filter\FilterDistrict No errors.
App\Entity\Filter\FilterMetro No errors.
App\Entity\Filter\FilterSelection No errors.
App\Entity\Filter\FilterType No errors.
App\Entity\Advertising\AdvertisingSelection No errors.
App\Entity\Area\AreaEventSelection No errors.