| 1 |
0.83 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 2 |
3.25 ms |
INSERT INTO hw_log (request_time, request_body, response_time, response_body, url) VALUES (?, ?, ?, ?, ?)
Parameters: [
"2025-12-06 05:01:57"
"Testing testing"
"2025-12-06 05:01:57"
"Reponseee"
"app_lna"
]
INSERT INTO hw_log (request_time, request_body, response_time, response_body, url) VALUES ('2025-12-06 05:01:57', 'Testing testing', '2025-12-06 05:01:57', 'Reponseee', 'app_lna');
|
| 3 |
6.00 ms |
"COMMIT"
|
| 4 |
2.30 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.visible AS visible_3, t0.parent_id AS parent_id_4, t0.sort_index AS sort_index_5, t0.type AS type_6, t0.content_id AS content_id_7, t0.lang AS lang_8, t0.external_url AS external_url_9 FROM menu t0 WHERE t0.lang = ? AND t0.parent_id = ? AND t0.visible = ? ORDER BY t0.sort_index ASC
SELECT t0.id AS id_1, t0.title AS title_2, t0.visible AS visible_3, t0.parent_id AS parent_id_4, t0.sort_index AS sort_index_5, t0.type AS type_6, t0.content_id AS content_id_7, t0.lang AS lang_8, t0.external_url AS external_url_9 FROM menu t0 WHERE t0.lang = 'lv' AND t0.parent_id = 0 AND t0.visible = 1 ORDER BY t0.sort_index ASC;
|
| 5 |
0.91 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.visible AS visible_3, t0.parent_id AS parent_id_4, t0.sort_index AS sort_index_5, t0.type AS type_6, t0.content_id AS content_id_7, t0.lang AS lang_8, t0.external_url AS external_url_9 FROM menu t0 WHERE t0.lang = ? AND t0.parent_id = ? AND t0.visible = ? ORDER BY t0.sort_index ASC
SELECT t0.id AS id_1, t0.title AS title_2, t0.visible AS visible_3, t0.parent_id AS parent_id_4, t0.sort_index AS sort_index_5, t0.type AS type_6, t0.content_id AS content_id_7, t0.lang AS lang_8, t0.external_url AS external_url_9 FROM menu t0 WHERE t0.lang = 'lv' AND t0.parent_id = 1 AND t0.visible = 1 ORDER BY t0.sort_index ASC;
|
| 6 |
0.76 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.visible AS visible_3, t0.parent_id AS parent_id_4, t0.sort_index AS sort_index_5, t0.type AS type_6, t0.content_id AS content_id_7, t0.lang AS lang_8, t0.external_url AS external_url_9 FROM menu t0 WHERE t0.lang = ? AND t0.parent_id = ? AND t0.visible = ? ORDER BY t0.sort_index ASC
SELECT t0.id AS id_1, t0.title AS title_2, t0.visible AS visible_3, t0.parent_id AS parent_id_4, t0.sort_index AS sort_index_5, t0.type AS type_6, t0.content_id AS content_id_7, t0.lang AS lang_8, t0.external_url AS external_url_9 FROM menu t0 WHERE t0.lang = 'lv' AND t0.parent_id = 9 AND t0.visible = 1 ORDER BY t0.sort_index ASC;
|
| 7 |
0.79 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.visible AS visible_3, t0.parent_id AS parent_id_4, t0.sort_index AS sort_index_5, t0.type AS type_6, t0.content_id AS content_id_7, t0.lang AS lang_8, t0.external_url AS external_url_9 FROM menu t0 WHERE t0.lang = ? AND t0.parent_id = ? AND t0.visible = ? ORDER BY t0.sort_index ASC
Parameters: [
"lv"
14
1
]
SELECT t0.id AS id_1, t0.title AS title_2, t0.visible AS visible_3, t0.parent_id AS parent_id_4, t0.sort_index AS sort_index_5, t0.type AS type_6, t0.content_id AS content_id_7, t0.lang AS lang_8, t0.external_url AS external_url_9 FROM menu t0 WHERE t0.lang = 'lv' AND t0.parent_id = 14 AND t0.visible = 1 ORDER BY t0.sort_index ASC;
|
| 8 |
0.60 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.visible AS visible_3, t0.parent_id AS parent_id_4, t0.sort_index AS sort_index_5, t0.type AS type_6, t0.content_id AS content_id_7, t0.lang AS lang_8, t0.external_url AS external_url_9 FROM menu t0 WHERE t0.lang = ? AND t0.parent_id = ? AND t0.visible = ? ORDER BY t0.sort_index ASC
Parameters: [
"lv"
15
1
]
SELECT t0.id AS id_1, t0.title AS title_2, t0.visible AS visible_3, t0.parent_id AS parent_id_4, t0.sort_index AS sort_index_5, t0.type AS type_6, t0.content_id AS content_id_7, t0.lang AS lang_8, t0.external_url AS external_url_9 FROM menu t0 WHERE t0.lang = 'lv' AND t0.parent_id = 15 AND t0.visible = 1 ORDER BY t0.sort_index ASC;
|
| 9 |
0.43 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.visible AS visible_3, t0.parent_id AS parent_id_4, t0.sort_index AS sort_index_5, t0.type AS type_6, t0.content_id AS content_id_7, t0.lang AS lang_8, t0.external_url AS external_url_9 FROM menu t0 WHERE t0.lang = ? AND t0.parent_id = ? AND t0.visible = ? ORDER BY t0.sort_index ASC
SELECT t0.id AS id_1, t0.title AS title_2, t0.visible AS visible_3, t0.parent_id AS parent_id_4, t0.sort_index AS sort_index_5, t0.type AS type_6, t0.content_id AS content_id_7, t0.lang AS lang_8, t0.external_url AS external_url_9 FROM menu t0 WHERE t0.lang = 'lv' AND t0.parent_id = 8 AND t0.visible = 1 ORDER BY t0.sort_index ASC;
|
| 10 |
0.33 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.visible AS visible_3, t0.parent_id AS parent_id_4, t0.sort_index AS sort_index_5, t0.type AS type_6, t0.content_id AS content_id_7, t0.lang AS lang_8, t0.external_url AS external_url_9 FROM menu t0 WHERE t0.lang = ? AND t0.parent_id = ? AND t0.visible = ? ORDER BY t0.sort_index ASC
Parameters: [
"lv"
16
1
]
SELECT t0.id AS id_1, t0.title AS title_2, t0.visible AS visible_3, t0.parent_id AS parent_id_4, t0.sort_index AS sort_index_5, t0.type AS type_6, t0.content_id AS content_id_7, t0.lang AS lang_8, t0.external_url AS external_url_9 FROM menu t0 WHERE t0.lang = 'lv' AND t0.parent_id = 16 AND t0.visible = 1 ORDER BY t0.sort_index ASC;
|
| 11 |
0.50 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.visible AS visible_3, t0.parent_id AS parent_id_4, t0.sort_index AS sort_index_5, t0.type AS type_6, t0.content_id AS content_id_7, t0.lang AS lang_8, t0.external_url AS external_url_9 FROM menu t0 WHERE t0.lang = ? AND t0.parent_id = ? AND t0.visible = ? ORDER BY t0.sort_index ASC
Parameters: [
"lv"
28
1
]
SELECT t0.id AS id_1, t0.title AS title_2, t0.visible AS visible_3, t0.parent_id AS parent_id_4, t0.sort_index AS sort_index_5, t0.type AS type_6, t0.content_id AS content_id_7, t0.lang AS lang_8, t0.external_url AS external_url_9 FROM menu t0 WHERE t0.lang = 'lv' AND t0.parent_id = 28 AND t0.visible = 1 ORDER BY t0.sort_index ASC;
|
| 12 |
1.00 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.created AS created_3, t0.modified AS modified_4, t0.lang AS lang_5, t0.status AS status_6, t0.title_image AS title_image_7, t0.intro AS intro_8, t0.body AS body_9, t0.title_image_aria_label AS title_image_aria_label_10, t0.title_image_alt_tag AS title_image_alt_tag_11 FROM news t0 WHERE t0.lang = ? AND t0.status = ? ORDER BY t0.modified DESC LIMIT 4
SELECT t0.id AS id_1, t0.title AS title_2, t0.created AS created_3, t0.modified AS modified_4, t0.lang AS lang_5, t0.status AS status_6, t0.title_image AS title_image_7, t0.intro AS intro_8, t0.body AS body_9, t0.title_image_aria_label AS title_image_aria_label_10, t0.title_image_alt_tag AS title_image_alt_tag_11 FROM news t0 WHERE t0.lang = 'lv' AND t0.status = 1 ORDER BY t0.modified DESC LIMIT 4;
|
| 13 |
0.96 ms |
SELECT t0.id AS id_1, t0.active_date_from AS active_date_from_2, t0.active_date_till AS active_date_till_3, t0.message AS message_4, t0.addresses AS addresses_5, t0.lang AS lang_6 FROM service_outage t0 WHERE t0.lang = ? ORDER BY t0.active_date_from DESC LIMIT 5
SELECT t0.id AS id_1, t0.active_date_from AS active_date_from_2, t0.active_date_till AS active_date_till_3, t0.message AS message_4, t0.addresses AS addresses_5, t0.lang AS lang_6 FROM service_outage t0 WHERE t0.lang = 'lv' ORDER BY t0.active_date_from DESC LIMIT 5;
|
| 14 |
1.08 ms |
SELECT
l.*,
m.content_id
FROM link l
LEFT JOIN menu m ON m.id=l.navigation_id
WHERE l.lang='lv'
ORDER BY l.sort_index ASC
SELECT
l.*,
m.content_id
FROM link l
LEFT JOIN menu m ON m.id=l.navigation_id
WHERE l.lang='lv'
ORDER BY l.sort_index ASC;
|