GET https://dev.gloster.hu/rolunk

Query Metrics

57 Database Queries
18 Different statements
112.74 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
75.18 ms
(66.68%)
11
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î¶ó¦Ay®░@Oì9\x10╩│"
]
15.42 ms
(13.68%)
13
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.image AS image_11, t0.content AS content_12, t0.translatable_id AS translatable_id_13 FROM company_history_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  b"\x01ì3\x08\x1AÞ\x7FÁ╝ ùæ╝è£ "
]
5.20 ms
(4.61%)
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
    """
]
4.34 ms
(3.85%)
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Œô¡=Àr\x07¬þòÕ\x1Aë&\x19"
]
2.33 ms
(2.07%)
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"
]
1.77 ms
(1.57%)
2
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╬"
]
1.64 ms
(1.45%)
1
SELECT t0.year AS year_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 FROM company_history t0
Parameters:
[]
1.23 ms
(1.09%)
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.95 ms
(0.84%)
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:
[
  "about_us"
]
0.82 ms
(0.72%)
2
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"
]
0.80 ms
(0.71%)
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"
]
0.69 ms
(0.61%)
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"
]
0.52 ms
(0.46%)
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Œô¡=Àr\x07¬þòÕ\x1Aë&\x19"
]
0.48 ms
(0.43%)
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.45 ms
(0.40%)
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.42 ms
(0.37%)
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.27 ms
(0.24%)
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.23 ms
(0.20%)
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Î"
]

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.