Query Metrics
121
Database Queries
34
Different statements
250.06 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
128.76 ms (51.49%) |
5 |
SELECT i0_.highlighted_category AS highlighted_category_0, i0_.year AS year_1, i0_.id AS id_2, i0_.created_by AS created_by_3, i0_.updated_by AS updated_by_4, i0_.deleted_at AS deleted_at_5, i0_.created_at AS created_at_6, i0_.updated_at AS updated_at_7, i0_.vendor_id AS vendor_id_8, i0_.date AS date_9, i0_.is_chart AS is_chart_10, i1_.is_slider AS is_slider_11, i1_.is_rss_feed AS is_rss_feed_12, i1_.file_content AS file_content_13, i1_.id AS id_14, i1_.created_by AS created_by_15, i1_.updated_by AS updated_by_16, i1_.deleted_at AS deleted_at_17, i1_.created_at AS created_at_18, i1_.updated_at AS updated_at_19, i1_.locale AS locale_20, i1_.title AS title_21, i1_.slug AS slug_22, i1_.is_active AS is_active_23, i1_.is_highlighted AS is_highlighted_24, i1_.file AS file_25, i1_.content AS content_26, i0_.category_id AS category_id_27, i0_.post_id AS post_id_28, i1_.translatable_id AS translatable_id_29 FROM investor_announcement i0_ INNER JOIN investor_announcement_translation i1_ ON i0_.id = i1_.translatable_id WHERE i1_.is_active = 1 AND i0_.highlighted_category IN (?) AND i1_.locale = ? ORDER BY i0_.date DESC LIMIT 10
Parameters:
[ "equilor" "hu" ] |
|
46.49 ms (18.59%) |
14 |
SELECT t0.role AS role_1, t0.social_linkedin AS social_linkedin_2, t0.resume AS resume_3, t0.email AS email_4, t0.phone AS phone_5, t0.id AS id_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.deleted_at AS deleted_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.locale AS locale_12, t0.title AS title_13, t0.slug AS slug_14, t0.is_active AS is_active_15, t0.translatable_id AS translatable_id_16 FROM company_team_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
b"""
\x01ì+û╣;wmú\x1Cê‗\n
éc
"""
]
|
|
9.95 ms (3.98%) |
20 |
SELECT t0.url AS url_1, t0.id AS id_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.deleted_at AS deleted_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.locale AS locale_8, t0.title AS title_9, t0.slug AS slug_10, t0.is_active AS is_active_11, t0.translatable_id AS translatable_id_12 FROM investor_announcement_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
b"\x01ì)\r┬¥\x7FÓ½─eU╝nx-"
]
|
|
8.94 ms (3.57%) |
1 |
SELECT i0_.highlighted_category AS highlighted_category_0, i0_.year AS year_1, i0_.id AS id_2, i0_.created_by AS created_by_3, i0_.updated_by AS updated_by_4, i0_.deleted_at AS deleted_at_5, i0_.created_at AS created_at_6, i0_.updated_at AS updated_at_7, i0_.vendor_id AS vendor_id_8, i0_.date AS date_9, i0_.is_chart AS is_chart_10, i0_.category_id AS category_id_11, i0_.post_id AS post_id_12 FROM investor_announcement i0_ INNER JOIN investor_announcement_translation i1_ ON i0_.id = i1_.translatable_id WHERE i1_.is_active = 1 AND i1_.deleted_at IS NULL AND i1_.locale = ? ORDER BY i0_.date DESC LIMIT 5
Parameters:
[
"hu"
]
|
|
8.58 ms (3.43%) |
13 |
SELECT t0.subtitle AS subtitle_1, t0.is_inverse AS is_inverse_2, t0.is_section AS is_section_3, t0.is_collapsed AS is_collapsed_4, t0.is_localized AS is_localized_5, t0.content_secondary AS content_secondary_6, t0.hash AS hash_7, t0.id AS id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.deleted_at AS deleted_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.locale AS locale_14, t0.title AS title_15, t0.slug AS slug_16, t0.is_active AS is_active_17, t0.content AS content_18, t0.lead AS lead_19, t0.navigation_url AS navigation_url_20, t0.navigation_title AS navigation_title_21, t0.media AS media_22, t0.media_collection AS media_collection_23, t0.translatable_id AS translatable_id_24 FROM common_layout_block_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
b"\x01ì\x03Þü }Uë2ûpì═\x02J"
]
|
|
5.48 ms (2.19%) |
10 |
SELECT t0.is_slider AS is_slider_1, t0.is_rss_feed AS is_rss_feed_2, t0.file_content AS file_content_3, t0.id AS id_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.deleted_at AS deleted_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.locale AS locale_10, t0.title AS title_11, t0.slug AS slug_12, t0.is_active AS is_active_13, t0.is_highlighted AS is_highlighted_14, t0.file AS file_15, t0.content AS content_16, t0.translatable_id AS translatable_id_17 FROM investor_announcement_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
b"\x01É]³\x19`\x7FcüÜNÆÇ½ÿ\x19"
]
|
|
4.93 ms (1.97%) |
1 |
SELECT t0.volume AS volume_1, t0.volume_huf AS volume_huf_2, t0.closing AS closing_3, t0.weighted_average AS weighted_average_4, t0.change_percentage AS change_percentage_5, t0.id AS id_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.deleted_at AS deleted_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.vendor_id AS vendor_id_12, t0.date AS date_13 FROM investor_stock_history t0 ORDER BY t0.date DESC LIMIT 5
Parameters:
[] |
|
4.26 ms (1.70%) |
1 |
SELECT t0.link_source AS link_source_1, t0.link_type AS link_type_2, t0.content AS content_3, t0.url AS url_4, t0.id AS id_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.deleted_at AS deleted_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.vendor_id AS vendor_id_11, t0.position AS position_12, t0.title AS title_13, t0.slug AS slug_14, t0.is_active AS is_active_15, t0.is_highlighted AS is_highlighted_16, t0.date AS date_17, t0.image AS image_18, t0.is_chart AS is_chart_19 FROM investor_press_release t0 WHERE t0.is_active = ? AND t0.link_type = ? ORDER BY t0.date DESC LIMIT 10
Parameters:
[ 1 "analysis" ] |
|
3.09 ms (1.24%) |
7 |
SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.updated_by AS updated_by_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.locale AS locale_7, t0.title AS title_8, t0.slug AS slug_9, t0.is_active AS is_active_10, t0.content AS content_11, t0.lead AS lead_12, t0.navigation_url AS navigation_url_13, t0.navigation_title AS navigation_title_14, t0.media AS media_15, t0.media_collection AS media_collection_16, t0.translatable_id AS translatable_id_17 FROM common_layout_slide_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
b"\x01É]³Í¥z~äAgF├q\v2"
]
|
|
2.41 ms (0.96%) |
4 |
SELECT t0.value AS value_1, t0.file AS file_2, t0.id AS id_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.deleted_at AS deleted_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM system_application_config_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
b"\x01ìB\x1F°e}\x17º:\x1Fð§oZ╬"
]
|
|
2.30 ms (0.92%) |
5 |
SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.updated_by AS updated_by_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.vendor_id AS vendor_id_7, t0.file AS file_8, t0.position AS position_9, t0.announcement_id AS announcement_id_10 FROM investor_document t0 WHERE t0.announcement_id = ?
Parameters:
[
b"\x01ƃ║ä¥wÁÜy\x18ð6îÉ▄"
]
|
|
2.26 ms (0.91%) |
1 |
SELECT c0_.is_director AS is_director_0, c0_.is_audit AS is_audit_1, c0_.is_supervisor AS is_supervisor_2, c0_.is_management AS is_management_3, c0_.is_trader AS is_trader_4, c0_.id AS id_5, c0_.created_by AS created_by_6, c0_.updated_by AS updated_by_7, c0_.deleted_at AS deleted_at_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.vendor_id AS vendor_id_11, c0_.image AS image_12, c0_.position AS position_13 FROM company_team c0_ INNER JOIN company_team_translation c1_ ON c0_.id = c1_.translatable_id WHERE c1_.is_active = 1 AND c1_.locale = ? AND c0_.is_director = 1 ORDER BY c0_.position ASC
Parameters:
[
"hu"
]
|
|
2.06 ms (0.83%) |
5 |
SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.updated_by AS updated_by_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.vendor_id AS vendor_id_7, t0.position AS position_8, t0.parent_id AS parent_id_9 FROM investor_announcement_category t0 WHERE t0.id = ?
Parameters:
[
b"\x01ì)\r├ï{\eØõmJ?àǃ"
]
|
|
2.01 ms (0.80%) |
6 |
SELECT t0.highlighted_category AS highlighted_category_1, t0.year AS year_2, t0.id AS id_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.deleted_at AS deleted_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.vendor_id AS vendor_id_9, t0.date AS date_10, t0.is_chart AS is_chart_11, t0.category_id AS category_id_12, t0.post_id AS post_id_13 FROM investor_announcement t0 WHERE t0.id = ?
Parameters:
[
b"\x01É]³\x19`\x7FcüÜNÆÇ½ÿ\x19"
]
|
|
1.89 ms (0.76%) |
4 |
SELECT t0.code AS code_1, t0.id AS id_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.deleted_at AS deleted_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.meta_id AS meta_id_8 FROM system_application t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"default"
]
|
|
1.67 ms (0.67%) |
1 |
SELECT t0.template AS template_1, t0.id AS id_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.deleted_at AS deleted_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.position AS position_8, t0.slider_id AS slider_id_9, t0.team_id AS team_id_10 FROM common_layout_block t0 INNER JOIN system_page_to_block ON t0.id = system_page_to_block.block_id WHERE system_page_to_block.page_id = ? ORDER BY t0.position ASC
Parameters:
[
b"\x01Œÿ\x18Þ¼v\x05²ÆÑ±WZÞ"
]
|
|
1.54 ms (0.62%) |
1 |
SELECT i0_.date AS date_0, i0_.id AS id_1, i0_.created_by AS created_by_2, i0_.updated_by AS updated_by_3, i0_.deleted_at AS deleted_at_4, i0_.created_at AS created_at_5, i0_.updated_at AS updated_at_6 FROM investor_event i0_ INNER JOIN investor_event_translation i1_ ON i0_.id = i1_.translatable_id WHERE i1_.locale = ? AND i0_.date >= ? AND i1_.is_active = 1 ORDER BY i0_.date ASC LIMIT 1
Parameters:
[ "hu" "2026-02-10 07:46:58" ] |
|
1.54 ms (0.62%) |
4 |
SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.updated_by AS updated_by_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.vendor_id AS vendor_id_7, t0.position AS position_8, t0.parent_id AS parent_id_9 FROM investor_announcement_category t0 WHERE t0.parent_id = ?
Parameters:
[
b"\x01ì)\r└½vSë\x10v\x7F¨c×]"
]
|
|
1.22 ms (0.49%) |
1 |
SELECT t0.quantity AS quantity_1, t0.color AS color_2, t0.id AS id_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.deleted_at AS deleted_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.vendor_id AS vendor_id_9, t0.title AS title_10, t0.slug AS slug_11, t0.is_active AS is_active_12 FROM investor_holder t0
Parameters:
[] |
|
1.03 ms (0.41%) |
1 |
SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.updated_by AS updated_by_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.position AS position_7, t0.announcement_id AS announcement_id_8 FROM common_layout_slide t0 INNER JOIN common_layout_slider_to_slide ON t0.id = common_layout_slider_to_slide.slide_id WHERE common_layout_slider_to_slide.slider_id = ? ORDER BY t0.position ASC
Parameters:
[
b"\x01ì\x04ä\x10üx(ü¡o4~Î,\x05"
]
|
|
0.97 ms (0.39%) |
1 |
SELECT t0.site_name AS site_name_1, t0.description AS description_2, t0.keywords AS keywords_3, t0.image AS image_4, t0.id AS id_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.deleted_at AS deleted_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.locale AS locale_11, t0.title AS title_12, t0.slug AS slug_13, t0.translatable_id AS translatable_id_14 FROM common_meta_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
b"\x01’lÓ!ƒtF’Íïc“áG"
]
|
|
0.94 ms (0.38%) |
1 |
SELECT i0_.id AS id_0, i0_.created_by AS created_by_1, i0_.updated_by AS updated_by_2, i0_.deleted_at AS deleted_at_3, i0_.created_at AS created_at_4, i0_.updated_at AS updated_at_5, i0_.vendor_id AS vendor_id_6, i0_.position AS position_7, i0_.parent_id AS parent_id_8 FROM investor_announcement_category i0_ INNER JOIN investor_announcement_category_translation i1_ ON i0_.id = i1_.translatable_id WHERE i0_.parent_id IS NULL AND i1_.is_active = 1 AND i1_.deleted_at IS NULL AND i1_.locale = ? ORDER BY i0_.position ASC
Parameters:
[
"hu"
]
|
|
0.94 ms (0.38%) |
1 |
SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.updated_by AS updated_by_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.locale AS locale_7, t0.title AS title_8, t0.slug AS slug_9, t0.is_active AS is_active_10, t0.content AS content_11, t0.translatable_id AS translatable_id_12 FROM system_page_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
b"\x01Œÿ\x18Þ¼v\x05²ÆÑ±WZÞ"
]
|
|
0.87 ms (0.35%) |
1 |
SELECT t0.link_source AS link_source_1, t0.link_type AS link_type_2, t0.content AS content_3, t0.url AS url_4, t0.id AS id_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.deleted_at AS deleted_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.vendor_id AS vendor_id_11, t0.position AS position_12, t0.title AS title_13, t0.slug AS slug_14, t0.is_active AS is_active_15, t0.is_highlighted AS is_highlighted_16, t0.date AS date_17, t0.image AS image_18, t0.is_chart AS is_chart_19 FROM investor_press_release t0 WHERE t0.is_active = ? AND t0.link_type = ? ORDER BY t0.date DESC LIMIT 5
Parameters:
[ 1 "news" ] |
|
0.77 ms (0.31%) |
3 |
SELECT t0.remote_url AS remote_url_1, t0.id AS id_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.deleted_at AS deleted_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.locale AS locale_8, t0.title AS title_9, t0.slug AS slug_10, t0.is_active AS is_active_11, t0.content AS content_12, t0.image AS image_13, t0.translatable_id AS translatable_id_14 FROM industry_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
b"\x01Œÿ‹\x1DfsF•\x12ÇÓ1p-!"
]
|
|
0.76 ms (0.30%) |
1 |
SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.updated_by AS updated_by_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.color AS color_7, t0.leader_id AS leader_id_8, t0.meta_id AS meta_id_9 FROM industry t0
Parameters:
[] |
|
0.73 ms (0.29%) |
1 |
SELECT t0.code AS code_1, t0.route_name AS route_name_2, t0.id AS id_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.deleted_at AS deleted_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.meta_id AS meta_id_9 FROM system_page t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"investor_show"
]
|
|
0.70 ms (0.28%) |
1 |
SELECT c0_.is_director AS is_director_0, c0_.is_audit AS is_audit_1, c0_.is_supervisor AS is_supervisor_2, c0_.is_management AS is_management_3, c0_.is_trader AS is_trader_4, c0_.id AS id_5, c0_.created_by AS created_by_6, c0_.updated_by AS updated_by_7, c0_.deleted_at AS deleted_at_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.vendor_id AS vendor_id_11, c0_.image AS image_12, c0_.position AS position_13 FROM company_team c0_ INNER JOIN company_team_translation c1_ ON c0_.id = c1_.translatable_id WHERE c1_.is_active = 1 AND c1_.locale = ? AND c0_.is_management = 1 ORDER BY c0_.position ASC
Parameters:
[
"hu"
]
|
|
0.61 ms (0.24%) |
1 |
SELECT t0.config_key AS config_key_1, t0.id AS id_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.deleted_at AS deleted_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.application_id AS application_id_8 FROM system_application_config t0 WHERE t0.application_id = ?
Parameters:
[
b"\x01Œô”ŒäqY³fgçÍÙoÎ"
]
|
|
0.59 ms (0.23%) |
1 |
SELECT c0_.is_director AS is_director_0, c0_.is_audit AS is_audit_1, c0_.is_supervisor AS is_supervisor_2, c0_.is_management AS is_management_3, c0_.is_trader AS is_trader_4, c0_.id AS id_5, c0_.created_by AS created_by_6, c0_.updated_by AS updated_by_7, c0_.deleted_at AS deleted_at_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.vendor_id AS vendor_id_11, c0_.image AS image_12, c0_.position AS position_13 FROM company_team c0_ INNER JOIN company_team_translation c1_ ON c0_.id = c1_.translatable_id WHERE c1_.is_active = 1 AND c1_.locale = ? AND c0_.is_audit = 1 ORDER BY c0_.position ASC
Parameters:
[
"hu"
]
|
|
0.51 ms (0.20%) |
1 |
SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.updated_by AS updated_by_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM common_meta t0 WHERE t0.id = ?
Parameters:
[
b"\x01’lÓ!ƒtF’Íïc“áG"
]
|
|
0.48 ms (0.19%) |
1 |
SELECT MIN(i0_.year) AS sclr_0, MAX(i0_.year) AS sclr_1 FROM investor_announcement i0_
Parameters:
[] |
|
0.43 ms (0.17%) |
1 |
SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.updated_by AS updated_by_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM common_layout_slider t0 WHERE t0.id = ?
Parameters:
[
b"\x01ì\x04ä\x10üx(ü¡o4~Î,\x05"
]
|
|
0.34 ms (0.14%) |
1 |
SELECT c0_.is_director AS is_director_0, c0_.is_audit AS is_audit_1, c0_.is_supervisor AS is_supervisor_2, c0_.is_management AS is_management_3, c0_.is_trader AS is_trader_4, c0_.id AS id_5, c0_.created_by AS created_by_6, c0_.updated_by AS updated_by_7, c0_.deleted_at AS deleted_at_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.vendor_id AS vendor_id_11, c0_.image AS image_12, c0_.position AS position_13 FROM company_team c0_ INNER JOIN company_team_translation c1_ ON c0_.id = c1_.translatable_id WHERE c1_.is_active = 1 AND c1_.locale = ? AND c0_.is_supervisor = 1 ORDER BY c0_.position ASC
Parameters:
[
"hu"
]
|
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.