http://dev80.nexgen.cz/en/news/property-investment

Query Metrics

119 Database Queries
40 Different statements
65.86 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
9.92 ms
(15.06%)
2
SELECT l0_.id AS id_0, l0_.token AS token_1 FROM lang_token l0_
Parameters:
[]
7.23 ms
(10.99%)
21
SELECT t0.homepage AS homepage_1, t0.documents_order AS documents_order_2, t0.doc_files_order AS doc_files_order_3, t0.id AS id_4, t0.sort AS sort_5, t0.files_order AS files_order_6, t0.media_updated AS media_updated_7, t0.img_files_order AS img_files_order_8, t0.parent AS parent_9, t0.seo_id AS seo_id_10, t0.template_id AS template_id_11, t0.page_file_id AS page_file_id_12, t0.file_id AS file_id_13, t0.img_file_id AS img_file_id_14, t0.doc_file_id AS doc_file_id_15 FROM web_page t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  4
]
5.51 ms
(8.36%)
1
SELECT t0.entity_class AS entity_class_1, t0.request_id AS request_id_2, t0.property AS property_3, t0.media_order AS media_order_4, t0.created AS created_5, t0.entity_id AS entity_id_6, t0.id AS id_7 FROM media_order_record t0 WHERE t0.request_id = ?
Parameters:
[
  "3155b6f3a8_6807b6da94a7d9.88710398"
]
4.28 ms
(6.51%)
11
SELECT t0.name AS name_1, t0.disabled AS disabled_2, t0.id AS id_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM web_menu_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  6
]
3.43 ms
(5.20%)
8
SELECT t0.title AS title_1, t0.description AS description_2, t0.keywords AS keywords_3, t0.name AS name_4, t0.url AS url_5, t0.`generated` AS generated_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM web_seo_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  4
]
3.27 ms
(4.96%)
9
SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.id AS id_3, t0.sort AS sort_4, t0.files_order AS files_order_5, t0.media_updated AS media_updated_6, t0.seo_id AS seo_id_7, t0.category_file_id AS category_file_id_8, t0.file_id AS file_id_9 FROM category t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  2
]
3.05 ms
(4.63%)
9
SELECT t0.path AS path_1, t0.type AS type_2, t0.template AS template_3, t0.upload_form AS upload_form_4, t0.data_sources AS data_sources_5, t0.only_once AS only_once_6, t0.id AS id_7, t0.updated_at AS updated_at_8, t0.upload AS upload_9 FROM web_template t0 WHERE t0.id = ?
Parameters:
[
  40
]
2.68 ms
(4.06%)
8
SELECT t0.noindex AS noindex_1, t0.module AS module_2, t0.anchor AS anchor_3, t0.suffix AS suffix_4, t0.entity AS entity_5, t0.id AS id_6 FROM web_seo t0 WHERE t0.id = ?
Parameters:
[
  4
]
2.60 ms
(3.95%)
8
SELECT t0.trans_value AS trans_value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM setting_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  11
]
1.60 ms
(2.43%)
1
SELECT t0.name AS name_1, t0.seo AS seo_2, t0.alt AS alt_3, t0.media AS media_4, t0.updated_at AS updated_at_5, t0.file_size AS file_size_6, t0.ext AS ext_7, t0.preview AS preview_8, t0.deleted AS deleted_9, t0.deleted_at AS deleted_at_10, t0.id AS id_11, t0.folder_id AS folder_id_12 FROM media_file t0 WHERE t0.id = ?
Parameters:
[
  18
]
1.45 ms
(2.21%)
2
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.active = ?
Parameters:
[
  1
]
1.34 ms
(2.03%)
3
SELECT t0.published AS published_1, t0.expired AS expired_2, t0.documents_order AS documents_order_3, t0.doc_files_order AS doc_files_order_4, t0.id AS id_5, t0.sort AS sort_6, t0.files_order AS files_order_7, t0.media_updated AS media_updated_8, t0.img_files_order AS img_files_order_9, t0.author_id AS author_id_10, t0.seo_id AS seo_id_11, t0.news_file_id AS news_file_id_12, t0.file_id AS file_id_13, t0.img_file_id AS img_file_id_14, t0.doc_file_id AS doc_file_id_15 FROM web_news t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  3
]
1.27 ms
(1.92%)
2
SELECT t0.name AS name_1, t0.description AS description_2, t0.longDescription AS longDescription_3, t0.price_comment AS price_comment_4, t0.agent_id AS agent_id_5, t0.external_url AS external_url_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM estate_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
1.18 ms
(1.80%)
2
SELECT t0.alias AS alias_1, t0.value AS value_2, t0.id AS id_3 FROM setting t0
Parameters:
[]
1.14 ms
(1.72%)
3
SELECT t0.alias AS alias_1, t0.active AS active_2, t0.api AS api_3, t0.display AS display_4, t0.script AS script_5, t0.category AS category_6, t0.position AS position_7, t0.code1 AS code1_8, t0.code2 AS code2_9, t0.id AS id_10, t0.sort AS sort_11 FROM web_code t0 WHERE t0.active = ?
Parameters:
[
  1
]
1.08 ms
(1.65%)
1
SELECT t0.published AS published_1, t0.expired AS expired_2, t0.documents_order AS documents_order_3, t0.doc_files_order AS doc_files_order_4, t0.id AS id_5, t0.sort AS sort_6, t0.files_order AS files_order_7, t0.media_updated AS media_updated_8, t0.img_files_order AS img_files_order_9, t0.author_id AS author_id_10, t0.seo_id AS seo_id_11, t0.news_file_id AS news_file_id_12, t0.file_id AS file_id_13, t0.img_file_id AS img_file_id_14, t0.doc_file_id AS doc_file_id_15 FROM web_news t0 WHERE t0.seo_id = ? LIMIT 1
Parameters:
[
  "49"
]
0.98 ms
(1.49%)
3
SELECT t0.entity AS entity_1, t0.controller AS controller_2, t0.bundle AS bundle_3, t0.action AS action_4, t0.id AS id_5 FROM web_module t0 WHERE t0.id = ?
Parameters:
[
  2
]
0.89 ms
(1.35%)
1
SELECT w0_.active AS active_0, w0_.only_image AS only_image_1, w0_.created AS created_2, w0_.entity_id AS entity_id_3, w0_.id AS id_4, w0_.sort AS sort_5, w0_.link_id AS link_id_6, w0_.page_id AS page_id_7, w0_.author_id AS author_id_8, w0_.file_tablet_id AS file_tablet_id_9, w0_.file_phone_id AS file_phone_id_10, w0_.video_id AS video_id_11, w0_.dms_file_tablet_id AS dms_file_tablet_id_12, w0_.dms_file_phone_id AS dms_file_phone_id_13, w0_.dms_video_id AS dms_video_id_14, w0_.file_id AS file_id_15, w0_.img_file_id AS img_file_id_16 FROM web_slider w0_ INNER JOIN web_slider_to_group w2_ ON w0_.id = w2_.slider_item_id INNER JOIN web_slider_group w1_ ON w1_.id = w2_.slider_group_id WHERE w1_.id = 1 AND w0_.active = 1 ORDER BY w0_.page_id ASC, w0_.sort ASC
Parameters:
[]
0.87 ms
(1.33%)
1
SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.api_id AS api_id_3, t0.affiliate_id AS affiliate_id_4, t0.stamp AS stamp_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.price AS price_8, t0.currency AS currency_9, t0.area_floor AS area_floor_10, t0.area_use AS area_use_11, t0.area_of_lot AS area_of_lot_12, t0.area_of_balcony AS area_of_balcony_13, t0.balcony AS balcony_14, t0.area_of_loggia AS area_of_loggia_15, t0.loggia AS loggia_16, t0.area_of_terrace AS area_of_terrace_17, t0.terrace AS terrace_18, t0.elevator AS elevator_19, t0.cellar AS cellar_20, t0.area_of_cellar AS area_of_cellar_21, t0.area_of_garden AS area_of_garden_22, t0.garden AS garden_23, t0.dont_advertise_price AS dont_advertise_price_24, t0.image AS image_25, t0.images AS images_26, t0.region AS region_27, t0.district AS district_28, t0.village AS village_29, t0.part_of_village AS part_of_village_30, t0.psc AS psc_31, t0.catastral_area AS catastral_area_32, t0.type_of_estate AS type_of_estate_33, t0.subtype_of_estate AS subtype_of_estate_34, t0.floor AS floor_35, t0.type_of_ownership AS type_of_ownership_36, t0.parking AS parking_37, t0.disposition AS disposition_38, t0.youtube AS youtube_39, t0.energy_performance_rating AS energy_performance_rating_40, t0.electricity AS electricity_41, t0.electricity_on_lot AS electricity_on_lot_42, t0.internet_connection AS internet_connection_43, t0.structure_of_building AS structure_of_building_44, t0.canalization AS canalization_45, t0.water AS water_46, t0.show_external_url_button AS show_external_url_button_47, t0.show_banner AS show_banner_48, t0.price_type AS price_type_49, t0.id AS id_50, t0.sort AS sort_51, t0.files_order AS files_order_52, t0.media_updated AS media_updated_53, t0.seo_id AS seo_id_54, t0.estate_file_id AS estate_file_id_55, t0.category_id AS category_id_56, t0.file_id AS file_id_57 FROM estate t0 ORDER BY t0.sort ASC
Parameters:
[]
0.87 ms
(1.32%)
1
SELECT w0_.link_id AS link_id_0, w0_.url AS url_1, w0_.active AS active_2, w0_.id AS id_3, w0_.sort AS sort_4, w0_.parent AS parent_5, w0_.module_id AS module_id_6, w0_.file_id AS file_id_7, w0_.img_file_id AS img_file_id_8 FROM web_menu w0_ INNER JOIN web_menu_to_group w2_ ON w0_.id = w2_.menu_item_id INNER JOIN web_menu_group w1_ ON w1_.id = w2_.menu_group_id WHERE w1_.id = 1 AND w0_.active = 1 ORDER BY w0_.sort ASC
Parameters:
[]
0.85 ms
(1.29%)
1
SELECT w0_.link_id AS link_id_0, w0_.url AS url_1, w0_.active AS active_2, w0_.id AS id_3, w0_.sort AS sort_4, w0_.parent AS parent_5, w0_.module_id AS module_id_6, w0_.file_id AS file_id_7, w0_.img_file_id AS img_file_id_8 FROM web_menu w0_ INNER JOIN web_menu_to_group w2_ ON w0_.id = w2_.menu_item_id INNER JOIN web_menu_group w1_ ON w1_.id = w2_.menu_group_id WHERE w1_.id = 4 AND w0_.active = 1 ORDER BY w0_.sort ASC
Parameters:
[]
0.78 ms
(1.18%)
2
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.default_lang = ? LIMIT 1
Parameters:
[
  1
]
0.74 ms
(1.12%)
2
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.iso_2 = ? LIMIT 1
Parameters:
[
  "en"
]
0.69 ms
(1.06%)
1
SELECT w0_.link_id AS link_id_0, w0_.url AS url_1, w0_.active AS active_2, w0_.id AS id_3, w0_.sort AS sort_4, w0_.parent AS parent_5, w0_.module_id AS module_id_6, w0_.file_id AS file_id_7, w0_.img_file_id AS img_file_id_8 FROM web_menu w0_ INNER JOIN web_menu_to_group w2_ ON w0_.id = w2_.menu_item_id INNER JOIN web_menu_group w1_ ON w1_.id = w2_.menu_group_id WHERE w1_.id = 3 AND w0_.active = 1 ORDER BY w0_.sort ASC
Parameters:
[]
0.69 ms
(1.04%)
1
SELECT t0.name AS name_1, t0.short_text AS short_text_2, t0.text AS text_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM web_news_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  3
]
0.65 ms
(0.98%)
1
SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.price AS price_3, t0.area_use AS area_use_4, t0.disposition AS disposition_5, t0.currency AS currency_6, t0.id AS id_7, t0.sort AS sort_8, t0.files_order AS files_order_9, t0.media_updated AS media_updated_10, t0.seo_id AS seo_id_11, t0.reference_file_id AS reference_file_id_12, t0.category_id AS category_id_13, t0.file_id AS file_id_14 FROM reference t0 ORDER BY t0.sort ASC
Parameters:
[]
0.63 ms
(0.95%)
1
SELECT t0.name AS name_1, t0.text AS text_2, t0.title AS title_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
0.61 ms
(0.93%)
1
SELECT t0.homepage AS homepage_1, t0.documents_order AS documents_order_2, t0.doc_files_order AS doc_files_order_3, t0.id AS id_4, t0.sort AS sort_5, t0.files_order AS files_order_6, t0.media_updated AS media_updated_7, t0.img_files_order AS img_files_order_8, t0.parent AS parent_9, t0.seo_id AS seo_id_10, t0.template_id AS template_id_11, t0.page_file_id AS page_file_id_12, t0.file_id AS file_id_13, t0.img_file_id AS img_file_id_14, t0.doc_file_id AS doc_file_id_15 FROM web_page t0
Parameters:
[]
0.58 ms
(0.88%)
1
SELECT t0.email AS email_1, t0.phone AS phone_2, t0.documents_order AS documents_order_3, t0.active AS active_4, t0.id AS id_5, t0.sort AS sort_6, t0.files_order AS files_order_7, t0.media_updated AS media_updated_8, t0.seo_id AS seo_id_9, t0.agent_file_id AS agent_file_id_10, t0.file_id AS file_id_11 FROM agent t0 ORDER BY t0.sort ASC
Parameters:
[]
0.54 ms
(0.83%)
1
SELECT w0_.published AS published_0, w0_.expired AS expired_1, w0_.documents_order AS documents_order_2, w0_.doc_files_order AS doc_files_order_3, w0_.id AS id_4, w0_.sort AS sort_5, w0_.files_order AS files_order_6, w0_.media_updated AS media_updated_7, w0_.img_files_order AS img_files_order_8, w0_.author_id AS author_id_9, w0_.seo_id AS seo_id_10, w0_.news_file_id AS news_file_id_11, w0_.file_id AS file_id_12, w0_.img_file_id AS img_file_id_13, w0_.doc_file_id AS doc_file_id_14 FROM web_news w0_ WHERE (w0_.expired > '2025-04-22 17:33:47' OR w0_.expired IS NULL) AND w0_.published <= '2025-04-22 17:33:47' ORDER BY w0_.published DESC, w0_.id DESC LIMIT 5
Parameters:
[]
0.54 ms
(0.82%)
1
SELECT w0_.link_id AS link_id_0, w0_.url AS url_1, w0_.active AS active_2, w0_.id AS id_3, w0_.sort AS sort_4, w0_.parent AS parent_5, w0_.module_id AS module_id_6, w0_.file_id AS file_id_7, w0_.img_file_id AS img_file_id_8 FROM web_menu w0_ INNER JOIN web_menu_to_group w2_ ON w0_.id = w2_.menu_item_id INNER JOIN web_menu_group w1_ ON w1_.id = w2_.menu_group_id WHERE w1_.id = 2 AND w0_.active = 1 ORDER BY w0_.sort ASC
Parameters:
[]
0.53 ms
(0.80%)
1
SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.color AS color_3, t0.id AS id_4, t0.sort AS sort_5, t0.files_order AS files_order_6, t0.media_updated AS media_updated_7, t0.service_file_id AS service_file_id_8, t0.file_id AS file_id_9 FROM service t0 ORDER BY t0.sort ASC
Parameters:
[]
0.48 ms
(0.73%)
1
SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.id AS id_3, t0.sort AS sort_4, t0.files_order AS files_order_5, t0.media_updated AS media_updated_6, t0.project_file_id AS project_file_id_7, t0.file_id AS file_id_8 FROM project t0 ORDER BY t0.sort ASC
Parameters:
[]
0.45 ms
(0.68%)
1
SELECT t0.name AS name_1, t0.id AS id_2 FROM web_menu_group t0
Parameters:
[]
0.44 ms
(0.68%)
1
SELECT t0.block_key AS block_key_1, t0.id AS id_2, t0.files_order AS files_order_3, t0.media_updated AS media_updated_4, t0.img_files_order AS img_files_order_5, t0.block_file_id AS block_file_id_6, t0.file_id AS file_id_7, t0.img_file_id AS img_file_id_8, t0.doc_file_id AS doc_file_id_9 FROM web_block t0
Parameters:
[]
0.44 ms
(0.67%)
1
SELECT t0.alias AS alias_1, t0.value AS value_2, t0.id AS id_3 FROM setting t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
  "default_thumbnail_size"
]
0.44 ms
(0.66%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.lft AS lft_3, t0.rgt AS rgt_4, t0.lvl AS lvl_5, t0.root AS root_6, t0.deleted AS deleted_7, t0.deleted_at AS deleted_at_8, t0.parent_id AS parent_id_9 FROM folder t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.43 ms
(0.66%)
1
SELECT w0_.published AS published_0, w0_.expired AS expired_1, w0_.documents_order AS documents_order_2, w0_.doc_files_order AS doc_files_order_3, w0_.id AS id_4, w0_.sort AS sort_5, w0_.files_order AS files_order_6, w0_.media_updated AS media_updated_7, w0_.img_files_order AS img_files_order_8, w0_.author_id AS author_id_9, w0_.seo_id AS seo_id_10, w0_.news_file_id AS news_file_id_11, w0_.file_id AS file_id_12, w0_.img_file_id AS img_file_id_13, w0_.doc_file_id AS doc_file_id_14 FROM web_news w0_ WHERE (w0_.expired > '2025-04-22 17:33:46' OR w0_.expired IS NULL) AND w0_.published <= '2025-04-22 17:33:46' ORDER BY w0_.published DESC, w0_.id DESC LIMIT 6
Parameters:
[]
0.42 ms
(0.63%)
1
SELECT t0.name AS name_1, t0.id AS id_2 FROM web_slider_group t0
Parameters:
[]
0.28 ms
(0.43%)
1
SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.id AS id_3, t0.sort AS sort_4, t0.files_order AS files_order_5, t0.media_updated AS media_updated_6, t0.seo_id AS seo_id_7, t0.category_file_id AS category_file_id_8, t0.file_id AS file_id_9 FROM category t0 ORDER BY t0.sort ASC
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
NexCRM\BaseBundle\Entity\Lang No errors.
NexCRM\BaseBundle\Entity\Setting No errors.
NexCRM\BaseBundle\Entity\Country No errors.
NexCRM\BaseBundle\Entity\SettingTranslation No errors.
NexCRM\WebBundle\Entity\Page No errors.
NexCRM\WebBundle\Entity\SEO No errors.
NexCRM\WebBundle\Entity\Template No errors.
NexCRM\BaseBundle\Entity\MediaFile No errors.
NexCRM\DMSBundle\Entity\File No errors.
NexCRM\WebBundle\Entity\Content No errors.
NexCRM\WebBundle\Entity\PageTranslation No errors.
NexCRM\WebBundle\Entity\Menu No errors.
NexCRM\WebBundle\Entity\MenuGroup No errors.
NexCRM\WebBundle\Entity\MenuGroupTranslation No errors.
NexCRM\WebBundle\Entity\Module No errors.
NexCRM\WebBundle\Entity\MenuTranslation No errors.
NexCRM\WebBundle\Entity\SEOTranslation No errors.
NexCRM\WebBundle\Entity\ModuleTranslation No errors.
NexCRM\WebBundle\Entity\News No errors.
NexCRM\BaseBundle\Entity\User No errors.
NexCRM\WebBundle\Entity\Tag No errors.
NexCRM\WebBundle\Entity\NewsTranslation No errors.
App\Entity\Category No errors.
App\Entity\CategoryTranslation No errors.
NexCRM\WebBundle\Entity\Slider No errors.
NexCRM\WebBundle\Entity\SliderGroup No errors.
NexCRM\WebBundle\Entity\Block No errors.
App\Entity\Estate No errors.
App\Entity\Tag No errors.
App\Entity\EstateTranslation No errors.
NexCRM\WebBundle\Entity\TemplateTranslation No errors.
App\Entity\Service No errors.
App\Entity\ServiceTranslation No errors.
App\Entity\Agent No errors.
App\Entity\AgentTranslation No errors.
App\Entity\Project No errors.
App\Entity\ProjectTranslation No errors.
App\Entity\Reference No errors.
App\Entity\ReferenceTranslation No errors.
NexCRM\BaseBundle\Entity\LangToken No errors.
NexCRM\BaseBundle\Entity\Folder No errors.
NexCRM\BaseBundle\Entity\MediaFileTranslation No errors.
NexCRM\WebBundle\Entity\Code No errors.
NexCRM\WebBundle\Entity\CodeTranslation No errors.
NexCRM\BaseBundle\Entity\MediaOrderRecord No errors.