238 duplicated queries found.
Time | Duration | Type | Duplicated | Query |
---|---|---|---|---|
11:05:37.445 | 0.8 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `tbl_tags` |
11:05:37.446 | 0.5 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' |
11:05:37.449 | 5.7 ms | SELECT | 1 | SELECT * FROM `tbl_tags` WHERE `slug`='metro' |
11:05:37.457 | 1.0 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `tbl_tags_translation` |
11:05:37.458 | 0.7 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' |
11:05:37.460 | 2.5 ms | SELECT | 3 | SELECT * FROM `tbl_tags_translation` WHERE `tags_id`=31168 |
11:05:37.466 | 1.7 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `tbl_news` |
11:05:37.468 | 0.5 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' |
11:05:37.471 | 1.0 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `tbl_news_translation` |
11:05:37.472 | 0.6 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' |
11:05:37.474 | 5.3 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') |
11:05:37.481 | 0.3 ms | SELECT | 1 | SELECT * FROM `tbl_tags` WHERE `id`=31168 |
11:05:37.482 | 0.5 ms | SELECT | 3 | SELECT * FROM `tbl_tags_translation` WHERE `tags_id`=31168 |
11:05:37.484 | 3.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') |
11:05:37.490 | 1.6 ms | SELECT | 1 | SELECT EXISTS(SELECT * FROM `tbl_source_message` WHERE category = 'app' and message = binary 'Youtube link isn`t valid') |
11:05:37.493 | 2.2 ms | SELECT | 1 | SELECT EXISTS(SELECT * FROM `tbl_news` WHERE (`tbl_news`.`slug`='') AND (`tbl_news`.`status` <> 3)) |
11:05:37.498 | 753.2 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 '%31168%') AND (`tbl_news`.`status`=1) AND (`tbl_news`.`status` <> 3)) `c` |
11:05:38.251 | 359.3 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 '%31168%') AND (`tbl_news`.`status`=1) AND (`tbl_news`.`status` <> 3) ORDER BY `published_at` DESC LIMIT 12 |
11:05:38.618 | 0.5 ms | SELECT | 1 | SELECT * FROM `tbl_news_category` WHERE `news_id` IN (49339, 49297, 49267, 49196, 49065, 49039, 49008, 48976, 48940, 48915, 48869, 48808) |
11:05:38.619 | 0.5 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `tbl_news_category` |
11:05:38.619 | 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' |
11:05:38.621 | 7.6 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`=49339) AND (`tbl_category`.`id` IN (25343, 1, 127, 13, 109)) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_news_category`.`id` |
11:05:38.629 | 0.6 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `tbl_category` |
11:05:38.629 | 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_category' AND `kcu`.`TABLE_NAME` = 'tbl_category' |
11:05:38.631 | 0.5 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `tbl_category_translation` |
11:05:38.631 | 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_category_translation' AND `kcu`.`TABLE_NAME` = 'tbl_category_translation' |
11:05:38.633 | 1.0 ms | SELECT | 13 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25343 |
11:05:38.634 | 4.0 ms | SELECT | 1 | SELECT * FROM `tbl_news_translation` WHERE `news_id` IN (49339, 49297, 49267, 49196, 49065, 49039, 49008, 48976, 48940, 48915, 48869, 48808) |
11:05:38.638 | 0.3 ms | SELECT | 1 | SELECT * FROM `tbl_news_new_tags` WHERE `news_id` IN (49339, 49297, 49267, 49196, 49065, 49039, 49008, 48976, 48940, 48915, 48869, 48808) |
11:05:38.639 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_tags` WHERE `id` IN (31168, 31397, 32292, 39384, 39721, 40957, 30899) |
11:05:38.640 | 0.6 ms | SELECT | 1 | SELECT * FROM `tbl_tags_translation` WHERE `tags_id`=30899 |
11:05:38.641 | 0.2 ms | SELECT | 3 | SELECT * FROM `tbl_tags_translation` WHERE `tags_id`=31168 |
11:05:38.641 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_tags_translation` WHERE `tags_id`=31397 |
11:05:38.642 | 0.5 ms | SELECT | 1 | SELECT * FROM `tbl_tags_translation` WHERE `tags_id`=32292 |
11:05:38.642 | 0.8 ms | SELECT | 1 | SELECT * FROM `tbl_tags_translation` WHERE `tags_id`=39384 |
11:05:38.643 | 0.5 ms | SELECT | 1 | SELECT * FROM `tbl_tags_translation` WHERE `tags_id`=39721 |
11:05:38.644 | 0.7 ms | SELECT | 1 | SELECT * FROM `tbl_tags_translation` WHERE `tags_id`=40957 |
11:05:38.655 | 0.3 ms | SELECT | 1 | SELECT * FROM `tbl_tags_translation` WHERE (`language`='uk') AND (`tags_id`=31168) |
11:05:38.657 | 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') |
11:05:38.658 | 0.5 ms | SELECT | 3 | SELECT * FROM `tbl_category` WHERE (`slug`='all-news') AND (`tbl_category`.`status` <> 3) LIMIT 1 |
11:05:38.659 | 0.5 ms | SELECT | 3 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25358 |
11:05:38.660 | 0.7 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` |
11:05:38.667 | 0.5 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=108 |
11:05:38.668 | 0.2 ms | SELECT | 6 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=109 |
11:05:38.669 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=114 |
11:05:38.669 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=117 |
11:05:38.670 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=95 |
11:05:38.671 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=112 |
11:05:38.672 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25285 |
11:05:38.672 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=24662 |
11:05:38.673 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=115 |
11:05:38.674 | 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` |
11:05:38.674 | 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` |
11:05:38.674 | 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` |
11:05:38.675 | 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` |
11:05:38.675 | 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` |
11:05:38.676 | 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` |
11:05:38.676 | 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` |
11:05:38.676 | 0.3 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` |
11:05:38.677 | 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` |
11:05:38.677 | 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.layout') AND (`t2`.`language`='uk') |
11:05:38.679 | 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.search') AND (`t2`.`language`='uk') |
11:05:38.681 | 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`=49339) AND (`tbl_category`.`status` <> 3) AND (`tbl_category`.`id`=25343) ORDER BY `tbl_news_category`.`id` LIMIT 1 |
11:05:38.683 | 0.2 ms | SELECT | 13 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25343 |
11:05:38.683 | 0.5 ms | SELECT | 12 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 178) AND (`tbl_category`.`rgt` > 179) AND (`tbl_category`.`depth` >= -2) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
11:05:38.684 | 6.8 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=49339) AND (`field`='file') AND (`class`='modules\\news\\models\\News') ORDER BY `ordering` DESC LIMIT 1 |
11:05:38.691 | 0.5 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `tbl_file` |
11:05:38.692 | 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_file' AND `kcu`.`TABLE_NAME` = 'tbl_file' |
11:05:38.693 | 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`=49297) AND (`tbl_category`.`status` <> 3) AND (`tbl_category`.`id` IN (25343, 1)) ORDER BY `tbl_news_category`.`id` LIMIT 1 |
11:05:38.694 | 0.3 ms | SELECT | 13 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25343 |
11:05:38.694 | 0.3 ms | SELECT | 12 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 178) AND (`tbl_category`.`rgt` > 179) AND (`tbl_category`.`depth` >= -2) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
11:05:38.695 | 0.6 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=49297) AND (`field`='file') AND (`class`='modules\\news\\models\\News') ORDER BY `ordering` DESC LIMIT 1 |
11:05:38.696 | 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`=49267) AND (`tbl_category`.`status` <> 3) AND (`tbl_category`.`id` IN (25343, 1)) ORDER BY `tbl_news_category`.`id` LIMIT 1 |
11:05:38.697 | 0.2 ms | SELECT | 13 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25343 |
11:05:38.697 | 0.2 ms | SELECT | 12 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 178) AND (`tbl_category`.`rgt` > 179) AND (`tbl_category`.`depth` >= -2) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
11:05:38.698 | 0.6 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=49267) AND (`field`='file') AND (`class`='modules\\news\\models\\News') ORDER BY `ordering` DESC LIMIT 1 |
11:05:38.699 | 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`=49196) AND (`tbl_category`.`status` <> 3) AND (`tbl_category`.`id` IN (25343, 127)) ORDER BY `tbl_news_category`.`id` LIMIT 1 |
11:05:38.700 | 0.2 ms | SELECT | 13 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25343 |
11:05:38.700 | 0.2 ms | SELECT | 12 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 178) AND (`tbl_category`.`rgt` > 179) AND (`tbl_category`.`depth` >= -2) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
11:05:38.701 | 0.6 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=49196) AND (`field`='file') AND (`class`='modules\\news\\models\\News') ORDER BY `ordering` DESC LIMIT 1 |
11:05:38.702 | 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`=49065) AND (`tbl_category`.`status` <> 3) AND (`tbl_category`.`id` IN (25343, 127)) ORDER BY `tbl_news_category`.`id` LIMIT 1 |
11:05:38.703 | 0.2 ms | SELECT | 13 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25343 |
11:05:38.703 | 0.2 ms | SELECT | 12 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 178) AND (`tbl_category`.`rgt` > 179) AND (`tbl_category`.`depth` >= -2) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
11:05:38.704 | 0.5 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=49065) AND (`field`='file') AND (`class`='modules\\news\\models\\News') ORDER BY `ordering` DESC LIMIT 1 |
11:05:38.704 | 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`=49039) AND (`tbl_category`.`status` <> 3) AND (`tbl_category`.`id` IN (25343, 1, 13, 109)) ORDER BY `tbl_news_category`.`id` LIMIT 1 |
11:05:38.705 | 0.2 ms | SELECT | 13 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25343 |
11:05:38.706 | 0.3 ms | SELECT | 12 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 178) AND (`tbl_category`.`rgt` > 179) AND (`tbl_category`.`depth` >= -2) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
11:05:38.706 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=49039) AND (`field`='file') AND (`class`='modules\\news\\models\\News') ORDER BY `ordering` DESC LIMIT 1 |
11:05:38.707 | 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`=49008) AND (`tbl_category`.`status` <> 3) AND (`tbl_category`.`id` IN (25343, 1)) ORDER BY `tbl_news_category`.`id` LIMIT 1 |
11:05:38.708 | 0.2 ms | SELECT | 13 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25343 |
11:05:38.708 | 0.2 ms | SELECT | 12 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 178) AND (`tbl_category`.`rgt` > 179) AND (`tbl_category`.`depth` >= -2) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
11:05:38.709 | 0.5 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=49008) AND (`field`='file') AND (`class`='modules\\news\\models\\News') ORDER BY `ordering` DESC LIMIT 1 |
11:05:38.710 | 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`=48976) AND (`tbl_category`.`status` <> 3) AND (`tbl_category`.`id` IN (25343, 1)) ORDER BY `tbl_news_category`.`id` LIMIT 1 |
11:05:38.711 | 0.2 ms | SELECT | 13 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25343 |
11:05:38.711 | 0.2 ms | SELECT | 12 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 178) AND (`tbl_category`.`rgt` > 179) AND (`tbl_category`.`depth` >= -2) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
11:05:38.711 | 0.5 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=48976) AND (`field`='file') AND (`class`='modules\\news\\models\\News') ORDER BY `ordering` DESC LIMIT 1 |
11:05:38.712 | 0.2 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`=48940) AND (`tbl_category`.`status` <> 3) AND (`tbl_category`.`id` IN (25343, 1)) ORDER BY `tbl_news_category`.`id` LIMIT 1 |
11:05:38.713 | 0.2 ms | SELECT | 13 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25343 |
11:05:38.713 | 0.2 ms | SELECT | 12 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 178) AND (`tbl_category`.`rgt` > 179) AND (`tbl_category`.`depth` >= -2) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
11:05:38.714 | 0.8 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=48940) AND (`field`='file') AND (`class`='modules\\news\\models\\News') ORDER BY `ordering` DESC LIMIT 1 |
11:05:38.715 | 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`=48915) AND (`tbl_category`.`status` <> 3) AND (`tbl_category`.`id` IN (25343, 127)) ORDER BY `tbl_news_category`.`id` LIMIT 1 |
11:05:38.716 | 0.2 ms | SELECT | 13 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25343 |
11:05:38.716 | 0.2 ms | SELECT | 12 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 178) AND (`tbl_category`.`rgt` > 179) AND (`tbl_category`.`depth` >= -2) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
11:05:38.717 | 0.5 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=48915) AND (`field`='file') AND (`class`='modules\\news\\models\\News') ORDER BY `ordering` DESC LIMIT 1 |
11:05:38.718 | 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`=48869) AND (`tbl_category`.`status` <> 3) AND (`tbl_category`.`id` IN (25343, 1)) ORDER BY `tbl_news_category`.`id` LIMIT 1 |
11:05:38.719 | 0.2 ms | SELECT | 13 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25343 |
11:05:38.719 | 0.3 ms | SELECT | 12 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 178) AND (`tbl_category`.`rgt` > 179) AND (`tbl_category`.`depth` >= -2) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
11:05:38.720 | 0.5 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=48869) AND (`field`='file') AND (`class`='modules\\news\\models\\News') ORDER BY `ordering` DESC LIMIT 1 |
11:05:38.721 | 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`=48808) AND (`tbl_category`.`status` <> 3) AND (`tbl_category`.`id` IN (25343, 1)) ORDER BY `tbl_news_category`.`id` LIMIT 1 |
11:05:38.722 | 0.2 ms | SELECT | 13 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25343 |
11:05:38.722 | 0.3 ms | SELECT | 12 | SELECT `slug` FROM `tbl_category` WHERE (`tbl_category`.`lft` < 178) AND (`tbl_category`.`rgt` > 179) AND (`tbl_category`.`depth` >= -2) AND (`tbl_category`.`tree`=1) AND (`tbl_category`.`status` <> 3) ORDER BY `tbl_category`.`lft` |
11:05:38.722 | 0.5 ms | SELECT | 1 | SELECT * FROM `tbl_file` WHERE (`object_id`=48808) AND (`field`='file') AND (`class`='modules\\news\\models\\News') ORDER BY `ordering` DESC LIMIT 1 |
11:05:38.730 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_category` WHERE (`slug`='news') AND (`tbl_category`.`status` <> 3) LIMIT 1 |
11:05:38.731 | 0.6 ms | SELECT | 1 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=1 |
11:05:38.732 | 0.3 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` |
11:05:38.734 | 0.3 ms | SELECT | 6 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=109 |
11:05:38.735 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25325 |
11:05:38.735 | 0.3 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=127 |
11:05:38.736 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25286 |
11:05:38.736 | 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` |
11:05:38.737 | 0.2 ms | SELECT | 3 | SELECT * FROM `tbl_category` WHERE (`slug`='all-news') AND (`tbl_category`.`status` <> 3) LIMIT 1 |
11:05:38.738 | 0.2 ms | SELECT | 3 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25358 |
11:05:38.738 | 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` |
11:05:38.742 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=108 |
11:05:38.742 | 0.2 ms | SELECT | 6 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=109 |
11:05:38.743 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=114 |
11:05:38.743 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=117 |
11:05:38.744 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=95 |
11:05:38.744 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=112 |
11:05:38.745 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25285 |
11:05:38.745 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=24662 |
11:05:38.746 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=115 |
11:05:38.746 | 0.3 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` |
11:05:38.750 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=108 |
11:05:38.751 | 0.2 ms | SELECT | 6 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=109 |
11:05:38.751 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=114 |
11:05:38.752 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=117 |
11:05:38.752 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=95 |
11:05:38.753 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=112 |
11:05:38.753 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25285 |
11:05:38.754 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=24662 |
11:05:38.754 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=115 |
11:05:38.755 | 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` |
11:05:38.755 | 0.7 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 |
11:05:38.756 | 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` |
11:05:38.756 | 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 |
11:05:38.756 | 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` |
11:05:38.757 | 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 |
11:05:38.757 | 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` |
11:05:38.757 | 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 |
11:05:38.758 | 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` |
11:05:38.758 | 0.5 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 |
11:05:38.759 | 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` |
11:05:38.759 | 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 |
11:05:38.759 | 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` |
11:05:38.760 | 0.7 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 |
11:05:38.760 | 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` |
11:05:38.761 | 0.5 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 |
11:05:38.761 | 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` |
11:05:38.762 | 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 |
11:05:38.762 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_category` WHERE (`slug`='oblast-online') AND (`tbl_category`.`status` <> 3) LIMIT 1 |
11:05:38.763 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=127 |
11:05:38.763 | 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` |
11:05:38.769 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25288 |
11:05:38.769 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25289 |
11:05:38.770 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25290 |
11:05:38.770 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25291 |
11:05:38.771 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25292 |
11:05:38.771 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25293 |
11:05:38.772 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25294 |
11:05:38.772 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25295 |
11:05:38.773 | 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` |
11:05:38.776 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25288 |
11:05:38.776 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25289 |
11:05:38.777 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25290 |
11:05:38.777 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25291 |
11:05:38.778 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25292 |
11:05:38.778 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25293 |
11:05:38.779 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25294 |
11:05:38.779 | 0.3 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` |
11:05:38.780 | 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 |
11:05:38.781 | 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` |
11:05:38.781 | 0.7 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 |
11:05:38.782 | 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` |
11:05:38.782 | 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 |
11:05:38.783 | 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` |
11:05:38.783 | 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 |
11:05:38.784 | 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` |
11:05:38.784 | 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 |
11:05:38.785 | 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` |
11:05:38.785 | 0.2 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 |
11:05:38.785 | 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` |
11:05:38.786 | 0.5 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 |
11:05:38.786 | 0.2 ms | SELECT | 3 | SELECT * FROM `tbl_category` WHERE (`slug`='multimedia') AND (`tbl_category`.`status` <> 3) LIMIT 1 |
11:05:38.787 | 0.2 ms | SELECT | 3 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=2 |
11:05:38.788 | 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` |
11:05:38.790 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=13 |
11:05:38.790 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25284 |
11:05:38.791 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25282 |
11:05:38.792 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25283 |
11:05:38.792 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25281 |
11:05:38.792 | 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` |
11:05:38.795 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=13 |
11:05:38.795 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25284 |
11:05:38.796 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25282 |
11:05:38.796 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25283 |
11:05:38.797 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25281 |
11:05:38.797 | 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` |
11:05:38.797 | 1.0 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 |
11:05:38.798 | 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` |
11:05:38.799 | 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 |
11:05:38.799 | 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` |
11:05:38.799 | 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 |
11:05:38.800 | 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` |
11:05:38.800 | 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 |
11:05:38.800 | 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` |
11:05:38.801 | 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 |
11:05:38.801 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_category` WHERE (`slug`='spec-proekti') AND (`tbl_category`.`status` <> 3) LIMIT 1 |
11:05:38.802 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25325 |
11:05:38.802 | 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` |
11:05:38.809 | 0.5 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25381 |
11:05:38.810 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25382 |
11:05:38.811 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25380 |
11:05:38.811 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25379 |
11:05:38.812 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25376 |
11:05:38.812 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25375 |
11:05:38.813 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25373 |
11:05:38.813 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25372 |
11:05:38.814 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25368 |
11:05:38.814 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25365 |
11:05:38.815 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25364 |
11:05:38.815 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25363 |
11:05:38.816 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25362 |
11:05:38.816 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25361 |
11:05:38.817 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25360 |
11:05:38.817 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25356 |
11:05:38.818 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=20523 |
11:05:38.818 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25366 |
11:05:38.819 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25374 |
11:05:38.819 | 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` |
11:05:38.826 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25381 |
11:05:38.827 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25382 |
11:05:38.828 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25380 |
11:05:38.828 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25379 |
11:05:38.829 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25376 |
11:05:38.829 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25375 |
11:05:38.830 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25373 |
11:05:38.830 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25372 |
11:05:38.831 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25368 |
11:05:38.831 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25365 |
11:05:38.832 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25364 |
11:05:38.832 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25363 |
11:05:38.833 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25362 |
11:05:38.833 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25361 |
11:05:38.834 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25360 |
11:05:38.834 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25356 |
11:05:38.835 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=20523 |
11:05:38.835 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25366 |
11:05:38.836 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25374 |
11:05:38.836 | 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` |
11:05:38.837 | 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 |
11:05:38.837 | 0.4 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` |
11:05:38.838 | 0.3 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 |
11:05:38.838 | 0.3 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` |
11:05:38.838 | 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 |
11:05:38.839 | 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` |
11:05:38.840 | 0.5 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 |
11:05:38.840 | 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` |
11:05:38.841 | 0.3 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 |
11:05:38.841 | 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` |
11:05:38.841 | 0.5 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 |
11:05:38.842 | 0.3 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` |
11:05:38.842 | 0.3 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 |
11:05:38.843 | 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` |
11:05:38.843 | 0.3 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 |
11:05:38.843 | 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` |
11:05:38.844 | 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 |
11:05:38.844 | 0.3 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` |
11:05:38.845 | 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 |
11:05:38.845 | 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` |
11:05:38.845 | 0.5 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 |
11:05:38.846 | 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` |
11:05:38.846 | 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 |
11:05:38.847 | 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` |
11:05:38.847 | 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 |
11:05:38.848 | 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` |
11:05:38.848 | 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 |
11:05:38.849 | 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` |
11:05:38.849 | 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 |
11:05:38.850 | 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` |
11:05:38.850 | 0.3 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 |
11:05:38.850 | 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` |
11:05:38.850 | 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 |
11:05:38.851 | 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` |
11:05:38.851 | 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 |
11:05:38.852 | 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` |
11:05:38.852 | 0.5 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 |
11:05:38.853 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_category` WHERE (`slug`='khronograf') AND (`tbl_category`.`status` <> 3) LIMIT 1 |
11:05:38.854 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=125 |
11:05:38.854 | 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` |
11:05:38.855 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_category` WHERE (`slug`='korisno') AND (`tbl_category`.`status` <> 3) LIMIT 1 |
11:05:38.856 | 0.2 ms | SELECT | 2 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25286 |
11:05:38.856 | 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` |
11:05:38.856 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_category` WHERE (`slug`='novini-kompanij') AND (`tbl_category`.`status` <> 3) LIMIT 1 |
11:05:38.857 | 0.2 ms | SELECT | 1 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25377 |
11:05:38.858 | 0.4 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` |
11:05:38.859 | 17.1 ms | SELECT | 1 | SELECT * FROM `tbl_news` WHERE (`tbl_news`.`status`=1) AND (`tbl_news`.`date` BETWEEN 1737363938 AND 1737450338) AND (`tbl_news`.`status` <> 3) ORDER BY `views` DESC, `id` LIMIT 4 |
11:05:38.876 | 15.0 ms | SELECT | 1 | SELECT * FROM `tbl_news` WHERE (`tbl_news`.`status`=1) AND (`tbl_news`.`date` BETWEEN 1736845538 AND 1737450338) AND (`tbl_news`.`status` <> 3) ORDER BY `views` DESC, `id` LIMIT 4 |
11:05:38.891 | 11.0 ms | SELECT | 1 | SELECT * FROM `tbl_news` WHERE (`tbl_news`.`status`=1) AND (`tbl_news`.`date` BETWEEN 1734771938 AND 1737450338) AND (`tbl_news`.`status` <> 3) ORDER BY `views` DESC, `id` LIMIT 4 |
11:05:38.903 | 0.5 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `tbl_ads_place` |
11:05:38.904 | 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' |
11:05:38.904 | 0.5 ms | SELECT | 1 | SELECT * FROM `tbl_ads_place` WHERE (`id`=11) AND (`tbl_ads_place`.`status` <> 3) LIMIT 1 |
11:05:38.906 | 0.7 ms | SELECT | 1 | SELECT * FROM `tbl_ads_place_banner` WHERE `place_id`=11 |
11:05:38.907 | 0.8 ms | SELECT | 1 | SELECT * FROM `tbl_ads_banner` WHERE (`status`=1) AND ((ISNULL(show_start)) OR (`show_start` <= 1737450338)) AND ((ISNULL(show_end)) OR (`show_end` >= 1737450338)) AND (`tbl_ads_banner`.`status` <> 3) AND (`id`=15) ORDER BY `weight` DESC, `id` DESC |
11:05:38.908 | 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.form') AND (`t2`.`language`='uk') |
11:05:38.909 | 0.5 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') |
11:05:38.911 | 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`='forms') AND (`t2`.`language`='uk') |
11:05:38.912 | 0.4 ms | SELECT | 1 | SELECT EXISTS(SELECT * FROM `tbl_source_message` WHERE category = 'forms' and message = binary 'E-mail') |
11:05:38.913 | 0.2 ms | SELECT | 3 | SELECT * FROM `tbl_category` WHERE (`slug`='all-news') AND (`tbl_category`.`status` <> 3) LIMIT 1 |
11:05:38.914 | 0.2 ms | SELECT | 3 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25358 |
11:05:38.914 | 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` |
11:05:38.919 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=108 |
11:05:38.920 | 0.2 ms | SELECT | 6 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=109 |
11:05:38.920 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=114 |
11:05:38.921 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=117 |
11:05:38.922 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=95 |
11:05:38.922 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=112 |
11:05:38.923 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25285 |
11:05:38.923 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=24662 |
11:05:38.924 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=115 |
11:05:38.924 | 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` |
11:05:38.932 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=108 |
11:05:38.932 | 0.2 ms | SELECT | 6 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=109 |
11:05:38.933 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=114 |
11:05:38.933 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=117 |
11:05:38.934 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=95 |
11:05:38.934 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=112 |
11:05:38.935 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25285 |
11:05:38.935 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=24662 |
11:05:38.936 | 0.2 ms | SELECT | 5 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=115 |
11:05:38.936 | 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` |
11:05:38.936 | 0.2 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 |
11:05:38.937 | 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` |
11:05:38.937 | 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 |
11:05:38.937 | 0.3 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` |
11:05:38.938 | 0.3 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 |
11:05:38.938 | 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` |
11:05:38.938 | 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 |
11:05:38.939 | 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` |
11:05:38.939 | 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 |
11:05:38.939 | 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` |
11:05:38.940 | 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 |
11:05:38.940 | 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` |
11:05:38.940 | 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 |
11:05:38.941 | 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` |
11:05:38.941 | 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 |
11:05:38.941 | 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` |
11:05:38.942 | 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 |
11:05:38.942 | 0.2 ms | SELECT | 3 | SELECT * FROM `tbl_category` WHERE (`slug`='multimedia') AND (`tbl_category`.`status` <> 3) LIMIT 1 |
11:05:38.943 | 0.2 ms | SELECT | 3 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=2 |
11:05:38.943 | 0.2 ms | SELECT | 3 | SELECT * FROM `tbl_category` WHERE (`slug`='multimedia') AND (`tbl_category`.`status` <> 3) LIMIT 1 |
11:05:38.944 | 0.2 ms | SELECT | 3 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=2 |
11:05:38.944 | 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` |
11:05:38.947 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=13 |
11:05:38.947 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25284 |
11:05:38.948 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25282 |
11:05:38.948 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25283 |
11:05:38.949 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25281 |
11:05:38.949 | 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` |
11:05:38.951 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=13 |
11:05:38.952 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25284 |
11:05:38.952 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25282 |
11:05:38.953 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25283 |
11:05:38.953 | 0.2 ms | SELECT | 4 | SELECT * FROM `tbl_category_translation` WHERE `category_id`=25281 |
11:05:38.954 | 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` |
11:05:38.954 | 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 |
11:05:38.954 | 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` |
11:05:38.955 | 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 |
11:05:38.955 | 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` |
11:05:38.955 | 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 |
11:05:38.956 | 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` |
11:05:38.956 | 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 |
11:05:38.956 | 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` |
11:05:38.957 | 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 |
11:05:38.957 | 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.contacts') AND (`t2`.`language`='uk') |
11:05:38.961 | 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.development') AND (`t2`.`language`='uk') |