Query Metrics
38
Database Queries
11
Different statements
56.00 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 4.27 ms |
SELECT p0_.id_lang AS id_lang_0, p0_.name AS name_1, p0_.active AS active_2, p0_.iso_code AS iso_code_3, p0_.language_code AS language_code_4, p0_.date_format_lite AS date_format_lite_5, p0_.date_format_full AS date_format_full_6, p0_.dictionary AS dictionary_7, p0_.currency_format AS currency_format_8, p0_.iso_code_real AS iso_code_real_9, p0_.name_english AS name_english_10 FROM ps_lang p0_ WHERE p0_.iso_code = ?
Parameters:
[
"cs"
]
|
| 2 | 0.98 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.id_lang = ?
Parameters:
[
1
]
|
| 3 | 0.81 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.id_lang = ?
Parameters:
[
4
]
|
| 4 | 0.71 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.id_lang = ?
Parameters:
[
5
]
|
| 5 | 0.73 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.id_lang = ?
Parameters:
[
6
]
|
| 6 | 0.56 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.id_lang = ?
Parameters:
[
7
]
|
| 7 | 0.53 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.id_lang = ?
Parameters:
[
8
]
|
| 8 | 0.45 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.id_lang = ?
Parameters:
[
9
]
|
| 9 | 0.44 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.id_lang = ?
Parameters:
[
10
]
|
| 10 | 0.43 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.id_lang = ?
Parameters:
[
11
]
|
| 11 | 0.38 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.id_lang = ?
Parameters:
[
12
]
|
| 12 | 0.40 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.id_lang = ?
Parameters:
[
13
]
|
| 13 | 0.40 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.id_lang = ?
Parameters:
[
14
]
|
| 14 | 0.41 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.id_lang = ?
Parameters:
[
15
]
|
| 15 | 0.38 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.id_lang = ?
Parameters:
[
16
]
|
| 16 | 0.36 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.id_lang = ?
Parameters:
[
18
]
|
| 17 | 0.36 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.id_lang = ?
Parameters:
[
19
]
|
| 18 | 0.37 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.id_lang = ?
Parameters:
[
20
]
|
| 19 | 0.33 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.id_lang = ?
Parameters:
[
21
]
|
| 20 | 0.36 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.id_lang = ?
Parameters:
[
22
]
|
| 21 | 0.41 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.id_lang = ?
Parameters:
[
24
]
|
| 22 | 0.40 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.id_lang = ?
Parameters:
[
25
]
|
| 23 | 0.33 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.id_lang = ?
Parameters:
[
26
]
|
| 24 | 0.35 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.id_lang = ?
Parameters:
[
27
]
|
| 25 | 15.17 ms |
SELECT p0_.id_cms AS sclr_0, p1_.id_lang AS id_lang_1, p0_.link_rewrite AS link_rewrite_2 FROM ps_cms_lang p0_ INNER JOIN ps_lang p1_ ON p0_.id_lang = p1_.id_lang
Parameters:
[] |
| 26 | 0.91 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.iso_code = ? LIMIT 1
Parameters:
[
"cs"
]
|
| 27 | 8.92 ms |
SELECT m0_.id AS id_0, m0_.parent AS sclr_1, m0_.link_type AS link_type_2, m0_.link_value AS link_value_3, m0_.tag AS tag_4, m0_.number_columns AS number_columns_5, m0_.colspan AS colspan_6, m0_.additional AS additional_7, m0_.icon AS icon_8, m0_.target AS target_9, IF(m1_.title IS NULL OR m1_.title = '', IF(m2_.title IS NULL OR m2_.title = '', IF(m3_.title IS NULL OR m3_.title = '', '', m3_.title), m2_.title), m1_.title) AS sclr_10, IF(m1_.subtitle IS NULL OR m1_.subtitle = '', IF(m2_.subtitle IS NULL OR m2_.subtitle = '', IF(m3_.subtitle IS NULL OR m3_.subtitle = '', '', m3_.subtitle), m2_.subtitle), m1_.subtitle) AS sclr_11 FROM menu_item m0_ LEFT JOIN menu_item_lang m1_ ON m0_.id = m1_.menu_item_id AND (m1_.language_id = ?) LEFT JOIN menu_item_lang m2_ ON m0_.id = m2_.menu_item_id AND (m2_.language_id = 1) LEFT JOIN menu_item_lang m3_ ON m0_.id = m3_.menu_item_id AND (m3_.language_id = 4) WHERE m0_.menu_id = ? AND m0_.visibility = ? ORDER BY m0_.position ASC
Parameters:
[ 28 1 1 ] |
| 28 | 0.70 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0
Parameters:
[] |
| 29 | 0.83 ms |
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.name AS name_4, t0.meta_keywords AS meta_keywords_5, t0.content AS content_6, t0.link_rewrite AS link_rewrite_7, t0.redirect AS redirect_8, t0.id_cms AS id_cms_9, t0.id_lang AS id_lang_10 FROM ps_cms_lang t0 WHERE t0.link_rewrite = ? LIMIT 1
Parameters:
[ "" ] |
| 30 | 0.71 ms |
SELECT p0_.id_lang AS id_lang_0, p0_.name AS name_1, p0_.iso_code AS iso_code_2, p0_.iso_code_real AS iso_code_real_3 FROM ps_lang p0_ WHERE p0_.active = 1
Parameters:
[] |
| 31 | 0.71 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.iso_code = ? LIMIT 1
Parameters:
[
"cs"
]
|
| 32 | 2.44 ms |
SELECT m0_.id AS id_0, m0_.parent AS sclr_1, m0_.link_type AS link_type_2, m0_.link_value AS link_value_3, m0_.tag AS tag_4, m0_.number_columns AS number_columns_5, m0_.colspan AS colspan_6, m0_.additional AS additional_7, m0_.icon AS icon_8, m0_.target AS target_9, IF(m1_.title IS NULL OR m1_.title = '', IF(m2_.title IS NULL OR m2_.title = '', IF(m3_.title IS NULL OR m3_.title = '', '', m3_.title), m2_.title), m1_.title) AS sclr_10, IF(m1_.subtitle IS NULL OR m1_.subtitle = '', IF(m2_.subtitle IS NULL OR m2_.subtitle = '', IF(m3_.subtitle IS NULL OR m3_.subtitle = '', '', m3_.subtitle), m2_.subtitle), m1_.subtitle) AS sclr_11 FROM menu_item m0_ LEFT JOIN menu_item_lang m1_ ON m0_.id = m1_.menu_item_id AND (m1_.language_id = ?) LEFT JOIN menu_item_lang m2_ ON m0_.id = m2_.menu_item_id AND (m2_.language_id = 1) LEFT JOIN menu_item_lang m3_ ON m0_.id = m3_.menu_item_id AND (m3_.language_id = 4) WHERE m0_.menu_id = ? AND m0_.visibility = ? ORDER BY m0_.position ASC
Parameters:
[ 28 2 1 ] |
| 33 | 0.61 ms |
SELECT p0_.id_lang AS id_lang_0, p0_.name AS name_1, p0_.iso_code AS iso_code_2, p0_.iso_code_real AS iso_code_real_3 FROM ps_lang p0_ WHERE p0_.active = 1
Parameters:
[] |
legacy connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 4.87 ms |
SELECT tc.id_tickets_category,tc.id_tickets_category_parent,tc.public_id,tcl.name,tcl_en.name as name_en,tcl.name,tcl.description,tct.name as type_name, tc.id_hs_pipeline, tc.id_hs_pipeline_stage, tc.id_hs_category FROM ps_tickets_category as tc INNER JOIN ps_tickets_category_lang as tcl ON tcl.id_tickets_category = tc.id_tickets_category AND tcl.id_lang = :id_lang LEFT JOIN ps_tickets_category_lang as tcl_en ON tcl_en.id_tickets_category = tc.id_tickets_category AND tcl_en.id_lang = 1 INNER JOIN ps_tickets_category_type as tct ON tct.id_tickets_category_type = tc.id_type AND tct.id_lang = tcl.id_lang WHERE tc.id_tickets_category_parent = :id_parent AND tc.id_form = :id_form
Parameters:
[ ":id_lang" => 28 ":id_parent" => 0 ":id_form" => 0 ] |
| 2 | 1.76 ms |
SELECT value FROM ps_configuration WHERE name = :name
Parameters:
[ ":name" => "JS_COMPRESSION" ] |
| 3 | 0.83 ms |
SELECT value FROM ps_configuration WHERE name = :name
Parameters:
[ ":name" => "CSS_COMPRESSION" ] |
| 4 | 1.56 ms |
SELECT * FROM `ps_lang`
Parameters:
[] |
| 5 | 0.83 ms |
SELECT value FROM ps_configuration WHERE name = :name
Parameters:
[ ":name" => "ACADEMY_AVAILABLE_LANGS" ] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| report | doctrine.dbal.report_connection |
| logs | doctrine.dbal.logs_connection |
Entity Managers
| Name | Service |
|---|---|
| auto_generate_proxy_classes | doctrine.orm.auto_generate_proxy_classes_entity_manager |
| default | doctrine.orm.default_entity_manager |
| report | doctrine.orm.report_entity_manager |
| logs | doctrine.orm.logs_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
auto_generate_proxy_classes entity manager
No loaded entities.
default entity manager
report entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Report\CustomerAuthenticationAccessControl | No errors. |
| App\Entity\Report\CustomerAuthenticationAccessControlLog | No errors. |
logs entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Logs\CustomerExternalReferer | No errors. |
| App\Entity\Logs\AdyenPaymentLink | No errors. |