Query Metrics
22
Database Queries
12
Different statements
36.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
14.83 ms (40.44%) |
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"
]
|
|
7.15 ms (19.50%) |
7 |
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ì!²┴¤}¯¢\x04Ä¥█9qy"
]
|
|
2.53 ms (6.91%) |
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_.color AS color_6, i0_.leader_id AS leader_id_7, i0_.meta_id AS meta_id_8 FROM industry i0_ LEFT JOIN industry_translation i1_ ON i0_.id = i1_.translatable_id WHERE i1_.slug = ? AND i1_.locale = ? LIMIT 1
Parameters:
[ "rendszerintegracio" "hu" ] |
|
2.29 ms (6.23%) |
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"
]
|
|
2.15 ms (5.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 industry_to_block ON t0.id = industry_to_block.block_id WHERE industry_to_block.industry_id = ? ORDER BY t0.position ASC
Parameters:
[
b"\x01Œÿ’9Utr Üü¶\x12lkO"
]
|
|
1.65 ms (4.50%) |
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Œÿ’9Utr Üü¶\x12lkO"
]
|
|
1.55 ms (4.23%) |
1 |
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ì+û╣BwÈÂ\x18┤íüüF£"
]
|
|
1.41 ms (3.85%) |
1 |
SELECT t0.is_director AS is_director_1, t0.is_audit AS is_audit_2, t0.is_supervisor AS is_supervisor_3, t0.is_management AS is_management_4, t0.is_trader AS is_trader_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.image AS image_13, t0.position AS position_14 FROM company_team t0 WHERE t0.id = ?
Parameters:
[
b"\x01ì+û╣BwÈÂ\x18┤íüüF£"
]
|
|
1.35 ms (3.69%) |
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.00 ms (2.73%) |
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.43 ms (1.16%) |
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.34 ms (0.91%) |
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Shared\AbstractEntity | No errors. |
| App\Entity\Shared\AbstractTranslatableEntity | No errors. |
| App\Entity\Industry\Industry | No errors. |
| App\Entity\Shared\AbstractTranslationEntity | No errors. |
| App\Entity\Industry\IndustryTranslation | No errors. |
| App\Entity\Company\Team\Team | No errors. |
| App\Entity\Common\Meta\Meta | No errors. |
| App\Entity\Common\Layout\Block | No errors. |
| App\Entity\Common\Layout\Slider\Slider | 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\Team\TeamTranslation | No errors. |
| App\Entity\Common\Layout\Slider\Slide | No errors. |
| App\Entity\Common\Layout\Slider\SliderTranslation | No errors. |