678f43e21710a: GET https://dev.slk.kh.ua/tags?tag=39083 at 2025-01-21 08:51:14 am by 18.188.238.166
Database Queries
216 duplicated queries found.
Всього 341 запис.
| Time | Duration | Type | Duplicated | Query |
|---|---|---|---|---|
| 08:51:14.098 | 0.6 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `tbl_news` |
| 08:51:14.099 | 0.4 ms | SELECT | 1 | SELECT
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
`kcu`.`COLUMN_NAME` AS `column_name`,
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
(
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
) AND
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'tbl_news' AND `kcu`.`TABLE_NAME` = 'tbl_news' |
| 08:51:14.102 | 0.6 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `tbl_news_translation` |
| 08:51:14.102 | 0.3 ms | SELECT | 1 | SELECT
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
`kcu`.`COLUMN_NAME` AS `column_name`,
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
(
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
) AND
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'tbl_news_translation' AND `kcu`.`TABLE_NAME` = 'tbl_news_translation' |
| 08:51:14.105 | 3.1 ms | SELECT | 1 | SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `tbl_source_message` `t1`, `tbl_message` `t2` WHERE (`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='frontend.news') AND (`t2`.`language`='uk') |
| 08:51:14.109 | 0.4 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `tbl_tags` |
| 08:51:14.110 | 0.3 ms | SELECT | 1 | SELECT
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
`kcu`.`COLUMN_NAME` AS `column_name`,
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
(
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
) AND
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'tbl_tags' AND `kcu`.`TABLE_NAME` = 'tbl_tags' |
| 08:51:14.111 | 0.9 ms | SELECT | 1 | SELECT * FROM `tbl_tags` WHERE `id`='39083' |
| 08:51:14.112 | 0.4 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `tbl_tags_translation` |
| 08:51:14.113 | 0.3 ms | SELECT | 1 | SELECT
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
`kcu`.`COLUMN_NAME` AS `column_name`,
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
(
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
) AND
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'tbl_tags_translation' AND `kcu`.`TABLE_NAME` = 'tbl_tags_translation' |
| 08:51:14.114 | 1.6 ms | SELECT | 2 | SELECT * FROM `tbl_tags_translation` WHERE `tags_id`=39083 |
| 08:51:14.116 | 1.4 ms | SELECT | 1 | SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `tbl_source_message` `t1`, `tbl_message` `t2` WHERE (`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='app') AND (`t2`.`language`='uk') |
| 08:51:14.119 | 1.2 ms | SELECT | 1 | SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `tbl_source_message` `t1`, `tbl_message` `t2` WHERE (`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='news') AND (`t2`.`language`='uk') |
| 08:51:14.121 | 0.7 ms | SELECT | 1 | SELECT EXISTS(SELECT * FROM `tbl_source_message` WHERE category = 'app' and message = binary 'Youtube link isn`t valid') |
| 08:51:14.122 | 1.5 ms | SELECT | 1 | SELECT EXISTS(SELECT * FROM `tbl_news` WHERE (`tbl_news`.`slug`='') AND (`tbl_news`.`status` <> 3)) |
| 08:51:14.125 | 743.1 ms | SELECT | 1 | SELECT COUNT(*) FROM (SELECT DISTINCT `tbl_news`.* FROM `tbl_news` LEFT JOIN `tbl_news_category` ON `tbl_news`.`id` = `tbl_news_category`.`news_id` LEFT JOIN `tbl_category` ON `tbl_news_category`.`category_id` = `tbl_category`.`id` LEFT JOIN `tbl_news_translation` ON `tbl_news`.`id` = `tbl_news_translation`.`news_id` LEFT JOIN `tbl_news_new_tags` ON `tbl_news`.`id` = `tbl_news_new_tags`.`news_id` LEFT JOIN `tbl_tags` ON `tbl_news_new_tags`.`tag_id` = `tbl_tags`.`id` WHERE (`tbl_news`.`status`=1) AND (`tbl_news_new_tags`.`tag_id` LIKE '%39083%') AND (`tbl_news`.`status`=1) AND (`tbl_news`.`status` <> 3)) `c` |
| 08:51:14.869 | 347.0 ms | SELECT | 1 | SELECT DISTINCT `tbl_news`.* FROM `tbl_news` LEFT JOIN `tbl_news_category` ON `tbl_news`.`id` = `tbl_news_category`.`news_id` LEFT JOIN `tbl_category` ON `tbl_news_category`.`category_id` = `tbl_category`.`id` LEFT JOIN `tbl_news_translation` ON `tbl_news`.`id` = `tbl_news_translation`.`news_id` LEFT JOIN `tbl_news_new_tags` ON `tbl_news`.`id` = `tbl_news_new_tags`.`news_id` LEFT JOIN `tbl_tags` ON `tbl_news_new_tags`.`tag_id` = `tbl_tags`.`id` WHERE (`tbl_news`.`status`=1) AND (`tbl_news_new_tags`.`tag_id` LIKE '%39083%') AND (`tbl_news`.`status`=1) AND (`tbl_news`.`status` <> 3) ORDER BY `published_at` DESC LIMIT 12 |
| 08:51:15.218 | 0.3 ms | SELECT | 1 | SELECT * FROM `tbl_news_category` WHERE `news_id` IN (37299, 33656) |
| 08:51:15.218 | 0.5 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `tbl_news_category` |
| 08:51:15.219 | 0.3 ms | SELECT | 1 | SELECT
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
`kcu`.`COLUMN_NAME` AS `column_name`,
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
(
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
) AND
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'tbl_news_category' AND `kcu`.`TABLE_NAME` = 'tbl_news_category' |
| 08:51:15.220 | 3.5 ms | SELECT | 1 | SELECT `tbl_category`.* FROM `tbl_category` LEFT JOIN `tbl_news_category` ON `tbl_news_category`.category_id = `tbl_category`.id WHERE (`tbl_news_category`.`news_id`=37299) AND (`tbl_category`.`id` IN (25293, 25305, 25350, 25329, 115)) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_news_category`.`id` |
| 08:51:15.224 | 0.4 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `tbl_category` |
| 08:51:15.224 | 0.2 ms | SELECT | 1 | SELECT
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
`kcu`.`COLUMN_NAME` AS `column_name`,
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
(
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
) AND
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'tbl_category' AND `kcu`.`TABLE_NAME` = 'tbl_category' |
| 08:51:15.225 | 0.4 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `tbl_category_translation` |
| 08:51:15.226 | 0.4 ms | SELECT | 1 | SELECT
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
`kcu`.`COLUMN_NAME` AS `column_name`,
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
(
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
) AND
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'tbl_category_translation' AND `kcu`.`TABLE_NAME` = 'tbl_category_translation' |
| 08:51:15.229 | 1.1 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25305 |
| 08:51:15.230 | 0.5 ms | SELECT | 1 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25350 |
| 08:51:15.231 | 0.5 ms | SELECT | 1 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25329 |
| 08:51:15.232 | 0.5 ms | SELECT | 6 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=115 |
| 08:51:15.233 | 1.9 ms | SELECT | 1 | SELECT * FROM `tbl_news_translation` WHERE `news_id` IN (37299, 33656) |
| 08:51:15.235 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_news_new_tags` WHERE `news_id` IN (37299, 33656) |
| 08:51:15.235 | 0.5 ms | SELECT | 1 | SELECT * FROM `tbl_tags` WHERE `id` IN (39083, 39084, 30923) |
| 08:51:15.236 | 0.8 ms | SELECT | 1 | SELECT * FROM `tbl_tags_translation` WHERE `tags_id`=30923 |
| 08:51:15.237 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_tags_translation` WHERE `tags_id`=39083 |
| 08:51:15.238 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_tags_translation` WHERE `tags_id`=39084 |
| 08:51:15.240 | 0.9 ms | SELECT | 1 | SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `tbl_source_message` `t1`, `tbl_message` `t2` WHERE (`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='seo') AND (`t2`.`language`='uk') |
| 08:51:15.242 | 0.6 ms | SELECT | 1 | SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `tbl_source_message` `t1`, `tbl_message` `t2` WHERE (`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='frontend.menu') AND (`t2`.`language`='uk') |
| 08:51:15.243 | 0.5 ms | SELECT | 3 | SELECT * FROM `tbl_category` WHERE (`slug`='all-news') AND (`tbl_category`.`status` <> 3) LIMIT 1 |
| 08:51:15.244 | 0.2 ms | SELECT | 3 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25358 |
| 08:51:15.244 | 0.8 ms | SELECT | 1 | SELECT * FROM `tbl_category` WHERE (`tbl_category`.`lft` > 2) AND (`tbl_category`.`lft` < 21) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`lft`=`tbl_category`.`rgt` - 1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.250 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=108 |
| 08:51:15.251 | 0.2 ms | SELECT | 6 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=109 |
| 08:51:15.251 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=114 |
| 08:51:15.252 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=117 |
| 08:51:15.253 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=95 |
| 08:51:15.253 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=112 |
| 08:51:15.254 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25285 |
| 08:51:15.254 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=24662 |
| 08:51:15.255 | 0.2 ms | SELECT | 6 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=115 |
| 08:51:15.255 | 0.2 ms | SELECT | 3 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 3) AND (`tbl_category`.`rgt` > 4) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.256 | 0.2 ms | SELECT | 4 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 5) AND (`tbl_category`.`rgt` > 6) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.256 | 0.2 ms | SELECT | 3 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 7) AND (`tbl_category`.`rgt` > 8) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.256 | 0.2 ms | SELECT | 3 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 9) AND (`tbl_category`.`rgt` > 10) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.257 | 0.2 ms | SELECT | 3 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 11) AND (`tbl_category`.`rgt` > 12) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.257 | 0.2 ms | SELECT | 3 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 13) AND (`tbl_category`.`rgt` > 14) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.257 | 0.2 ms | SELECT | 3 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 15) AND (`tbl_category`.`rgt` > 16) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.258 | 0.2 ms | SELECT | 3 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 17) AND (`tbl_category`.`rgt` > 18) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.258 | 0.2 ms | SELECT | 3 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 19) AND (`tbl_category`.`rgt` > 20) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.258 | 0.6 ms | SELECT | 1 | SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `tbl_source_message` `t1`, `tbl_message` `t2` WHERE (`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='frontend.layout') AND (`t2`.`language`='uk') |
| 08:51:15.260 | 0.6 ms | SELECT | 1 | SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `tbl_source_message` `t1`, `tbl_message` `t2` WHERE (`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='frontend.search') AND (`t2`.`language`='uk') |
| 08:51:15.261 | 0.3 ms | SELECT | 1 | SELECT `tbl_category`.* FROM `tbl_category` LEFT JOIN `tbl_news_category` ON `tbl_news_category`.category_id = `tbl_category`.id WHERE (`tbl_news_category`.`news_id`=37299) AND (`tbl_category`.`status` <> 3) AND (`tbl_category`.`id` IN (25305, 25350, 25329, 115)) ORDER BY `tbl_news_category`.`id` LIMIT 1 |
| 08:51:15.262 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25305 |
| 08:51:15.263 | 0.3 ms | SELECT | 1 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 96) AND (`tbl_category`.`rgt` > 97) AND (`tbl_category`.`depth` >= -2) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.264 | 8.4 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=37299) AND (`field`='file') AND (`class`='modules\\news\\models\\News') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.272 | 0.4 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `tbl_file` |
| 08:51:15.273 | 0.2 ms | SELECT | 1 | SELECT
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
`kcu`.`COLUMN_NAME` AS `column_name`,
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
(
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
) AND
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'tbl_file' AND `kcu`.`TABLE_NAME` = 'tbl_file' |
| 08:51:15.274 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_category` WHERE (`tbl_category`.`status` <> 3) AND (`id`=25293) LIMIT 1 |
| 08:51:15.275 | 0.2 ms | SELECT | 3 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25293 |
| 08:51:15.275 | 0.2 ms | SELECT | 1 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 151) AND (`tbl_category`.`rgt` > 182) AND (`tbl_category`.`depth` >= -3) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.276 | 0.8 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=33656) AND (`field`='file') AND (`class`='modules\\news\\models\\News') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.284 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_category` WHERE (`slug`='news') AND (`tbl_category`.`status` <> 3) LIMIT 1 |
| 08:51:15.285 | 0.7 ms | SELECT | 1 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=1 |
| 08:51:15.286 | 0.4 ms | SELECT | 1 | SELECT * FROM `tbl_category` WHERE (`tbl_category`.`lft` > 1) AND (`tbl_category`.`lft` < 214) AND (`tbl_category`.`depth` <= 3) AND (`tbl_category`.`tree`=1) AND (`slug` IN ('oblast-online', 'suspilstvo', 'spec-proekti', 'korisno')) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.290 | 0.3 ms | SELECT | 6 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=109 |
| 08:51:15.291 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25325 |
| 08:51:15.292 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=127 |
| 08:51:15.292 | 0.3 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25286 |
| 08:51:15.293 | 0.3 ms | SELECT | 4 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 5) AND (`tbl_category`.`rgt` > 6) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.294 | 0.2 ms | SELECT | 3 | SELECT * FROM `tbl_category` WHERE (`slug`='all-news') AND (`tbl_category`.`status` <> 3) LIMIT 1 |
| 08:51:15.295 | 0.2 ms | SELECT | 3 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25358 |
| 08:51:15.296 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category` WHERE (`tbl_category`.`lft` > 2) AND (`tbl_category`.`lft` < 21) AND (`tbl_category`.`depth` <= 2) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.300 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=108 |
| 08:51:15.301 | 0.2 ms | SELECT | 6 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=109 |
| 08:51:15.301 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=114 |
| 08:51:15.302 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=117 |
| 08:51:15.302 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=95 |
| 08:51:15.303 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=112 |
| 08:51:15.303 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25285 |
| 08:51:15.304 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=24662 |
| 08:51:15.304 | 0.2 ms | SELECT | 6 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=115 |
| 08:51:15.305 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category` WHERE (`tbl_category`.`lft` > 2) AND (`tbl_category`.`lft` < 21) AND (`tbl_category`.`depth` <= 2) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.308 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=108 |
| 08:51:15.309 | 0.2 ms | SELECT | 6 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=109 |
| 08:51:15.310 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=114 |
| 08:51:15.311 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=117 |
| 08:51:15.311 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=95 |
| 08:51:15.312 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=112 |
| 08:51:15.312 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25285 |
| 08:51:15.313 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=24662 |
| 08:51:15.313 | 0.2 ms | SELECT | 6 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=115 |
| 08:51:15.314 | 0.2 ms | SELECT | 3 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 3) AND (`tbl_category`.`rgt` > 4) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.314 | 1.0 ms | SELECT | 2 | SELECT * FROM `tbl_file` WHERE (`object_id`=108) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.315 | 0.2 ms | SELECT | 4 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 5) AND (`tbl_category`.`rgt` > 6) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.315 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_file` WHERE (`object_id`=109) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.316 | 0.2 ms | SELECT | 3 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 7) AND (`tbl_category`.`rgt` > 8) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.316 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_file` WHERE (`object_id`=114) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.316 | 0.2 ms | SELECT | 3 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 9) AND (`tbl_category`.`rgt` > 10) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.317 | 0.3 ms | SELECT | 2 | SELECT * FROM `tbl_file` WHERE (`object_id`=117) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.317 | 0.2 ms | SELECT | 3 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 11) AND (`tbl_category`.`rgt` > 12) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.317 | 0.6 ms | SELECT | 2 | SELECT * FROM `tbl_file` WHERE (`object_id`=95) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.318 | 0.2 ms | SELECT | 3 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 13) AND (`tbl_category`.`rgt` > 14) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.318 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_file` WHERE (`object_id`=112) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.319 | 0.2 ms | SELECT | 3 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 15) AND (`tbl_category`.`rgt` > 16) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.319 | 0.8 ms | SELECT | 2 | SELECT * FROM `tbl_file` WHERE (`object_id`=25285) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.320 | 0.2 ms | SELECT | 3 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 17) AND (`tbl_category`.`rgt` > 18) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.320 | 0.6 ms | SELECT | 2 | SELECT * FROM `tbl_file` WHERE (`object_id`=24662) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.321 | 0.2 ms | SELECT | 3 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 19) AND (`tbl_category`.`rgt` > 20) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.321 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_file` WHERE (`object_id`=115) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.322 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_category` WHERE (`slug`='oblast-online') AND (`tbl_category`.`status` <> 3) LIMIT 1 |
| 08:51:15.322 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=127 |
| 08:51:15.323 | 0.3 ms | SELECT | 1 | SELECT * FROM `tbl_category` WHERE (`tbl_category`.`lft` > 76) AND (`tbl_category`.`lft` < 205) AND (`tbl_category`.`depth` <= 2) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.326 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25288 |
| 08:51:15.327 | 0.3 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25289 |
| 08:51:15.328 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25290 |
| 08:51:15.328 | 0.3 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25291 |
| 08:51:15.329 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25292 |
| 08:51:15.329 | 0.2 ms | SELECT | 3 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25293 |
| 08:51:15.330 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25294 |
| 08:51:15.330 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25295 |
| 08:51:15.331 | 0.3 ms | SELECT | 1 | SELECT * FROM `tbl_category` WHERE (`tbl_category`.`lft` > 76) AND (`tbl_category`.`lft` < 205) AND (`tbl_category`.`depth` <= 2) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.334 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25288 |
| 08:51:15.334 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25289 |
| 08:51:15.335 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25290 |
| 08:51:15.335 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25291 |
| 08:51:15.336 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25292 |
| 08:51:15.336 | 0.2 ms | SELECT | 3 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25293 |
| 08:51:15.337 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25294 |
| 08:51:15.337 | 0.2 ms | SELECT | 1 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 77) AND (`tbl_category`.`rgt` > 88) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.338 | 0.9 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=25288) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.339 | 0.2 ms | SELECT | 1 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 89) AND (`tbl_category`.`rgt` > 106) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.339 | 0.8 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=25289) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.340 | 0.3 ms | SELECT | 1 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 107) AND (`tbl_category`.`rgt` > 120) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.340 | 0.5 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=25290) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.341 | 0.3 ms | SELECT | 1 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 121) AND (`tbl_category`.`rgt` > 138) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.341 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=25291) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.342 | 0.3 ms | SELECT | 1 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 139) AND (`tbl_category`.`rgt` > 150) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.342 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=25292) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.343 | 0.2 ms | SELECT | 1 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 151) AND (`tbl_category`.`rgt` > 182) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.343 | 0.3 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=25293) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.343 | 0.2 ms | SELECT | 1 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 183) AND (`tbl_category`.`rgt` > 202) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.344 | 0.6 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=25294) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.345 | 0.2 ms | SELECT | 3 | SELECT * FROM `tbl_category` WHERE (`slug`='multimedia') AND (`tbl_category`.`status` <> 3) LIMIT 1 |
| 08:51:15.346 | 0.2 ms | SELECT | 3 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=2 |
| 08:51:15.346 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category` WHERE (`tbl_category`.`lft` > 62) AND (`tbl_category`.`lft` < 75) AND (`tbl_category`.`depth` <= 2) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.348 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=13 |
| 08:51:15.349 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25284 |
| 08:51:15.349 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25282 |
| 08:51:15.350 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25283 |
| 08:51:15.350 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25281 |
| 08:51:15.351 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category` WHERE (`tbl_category`.`lft` > 62) AND (`tbl_category`.`lft` < 75) AND (`tbl_category`.`depth` <= 2) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.353 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=13 |
| 08:51:15.354 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25284 |
| 08:51:15.354 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25282 |
| 08:51:15.355 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25283 |
| 08:51:15.355 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25281 |
| 08:51:15.356 | 0.2 ms | SELECT | 2 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 63) AND (`tbl_category`.`rgt` > 64) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.356 | 1.2 ms | SELECT | 2 | SELECT * FROM `tbl_file` WHERE (`object_id`=13) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.357 | 0.2 ms | SELECT | 2 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 65) AND (`tbl_category`.`rgt` > 66) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.357 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_file` WHERE (`object_id`=25284) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.358 | 0.2 ms | SELECT | 2 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 67) AND (`tbl_category`.`rgt` > 68) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.358 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_file` WHERE (`object_id`=25282) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.358 | 0.2 ms | SELECT | 2 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 71) AND (`tbl_category`.`rgt` > 72) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.359 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_file` WHERE (`object_id`=25283) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.359 | 0.2 ms | SELECT | 2 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 73) AND (`tbl_category`.`rgt` > 74) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.359 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_file` WHERE (`object_id`=25281) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.360 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_category` WHERE (`slug`='spec-proekti') AND (`tbl_category`.`status` <> 3) LIMIT 1 |
| 08:51:15.361 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25325 |
| 08:51:15.361 | 0.3 ms | SELECT | 1 | SELECT * FROM `tbl_category` WHERE (`tbl_category`.`lft` > 22) AND (`tbl_category`.`lft` < 61) AND (`tbl_category`.`depth` <= 2) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.371 | 0.7 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25381 |
| 08:51:15.372 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25382 |
| 08:51:15.372 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25380 |
| 08:51:15.373 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25379 |
| 08:51:15.373 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25376 |
| 08:51:15.374 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25375 |
| 08:51:15.374 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25373 |
| 08:51:15.375 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25372 |
| 08:51:15.375 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25368 |
| 08:51:15.376 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25365 |
| 08:51:15.376 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25364 |
| 08:51:15.377 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25363 |
| 08:51:15.377 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25362 |
| 08:51:15.378 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25361 |
| 08:51:15.378 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25360 |
| 08:51:15.379 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25356 |
| 08:51:15.379 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=20523 |
| 08:51:15.380 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25366 |
| 08:51:15.380 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25374 |
| 08:51:15.381 | 0.3 ms | SELECT | 1 | SELECT * FROM `tbl_category` WHERE (`tbl_category`.`lft` > 22) AND (`tbl_category`.`lft` < 61) AND (`tbl_category`.`depth` <= 2) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.389 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25381 |
| 08:51:15.390 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25382 |
| 08:51:15.390 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25380 |
| 08:51:15.391 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25379 |
| 08:51:15.391 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25376 |
| 08:51:15.392 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25375 |
| 08:51:15.392 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25373 |
| 08:51:15.393 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25372 |
| 08:51:15.393 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25368 |
| 08:51:15.394 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25365 |
| 08:51:15.394 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25364 |
| 08:51:15.395 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25363 |
| 08:51:15.395 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25362 |
| 08:51:15.396 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25361 |
| 08:51:15.396 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25360 |
| 08:51:15.397 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25356 |
| 08:51:15.397 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=20523 |
| 08:51:15.398 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25366 |
| 08:51:15.398 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25374 |
| 08:51:15.399 | 0.2 ms | SELECT | 1 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 23) AND (`tbl_category`.`rgt` > 24) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.399 | 0.3 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=25381) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.400 | 0.2 ms | SELECT | 1 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 25) AND (`tbl_category`.`rgt` > 26) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.400 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=25382) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.400 | 0.2 ms | SELECT | 1 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 27) AND (`tbl_category`.`rgt` > 28) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.401 | 0.7 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=25380) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.401 | 0.2 ms | SELECT | 1 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 29) AND (`tbl_category`.`rgt` > 30) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.402 | 0.6 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=25379) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.402 | 0.2 ms | SELECT | 1 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 31) AND (`tbl_category`.`rgt` > 32) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.403 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=25376) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.403 | 0.2 ms | SELECT | 1 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 33) AND (`tbl_category`.`rgt` > 34) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.403 | 0.6 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=25375) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.404 | 0.2 ms | SELECT | 1 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 35) AND (`tbl_category`.`rgt` > 36) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.404 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=25373) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.404 | 0.2 ms | SELECT | 1 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 37) AND (`tbl_category`.`rgt` > 38) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.405 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=25372) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.405 | 0.2 ms | SELECT | 1 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 39) AND (`tbl_category`.`rgt` > 40) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.405 | 0.5 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=25368) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.406 | 0.2 ms | SELECT | 1 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 41) AND (`tbl_category`.`rgt` > 42) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.406 | 0.5 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=25365) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.407 | 0.2 ms | SELECT | 1 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 43) AND (`tbl_category`.`rgt` > 44) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.407 | 0.6 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=25364) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.408 | 0.2 ms | SELECT | 1 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 45) AND (`tbl_category`.`rgt` > 46) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.408 | 0.5 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=25363) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.409 | 0.2 ms | SELECT | 1 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 47) AND (`tbl_category`.`rgt` > 48) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.409 | 0.5 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=25362) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.410 | 0.2 ms | SELECT | 1 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 49) AND (`tbl_category`.`rgt` > 50) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.410 | 0.5 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=25361) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.411 | 0.2 ms | SELECT | 1 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 51) AND (`tbl_category`.`rgt` > 52) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.411 | 0.5 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=25360) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.412 | 0.2 ms | SELECT | 1 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 53) AND (`tbl_category`.`rgt` > 54) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.412 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=25356) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.412 | 0.2 ms | SELECT | 1 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 55) AND (`tbl_category`.`rgt` > 56) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.413 | 0.5 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=20523) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.413 | 0.2 ms | SELECT | 1 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 57) AND (`tbl_category`.`rgt` > 58) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.414 | 0.5 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=25366) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.414 | 0.2 ms | SELECT | 1 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 59) AND (`tbl_category`.`rgt` > 60) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.415 | 0.6 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=25374) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.416 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_category` WHERE (`slug`='khronograf') AND (`tbl_category`.`status` <> 3) LIMIT 1 |
| 08:51:15.417 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=125 |
| 08:51:15.417 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_category` WHERE (`tbl_category`.`lft` > 206) AND (`tbl_category`.`lft` < 207) AND (`tbl_category`.`depth` <= 2) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.418 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_category` WHERE (`slug`='korisno') AND (`tbl_category`.`status` <> 3) LIMIT 1 |
| 08:51:15.419 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25286 |
| 08:51:15.419 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_category` WHERE (`tbl_category`.`lft` > 208) AND (`tbl_category`.`lft` < 211) AND (`tbl_category`.`depth` <= 2) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.419 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_category` WHERE (`slug`='novini-kompanij') AND (`tbl_category`.`status` <> 3) LIMIT 1 |
| 08:51:15.420 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25377 |
| 08:51:15.421 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_category` WHERE (`tbl_category`.`lft` > 212) AND (`tbl_category`.`lft` < 213) AND (`tbl_category`.`depth` <= 2) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.422 | 0.5 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `tbl_ads_place` |
| 08:51:15.422 | 0.3 ms | SELECT | 1 | SELECT
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
`kcu`.`COLUMN_NAME` AS `column_name`,
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
(
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
) AND
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'tbl_ads_place' AND `kcu`.`TABLE_NAME` = 'tbl_ads_place' |
| 08:51:15.423 | 0.5 ms | SELECT | 1 | SELECT * FROM `tbl_ads_place` WHERE (`id`=11) AND (`tbl_ads_place`.`status` <> 3) LIMIT 1 |
| 08:51:15.424 | 0.8 ms | SELECT | 1 | SELECT * FROM `tbl_ads_place_banner` WHERE `place_id`=11 |
| 08:51:15.425 | 1.0 ms | SELECT | 1 | SELECT * FROM `tbl_ads_banner` WHERE (`status`=1) AND ((ISNULL(show_start)) OR (`show_start` <= 1737442275)) AND ((ISNULL(show_end)) OR (`show_end` >= 1737442275)) AND (`tbl_ads_banner`.`status` <> 3) AND (`id`=15) ORDER BY `weight` DESC, `id` DESC |
| 08:51:15.427 | 0.7 ms | SELECT | 1 | SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `tbl_source_message` `t1`, `tbl_message` `t2` WHERE (`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='frontend.form') AND (`t2`.`language`='uk') |
| 08:51:15.428 | 0.7 ms | SELECT | 1 | SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `tbl_source_message` `t1`, `tbl_message` `t2` WHERE (`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='frontend.subscribe') AND (`t2`.`language`='uk') |
| 08:51:15.430 | 0.9 ms | SELECT | 1 | SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `tbl_source_message` `t1`, `tbl_message` `t2` WHERE (`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='forms') AND (`t2`.`language`='uk') |
| 08:51:15.431 | 0.5 ms | SELECT | 1 | SELECT EXISTS(SELECT * FROM `tbl_source_message` WHERE category = 'forms' and message = binary 'E-mail') |
| 08:51:15.432 | 0.2 ms | SELECT | 3 | SELECT * FROM `tbl_category` WHERE (`slug`='all-news') AND (`tbl_category`.`status` <> 3) LIMIT 1 |
| 08:51:15.433 | 0.2 ms | SELECT | 3 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25358 |
| 08:51:15.433 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category` WHERE (`tbl_category`.`lft` > 2) AND (`tbl_category`.`lft` < 21) AND (`tbl_category`.`depth` <= 2) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.437 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=108 |
| 08:51:15.437 | 0.2 ms | SELECT | 6 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=109 |
| 08:51:15.438 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=114 |
| 08:51:15.438 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=117 |
| 08:51:15.439 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=95 |
| 08:51:15.439 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=112 |
| 08:51:15.440 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25285 |
| 08:51:15.441 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=24662 |
| 08:51:15.441 | 0.2 ms | SELECT | 6 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=115 |
| 08:51:15.441 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category` WHERE (`tbl_category`.`lft` > 2) AND (`tbl_category`.`lft` < 21) AND (`tbl_category`.`depth` <= 2) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.445 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=108 |
| 08:51:15.446 | 0.2 ms | SELECT | 6 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=109 |
| 08:51:15.446 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=114 |
| 08:51:15.447 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=117 |
| 08:51:15.447 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=95 |
| 08:51:15.448 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=112 |
| 08:51:15.448 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25285 |
| 08:51:15.449 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=24662 |
| 08:51:15.449 | 0.2 ms | SELECT | 6 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=115 |
| 08:51:15.450 | 0.2 ms | SELECT | 3 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 3) AND (`tbl_category`.`rgt` > 4) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.450 | 0.3 ms | SELECT | 2 | SELECT * FROM `tbl_file` WHERE (`object_id`=108) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.450 | 0.2 ms | SELECT | 4 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 5) AND (`tbl_category`.`rgt` > 6) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.451 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_file` WHERE (`object_id`=109) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.451 | 0.2 ms | SELECT | 3 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 7) AND (`tbl_category`.`rgt` > 8) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.451 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_file` WHERE (`object_id`=114) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.452 | 0.2 ms | SELECT | 3 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 9) AND (`tbl_category`.`rgt` > 10) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.452 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_file` WHERE (`object_id`=117) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.452 | 0.2 ms | SELECT | 3 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 11) AND (`tbl_category`.`rgt` > 12) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.453 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_file` WHERE (`object_id`=95) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.453 | 0.2 ms | SELECT | 3 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 13) AND (`tbl_category`.`rgt` > 14) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.453 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_file` WHERE (`object_id`=112) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.454 | 0.3 ms | SELECT | 3 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 15) AND (`tbl_category`.`rgt` > 16) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.454 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_file` WHERE (`object_id`=25285) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.454 | 0.2 ms | SELECT | 3 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 17) AND (`tbl_category`.`rgt` > 18) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.455 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_file` WHERE (`object_id`=24662) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.455 | 0.2 ms | SELECT | 3 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 19) AND (`tbl_category`.`rgt` > 20) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.455 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_file` WHERE (`object_id`=115) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.456 | 0.2 ms | SELECT | 3 | SELECT * FROM `tbl_category` WHERE (`slug`='multimedia') AND (`tbl_category`.`status` <> 3) LIMIT 1 |
| 08:51:15.456 | 0.2 ms | SELECT | 3 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=2 |
| 08:51:15.457 | 0.2 ms | SELECT | 3 | SELECT * FROM `tbl_category` WHERE (`slug`='multimedia') AND (`tbl_category`.`status` <> 3) LIMIT 1 |
| 08:51:15.458 | 0.2 ms | SELECT | 3 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=2 |
| 08:51:15.458 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category` WHERE (`tbl_category`.`lft` > 62) AND (`tbl_category`.`lft` < 75) AND (`tbl_category`.`depth` <= 2) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.460 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=13 |
| 08:51:15.461 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25284 |
| 08:51:15.461 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25282 |
| 08:51:15.462 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25283 |
| 08:51:15.463 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25281 |
| 08:51:15.463 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category` WHERE (`tbl_category`.`lft` > 62) AND (`tbl_category`.`lft` < 75) AND (`tbl_category`.`depth` <= 2) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.465 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=13 |
| 08:51:15.466 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25284 |
| 08:51:15.466 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25282 |
| 08:51:15.467 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25283 |
| 08:51:15.467 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25281 |
| 08:51:15.468 | 0.2 ms | SELECT | 2 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 63) AND (`tbl_category`.`rgt` > 64) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.468 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_file` WHERE (`object_id`=13) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.468 | 0.2 ms | SELECT | 2 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 65) AND (`tbl_category`.`rgt` > 66) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.469 | 0.3 ms | SELECT | 2 | SELECT * FROM `tbl_file` WHERE (`object_id`=25284) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.469 | 0.2 ms | SELECT | 2 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 67) AND (`tbl_category`.`rgt` > 68) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.469 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_file` WHERE (`object_id`=25282) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.470 | 0.2 ms | SELECT | 2 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 71) AND (`tbl_category`.`rgt` > 72) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.470 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_file` WHERE (`object_id`=25283) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.470 | 0.2 ms | SELECT | 2 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 73) AND (`tbl_category`.`rgt` > 74) AND (`tbl_category`.`depth` >= 0) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
| 08:51:15.471 | 0.3 ms | SELECT | 2 | SELECT * FROM `tbl_file` WHERE (`object_id`=25281) AND (`field`='file') AND (`class`='modules\\categories\\models\\Category') ORDER BY `ordering` DESC LIMIT 1 |
| 08:51:15.471 | 0.7 ms | SELECT | 1 | SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `tbl_source_message` `t1`, `tbl_message` `t2` WHERE (`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='frontend.contacts') AND (`t2`.`language`='uk') |
| 08:51:15.475 | 0.8 ms | SELECT | 1 | SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `tbl_source_message` `t1`, `tbl_message` `t2` WHERE (`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='frontend.development') AND (`t2`.`language`='uk') |