Query Metrics
18
Database Queries
9
Different statements
10.87 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.58 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"language_settings"
]
|
| 2 | 0.42 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"AnalyticalPlatforms"
]
|
| 3 | 0.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"group_registration"
]
|
| 4 | 0.47 ms |
SELECT t0.id AS id_1, t0.order_number AS order_number_2, t0.registration_limit AS registration_limit_3, t0.hidden AS hidden_4, t0.password AS password_5, t0.show_for_languages AS show_for_languages_6, t0.hash AS hash_7, t0.template_id AS template_id_8 FROM ticket t0 WHERE t0.id = ?
Parameters:
[
0
]
|
| 5 | 0.38 ms |
SELECT t0.id AS id_1, t0.redirect AS redirect_2, t0.parent_id AS parent_id_3, t0.list_order AS list_order_4, t0.is_homepage AS is_homepage_5, t0.is_visible AS is_visible_6, t0.has_banner AS has_banner_7, t0.has_regform AS has_regform_8, t0.is_in_menu AS is_in_menu_9, t0.url AS url_10, t0.title AS title_11, t0.content AS content_12, t0.main_css AS main_css_13, t0.section_css AS section_css_14, t0.locale AS locale_15 FROM PAGE t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
"/robots.txt"
]
|
| 6 | 0.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"event_settings"
]
|
| 7 | 0.42 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM setting_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
6
]
|
| 8 | 0.47 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.enabled AS enabled_3 FROM currency c0_ WHERE c0_.enabled = 1
Parameters:
[] |
| 9 | 0.39 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"BrandingSettings"
]
|
| 10 | 0.48 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"cookies_settings"
]
|
| 11 | 2.39 ms |
SELECT a0_.id AS id_0, a0_.type AS type_1, a0_.content AS content_2, a0_.add_date AS add_date_3 FROM additional_frontend_code a0_ WHERE a0_.type = ? ORDER BY a0_.add_date DESC LIMIT 1
Parameters:
[
"header"
]
|
| 12 | 0.70 ms |
SELECT a0_.id AS id_0, a0_.type AS type_1, a0_.content AS content_2, a0_.add_date AS add_date_3 FROM additional_frontend_code a0_ WHERE a0_.type = ? ORDER BY a0_.add_date DESC LIMIT 1
Parameters:
[
"footer"
]
|
| 13 | 0.56 ms |
SELECT t0.id AS id_1, t0.redirect AS redirect_2, t0.parent_id AS parent_id_3, t0.list_order AS list_order_4, t0.is_homepage AS is_homepage_5, t0.is_visible AS is_visible_6, t0.has_banner AS has_banner_7, t0.has_regform AS has_regform_8, t0.is_in_menu AS is_in_menu_9, t0.url AS url_10, t0.title AS title_11, t0.content AS content_12, t0.main_css AS main_css_13, t0.section_css AS section_css_14, t0.locale AS locale_15 FROM PAGE t0 WHERE t0.is_homepage = ?
Parameters:
[
1
]
|
| 14 | 0.55 ms |
SELECT t0.id AS id_1, t0.redirect AS redirect_2, t0.parent_id AS parent_id_3, t0.list_order AS list_order_4, t0.is_homepage AS is_homepage_5, t0.is_visible AS is_visible_6, t0.has_banner AS has_banner_7, t0.has_regform AS has_regform_8, t0.is_in_menu AS is_in_menu_9, t0.url AS url_10, t0.title AS title_11, t0.content AS content_12, t0.main_css AS main_css_13, t0.section_css AS section_css_14, t0.locale AS locale_15 FROM PAGE t0 WHERE t0.locale = ? ORDER BY t0.list_order ASC
Parameters:
[
"pl"
]
|
| 15 | 0.52 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"social_media"
]
|
| 16 | 0.50 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.language AS language_3, t0.value AS value_4 FROM translation t0 WHERE t0.name = ? AND t0.language = ? LIMIT 1
Parameters:
[ "cookies_text" "pl" ] |
| 17 | 0.76 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.language AS language_3, t0.value AS value_4 FROM translation t0 WHERE t0.name = ? AND t0.language = ? LIMIT 1
Parameters:
[ "cookies_accept" "pl" ] |
| 18 | 0.58 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.language AS language_3, t0.value AS value_4 FROM translation t0 WHERE t0.name = ? AND t0.language = ? LIMIT 1
Parameters:
[ "cookies_accept_required" "pl" ] |
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\Core\Doctrine\Entity\Setting\Setting | No errors. |
| App\Core\Doctrine\Entity\Setting\SettingTranslation | No errors. |
| App\Core\Doctrine\Entity\Ticket\Ticket | No errors. |
| App\Core\Doctrine\Entity\TicketTemplate\TicketTemplate | No errors. |
| App\Core\Doctrine\Entity\Page\Page | No errors. |
| App\Core\Doctrine\Entity\Payment\Currency | No errors. |
| App\Core\Doctrine\Entity\Setting\AdditionalFrontendCode | No errors. |
| App\Core\Doctrine\Entity\Translation\Translation | No errors. |