| 1 | DESCRIBE `articles` | | 18 | 18 | 1 |
| 2 | DESCRIBE `categories` | | 5 | 5 | 1 |
| 3 | DESCRIBE `photos` | | 9 | 9 | 1 |
| 4 | DESCRIBE `photogalleries` | | 3 | 3 | 1 |
| 5 | DESCRIBE `users` | | 5 | 5 | 1 |
| 6 | DESCRIBE `comments` | | 5 | 5 | 1 |
| 7 | SELECT `Article`.`id`, `Article`.`url`, `Article`.`name`, `Article`.`perex`, `Article`.`text`, `Article`.`status`, `Article`.`priority`, `Article`.`created`, `Article`.`views`, `Article`.`comment_count`, `Article`.`end_date`, `Article`.`photo_id`, `Article`.`category_id`, `Article`.`economix_id`, `Article`.`relevant_id`, `Article`.`creator_id`, `Article`.`modifier_id`, `Article`.`gallery_id`, `Category`.`id`, `Category`.`name`, `Category`.`url`, `Category`.`parent_id`, `Category`.`color`, `Photo`.`id`, `Photo`.`title`, `Photo`.`title_admin`, `Photo`.`width`, `Photo`.`height`, `Photo`.`size`, `Photo`.`type`, `Photo`.`gallery_id`, `Photo`.`link`, `Photogallery`.`id`, `Photogallery`.`name`, `Photogallery`.`url`, `Creator`.`id`, `Creator`.`username`, `Creator`.`password`, `Creator`.`name`, `Creator`.`status`, `Modifier`.`id`, `Modifier`.`username`, `Modifier`.`password`, `Modifier`.`name`, `Modifier`.`status` FROM `articles` AS `Article` LEFT JOIN `categories` AS `Category` ON (`Article`.`category_id` = `Category`.`id`) LEFT JOIN `photos` AS `Photo` ON (`Article`.`photo_id` = `Photo`.`id`) LEFT JOIN `photogalleries` AS `Photogallery` ON (`Article`.`gallery_id` = `Photogallery`.`id`) LEFT JOIN `users` AS `Creator` ON (`Article`.`creator_id` = `Creator`.`id`) LEFT JOIN `users` AS `Modifier` ON (`Article`.`modifier_id` = `Modifier`.`id`) WHERE 1 = 1 ORDER BY `Article`.`created` DESC LIMIT 15 | | 1 | 1 | 1 |
| 8 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`url`, `Category`.`parent_id`, `Category`.`color` FROM `categories` AS `Category` WHERE `Category`.`id` = 1 | | 1 | 1 | 0 |
| 9 | SELECT `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`color` FROM `categories` AS `Parent` WHERE `Parent`.`id` = '0' | | 0 | 0 | 0 |
| 10 | SELECT `Child`.`id`, `Child`.`name`, `Child`.`url`, `Child`.`parent_id`, `Child`.`color` FROM `categories` AS `Child` WHERE `Child`.`parent_id` = (1) | | 0 | 0 | 0 |
| 11 | SELECT `Photo`.`id`, `Photo`.`title`, `Photo`.`title_admin`, `Photo`.`width`, `Photo`.`height`, `Photo`.`size`, `Photo`.`type`, `Photo`.`gallery_id`, `Photo`.`link` FROM `photos` AS `Photo` WHERE `Photo`.`id` = 35 | | 1 | 1 | 0 |
| 12 | SELECT `Photogallery`.`id`, `Photogallery`.`name`, `Photogallery`.`url` FROM `photogalleries` AS `Photogallery` WHERE `Photogallery`.`id` = 2 | | 1 | 1 | 0 |
| 13 | SELECT `Photogallery`.`id`, `Photogallery`.`name`, `Photogallery`.`url` FROM `photogalleries` AS `Photogallery` WHERE `Photogallery`.`id` = 1 | | 1 | 1 | 0 |
| 14 | SELECT `Photo`.`id`, `Photo`.`title`, `Photo`.`title_admin`, `Photo`.`width`, `Photo`.`height`, `Photo`.`size`, `Photo`.`type`, `Photo`.`gallery_id`, `Photo`.`link` FROM `photos` AS `Photo` WHERE `Photo`.`gallery_id` = (1) | | 29 | 29 | 0 |
| 15 | SELECT `Creator`.`id`, `Creator`.`username`, `Creator`.`password`, `Creator`.`name`, `Creator`.`status` FROM `users` AS `Creator` WHERE `Creator`.`id` = 2 | | 1 | 1 | 0 |
| 16 | SELECT `Modifier`.`id`, `Modifier`.`username`, `Modifier`.`password`, `Modifier`.`name`, `Modifier`.`status` FROM `users` AS `Modifier` WHERE `Modifier`.`id` = 2 | | 1 | 1 | 0 |
| 17 | SELECT `Comment`.`id`, `Comment`.`author`, `Comment`.`text`, `Comment`.`article_id`, `Comment`.`created` FROM `comments` AS `Comment` WHERE `Comment`.`article_id` = (1) | | 0 | 0 | 0 |