SET sql_mode = '';

SHOW FULL COLUMNS FROM `settings`

SELECT `setting`.* FROM `settings` AS `setting` LIMIT 1

SHOW FULL COLUMNS FROM `pages`

SELECT `page`.* FROM `pages` AS `page` WHERE `id` = 2 AND `status` = '1' ORDER BY `page`.`lft` ASC LIMIT 1

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 4 AND `rgt` < 83 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 3 ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `status` = '1' AND `url` = '/heroes' ORDER BY `page`.`lft` ASC LIMIT 1

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` <= 7 AND `rgt` >= 8 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lft` != 1 ORDER BY `lft` ASC

SHOW FULL COLUMNS FROM `heroes`

SELECT DISTINCT SUBSTRING(`name`, 1, 1) AS `letter` FROM `heroes` ORDER BY `name` ASC

SELECT `hero`.* FROM `heroes` AS `hero` WHERE `status` = '1' ORDER BY `name` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 75 AND `rgt` < 82 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 4 ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 76 AND `rgt` > 77 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 73 AND `rgt` < 74 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 4 ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 9 AND `rgt` < 72 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 4 ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 64 AND `rgt` > 65 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 56 AND `rgt` > 57 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 54 AND `rgt` > 55 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 52 AND `rgt` > 53 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 50 AND `rgt` > 51 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 48 AND `rgt` > 49 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 46 AND `rgt` > 47 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 44 AND `rgt` > 45 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 42 AND `rgt` > 43 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 40 AND `rgt` > 41 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 38 AND `rgt` > 39 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 36 AND `rgt` > 37 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 34 AND `rgt` > 35 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 32 AND `rgt` > 33 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 30 AND `rgt` > 31 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 28 AND `rgt` > 29 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 26 AND `rgt` > 27 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 24 AND `rgt` > 25 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 22 AND `rgt` > 23 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 20 AND `rgt` > 21 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 18 AND `rgt` > 19 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 16 AND `rgt` > 17 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 14 AND `rgt` > 15 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 12 AND `rgt` > 13 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 10 AND `rgt` > 11 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 7 AND `rgt` < 8 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 4 ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 5 AND `rgt` < 6 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 4 ORDER BY `lft` DESC

array(1) {
  [0] => string(7) "/heroes"
}