GET https://yerevanpark.dev-16.toolbox.am/en/food-court

Query Metrics

301 Database Queries
18 Different statements
67.50 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
41.79 ms
(61.91%)
216
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.key_name AS key_name_4, t0.url AS url_5 FROM contact t0 WHERE t0.key_name = ? LIMIT 1
Parameters:
[
  "instagram"
]
5.07 ms
(7.52%)
18
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM child_menu_translations t0 WHERE t0.object_id = ?
Parameters:
[
  2
]
3.45 ms
(5.11%)
12
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM contact_translation t0 WHERE t0.object_id = ?
Parameters:
[
  6
]
2.70 ms
(4.01%)
10
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM menu_translation t0 WHERE t0.object_id = ?
Parameters:
[
  2
]
2.68 ms
(3.97%)
10
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.position AS position_4, t0.show_in_footer AS show_in_footer_5, t0.show_in_header AS show_in_header_6, t0.menu_id AS menu_id_7 FROM child_menu t0 WHERE t0.menu_id = ?
Parameters:
[
  2
]
2.23 ms
(3.30%)
10
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.key_name AS key_name_4, t0.url AS url_5 FROM contact t0
Parameters:
[]
1.72 ms
(2.55%)
5
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM food_court_menu_translation t0 WHERE t0.object_id = ?
Parameters:
[
  1
]
1.72 ms
(2.55%)
6
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM ice_cream_translation t0 WHERE t0.object_id = ?
Parameters:
[
  1
]
1.22 ms
(1.81%)
4
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM childrens_combo_slider_translation t0 WHERE t0.object_id = ?
Parameters:
[
  3
]
0.76 ms
(1.12%)
2
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.position AS position_4, t0.show_in_footer AS show_in_footer_5, t0.show_in_header AS show_in_header_6 FROM menu t0 WHERE t0.show_in_header = ? ORDER BY t0.position ASC
Parameters:
[
  "1"
]
0.75 ms
(1.12%)
1
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.meta_title AS meta_title_4, t0.meta_keywords AS meta_keywords_5, t0.meta_description AS meta_description_6, t0.body AS body_7, t0.description AS description_8, t0.image AS image_9, t0.background_image AS background_image_10, t0.meta_image AS meta_image_11, t0.file AS file_12, t0.images AS images_13, t0.video AS video_14, t0.page_video AS page_video_15, t0.animation AS animation_16 FROM page t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "food-court"
]
0.74 ms
(1.10%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.image AS image_5 FROM food_court_menu t0 WHERE t0.is_active = ?
Parameters:
[
  1
]
0.62 ms
(0.92%)
1
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  12
]
0.53 ms
(0.79%)
1
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.image AS image_3, t0.position AS position_4 FROM food_court_slider t0 ORDER BY t0.position ASC
Parameters:
[]
0.49 ms
(0.72%)
1
SELECT t0.id AS id_1, t0.image AS image_2, t0.title AS title_3, t0.is_active AS is_active_4, t0.body AS body_5, t0.position AS position_6 FROM childrens_combo_slider t0 WHERE t0.is_active = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
0.39 ms
(0.58%)
1
SELECT t0.id AS id_1, t0.color AS color_2, t0.image AS image_3, t0.title AS title_4, t0.body AS body_5 FROM ice_cream t0
Parameters:
[]
0.34 ms
(0.50%)
1
SELECT t0.id AS id_1, t0.video AS video_2 FROM ice_cream_videos t0
Parameters:
[]
0.29 ms
(0.42%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.position AS position_4, t0.show_in_footer AS show_in_footer_5, t0.show_in_header AS show_in_header_6 FROM menu t0 WHERE t0.show_in_footer = ? ORDER BY t0.position ASC
Parameters:
[
  "1"
]

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\Page No errors.
App\Entity\Translation\PageTranslation No errors.
App\Entity\FoodCourtSlider No errors.
App\Entity\FoodCourtMenu No errors.
App\Entity\Translation\FoodCourtMenuTranslation No errors.
App\Entity\IceCream No errors.
App\Entity\Translation\IceCreamTranslation No errors.
App\Entity\IceCreamVideos No errors.
App\Entity\ChildrensComboSlider No errors.
App\Entity\Translation\ChildrensComboSliderTranslation No errors.
App\Entity\Menu No errors.
App\Entity\ChildMenu
  • The mappings App\Entity\ChildMenu#translation and App\Entity\Translation\ChildMenuTranslation#object are inconsistent with each other.
App\Entity\Translation\MenuTranslation No errors.
App\Entity\Translation\ChildMenuTranslation
  • The association App\Entity\Translation\ChildMenuTranslation#object refers to the inverse side field App\Entity\ChildMenu#translations which does not exist.
App\Entity\Contact No errors.
App\Entity\Translation\ContactTranslation No errors.