GET https://dev.gloster.hu/_fragment?_path=_format%3Dhtml%26_locale%3Dhu%26_controller%3DApp%255CController%255CApplication%255CApplicationController%253A%253Afoote…

Response
200 OK
IP
185.51.191.61
Profiled on
Token
137f55

Query Metrics

31 Database Queries
17 Different statements
76.74 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 1.90 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: 
[
  "skalazhato-it-infrastruktura"
  "hu"
]
View formatted query    View runnable query    Explain query
2 1.36 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ì,ÓÅt}ãàCI§ò©/)"
]
View formatted query    View runnable query    Explain query
3 1.86 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ì,õ╠(t·ôJ©þ4§Íê"
]
View formatted query    View runnable query    Explain query
4 1.20 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ì,Ú4\x04r\x12á▒╬Oâ\x04Ê­"
]
View formatted query    View runnable query    Explain query
5 1.18 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ì,Ú4\x05|à®ë4ô×?\x19?"
]
View formatted query    View runnable query    Explain query
6 0.75 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ì,ý\x0EØx2ÂG,\x7F}ç½\x13"
]
View formatted query    View runnable query    Explain query
7 0.77 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ì,¯aß{£½üûS\x07Áï\t"
]
View formatted query    View runnable query    Explain query
8 0.85 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ì,´q¤p;╗.ƒ£UÆ\x19v"
]
View formatted query    View runnable query    Explain query
9 11.51 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"
]
View formatted query    View runnable query    Explain query
10 0.75 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"
]
View formatted query    View runnable query    Explain query
11 0.78 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"
]
View formatted query    View runnable query    Explain query
12 0.59 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"
]
View formatted query    View runnable query    Explain query
13 2.45 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Î"
]
View formatted query    View runnable query    Explain query
14 0.53 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╬"
]
View formatted query    View runnable query    Explain query
15 0.54 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
    """
]
View formatted query    View runnable query    Explain query
16 0.60 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ì+Í■Æq╦¼Ð\x015Â4ûº"
]
View formatted query    View runnable query    Explain query
17 1.18 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ì+Í■Æq╦¼Ð\x015Â4ûº"
]
View formatted query    View runnable query    Explain query
18 1.62 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ì+Ùü³{Mø‗-╚\x19ú*\x02"
]
View formatted query    View runnable query    Explain query
19 3.89 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ì+Ùü³{Mø‗-╚\x19ú*\x02"
]
View formatted query    View runnable query    Explain query
20 0.99 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ì,ÓÅt}ãàCI§ò©/)"
]
View formatted query    View runnable query    Explain query
21 12.14 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ì,ÓÅt}ãàCI§ò©/)"
]
View formatted query    View runnable query    Explain query
22 7.23 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ì+┤ï|t Ñ-\x1AiA·¼1"
]
View formatted query    View runnable query    Explain query
23 4.32 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ì+┤æ%z\x14úç\t\x12+ìm§"
]
View formatted query    View runnable query    Explain query
24 2.37 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ì+┤Öâvf¢ÓÉ9Õ\tUÄ"
]
View formatted query    View runnable query    Explain query
25 0.59 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ì+┤øÂy*ç@>\x15`\x1Aö\"
]
View formatted query    View runnable query    Explain query
26 3.47 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ì+┤Ø╠píÅ░ô;a _Y"
]
View formatted query    View runnable query    Explain query
27 7.65 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ì+┤ƒ¤\x7F\x01╗üÁDÚÅB©"
]
View formatted query    View runnable query    Explain query
28 0.47 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: 
[]
View formatted query    View runnable query    Explain query
29 2.36 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-!"
]
View formatted query    View runnable query    Explain query
30 0.47 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"
]
View formatted query    View runnable query    Explain query
31 0.38 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"
]
View formatted query    View runnable query    Explain query

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\Shared\AbstractEntity No errors.
App\Entity\Shared\AbstractTranslatableEntity No errors.
App\Entity\CaseStudy\CaseStudy No errors.
App\Entity\Shared\AbstractTranslationEntity No errors.
App\Entity\CaseStudy\CaseStudyTranslation No errors.
App\Entity\Company\Partner\Partner No errors.
App\Entity\Service\Service No errors.
App\Entity\Common\Meta\Meta No errors.
App\Entity\Technology\Technology No errors.
App\Entity\Common\Layout\Block No errors.
App\Entity\Common\Layout\Slider\Slider No errors.
App\Entity\Company\Team\Team No errors.
App\Entity\Common\Layout\BlockTranslation No errors.
App\Entity\System\Application\Application No errors.
App\Entity\System\Application\Config No errors.
App\Entity\System\Application\ApplicationTranslation No errors.
App\Entity\Common\Meta\MetaTranslation No errors.
App\Entity\System\Application\ConfigTranslation No errors.
App\Entity\Company\Partner\PartnerTranslation No errors.
App\Entity\Service\ServiceTranslation No errors.
App\Entity\Technology\TechnologyTranslation No errors.
App\Entity\Common\Layout\Slider\Slide No errors.
App\Entity\Common\Layout\Slider\SliderTranslation No errors.
App\Entity\Industry\Industry No errors.
App\Entity\Company\Team\TeamTranslation No errors.
App\Entity\Industry\IndustryTranslation No errors.