Query Metrics
31
Database Queries
17
Different statements
106.97 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.32 ms |
SELECT c0_.id AS id_0, c0_.created_by AS created_by_1, c0_.updated_by AS updated_by_2, c0_.deleted_at AS deleted_at_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.partner_id AS partner_id_6, c0_.service_id AS service_id_7, c0_.meta_id AS meta_id_8 FROM case_study c0_ LEFT JOIN case_study_translation c1_ ON c0_.id = c1_.translatable_id WHERE c1_.slug = ? AND c1_.locale = ? AND c1_.deleted_at IS NULL AND c1_.is_active = 1 LIMIT 1
Parameters:
[ "orvosi-masodvelemeny-piacter" "hu" ] |
| 2 | 0.90 ms |
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 case_study_to_block ON t0.id = case_study_to_block.block_id WHERE case_study_to_block.case_study_id = ? ORDER BY t0.position ASC
Parameters:
[
b"\x01ì-v§^p‗黵\x7FI`r█"
]
|
| 3 | 1.51 ms |
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ì-x8┤yPÿRú¥D¡7Æ"
]
|
| 4 | 0.73 ms |
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ì-x▀Uw\x19½╚SÃsÂl¹"
]
|
| 5 | 0.65 ms |
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ì-|\f'{Nƒ\x13┴V■\x00ÃL"
]
|
| 6 | 77.06 ms |
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ì;p\x19_päÆÚÁØ\x13\x1Aù§"
]
|
| 7 | 0.69 ms |
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ì-~\x07ØykïÖ╬âÏly|"
]
|
| 8 | 0.47 ms |
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ì-~\x07ØykïÖ╬â█\x18£+"
]
|
| 9 | 0.89 ms |
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ì-~÷æxcì]¦┬Fq¥B"
]
|
| 10 | 0.78 ms |
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ì-\x7Fåï~(ÅLË╔╦õ╝à"
]
|
| 11 | 0.62 ms |
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"
]
|
| 12 | 0.53 ms |
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"
]
|
| 13 | 0.51 ms |
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"
]
|
| 14 | 0.80 ms |
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"
]
|
| 15 | 1.49 ms |
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Î"
]
|
| 16 | 0.77 ms |
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╬"
]
|
| 17 | 1.74 ms |
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©\n
\x7Fª▒ôıHådkq
"""
]
|
| 18 | 1.92 ms |
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.meta_id AS meta_id_7 FROM service t0 WHERE t0.id = ?
Parameters:
[
b"\x01Œÿ•ñzw®»$hƒoù‡Â"
]
|
| 19 | 0.55 ms |
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.image AS image_12, t0.acronym AS acronym_13, t0.lead AS lead_14, t0.translatable_id AS translatable_id_15 FROM service_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
b"\x01Œÿ•ñzw®»$hƒoù‡Â"
]
|
| 20 | 0.58 ms |
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.meta_id AS meta_id_7 FROM company_partner t0 WHERE t0.id = ?
Parameters:
[
b"\x01ì+ýo7{õÿ§#3╦▓u$"
]
|
| 21 | 4.55 ms |
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.is_highlighted AS is_highlighted_11, t0.image AS image_12, t0.translatable_id AS translatable_id_13 FROM company_partner_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
b"\x01ì+ýo7{õÿ§#3╦▓u$"
]
|
| 22 | 0.61 ms |
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.lead AS lead_12, t0.translatable_id AS translatable_id_13 FROM case_study_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
b"\x01ì-v§^p‗黵\x7FI`r█"
]
|
| 23 | 1.15 ms |
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.image AS image_7, t0.meta_id AS meta_id_8 FROM technology t0 INNER JOIN case_study_to_technology ON t0.id = case_study_to_technology.technology_id WHERE case_study_to_technology.case_study_id = ?
Parameters:
[
b"\x01ì-v§^p‗黵\x7FI`r█"
]
|
| 24 | 1.20 ms |
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 technology_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
b"\x01ì+┤à£u{¢ü╚Õ"▄·~"
]
|
| 25 | 0.54 ms |
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 technology_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
b"\x01ì+┤ìlp\f╝#Á6Ï\x06àô"
]
|
| 26 | 0.44 ms |
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 technology_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
b"\x01ì+┤Ñ┐}rï¸Òç¼øôÿ"
]
|
| 27 | 0.40 ms |
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 technology_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
b"\x01ì+┤╠erÅí\tÇn_l@╗"
]
|
| 28 | 0.49 ms |
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:
[] |
| 29 | 0.78 ms |
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-!"
]
|
| 30 | 0.63 ms |
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Œÿ’9Utr Üü¶\x12lkO"
]
|
| 31 | 0.64 ms |
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î ô5ÎqZü¼┴O\x06jC\x03"
]
|
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.