| 1 | SHOW FULL COLUMNS FROM `articles` | | 31 | 31 | 1 |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | | 1 | 1 | 0 |
| 3 | SHOW FULL COLUMNS FROM `accounts` | | 14 | 14 | 1 |
| 4 | SHOW FULL COLUMNS FROM `profiles` | | 8 | 8 | 1 |
| 5 | SHOW FULL COLUMNS FROM `groups` | | 4 | 4 | 0 |
| 6 | SHOW FULL COLUMNS FROM `roles` | | 3 | 3 | 0 |
| 7 | SHOW FULL COLUMNS FROM `permitions` | | 3 | 3 | 0 |
| 8 | SHOW FULL COLUMNS FROM `passphrases` | | 4 | 4 | 0 |
| 9 | SHOW FULL COLUMNS FROM `actions` | | 4 | 4 | 0 |
| 10 | SHOW FULL COLUMNS FROM `comments` | | 9 | 9 | 1 |
| 11 | SHOW FULL COLUMNS FROM `histories` | | 5 | 5 | 0 |
| 12 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin'; | | 1 | 1 | 0 |
| 13 | SHOW FULL COLUMNS FROM `members` | | 3 | 3 | 0 |
| 14 | SHOW FULL COLUMNS FROM `participants` | | 3 | 3 | 0 |
| 15 | SHOW FULL COLUMNS FROM `discussions` | | 2 | 2 | 0 |
| 16 | SHOW FULL COLUMNS FROM `email_histories` | | 7 | 7 | 1 |
| 17 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`description` FROM `roles` AS `Role` WHERE 1 = 1 | | 43 | 43 | 0 |
| 18 | SELECT `Groups`.`id`, `Groups`.`name`, `Groups`.`type`, `Groups`.`created`, `Permition`.`id`, `Permition`.`role_id`, `Permition`.`group_id` FROM `groups` AS `Groups` JOIN `permitions` AS `Permition` ON (`Permition`.`role_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 30, 31, 29, 32, 33, 34, 35, 36, 37, 38, 39, 40, 1000, 1001, 1002) AND `Permition`.`group_id` = `Groups`.`id`) | | 32 | 32 | 0 |
| 19 | SELECT `Action`.`id`, `Action`.`article_id`, `Action`.`begin`, `Action`.`end`, `Article`.`id`, `Article`.`title`, `Article`.`intro`, `Article`.`content`, `Article`.`permalink`, `Article`.`markup`, `Article`.`weight`, `Article`.`icon_pdf`, `Article`.`icon_print`, `Article`.`icon_email`, `Article`.`hits`, `Article`.`revised`, `Article`.`frontpage`, `Article`.`layout`, `Article`.`class_suffix`, `Article`.`commented`, `Article`.`guest_comments`, `Article`.`visible`, `Article`.`in_list`, `Article`.`rating_value`, `Article`.`rating_count`, `Article`.`rating_show`, `Article`.`group_id`, `Article`.`account_id`, `Article`.`passphrase_id`, `Article`.`published`, `Article`.`unpublished`, `Article`.`created`, `Article`.`updated`, `Article`.`deleted`, `Article`.`title_show`, (SELECT COALESCE( CONCAT(`profiles`.`name`,' ',`profiles`.`lastname`), `profiles`.`lastname`, `profiles`.`name`, `accounts`.`login` ) AS author FROM accounts LEFT JOIN profiles ON (`accounts`.`id` = `profiles`.`account_id`) WHERE `accounts`.`id`=`Article`.`account_id`) AS `Article__author` FROM `actions` AS `Action` LEFT JOIN `articles` AS `Article` ON (`Action`.`article_id` = `Article`.`id`) WHERE `Article`.`deleted` IS NULL AND `Article`.`published` IS NOT NULL AND `Article`.`in_list` = 1 AND `Action`.`end` >= '2012-05-16 00:00:00' AND ((`Article`.`group_id` IS NULL) OR (`Article`.`group_id` IS NULL)) ORDER BY `Action`.`begin` desc LIMIT 10 | | 1 | 1 | 0 |
| 20 | SELECT `Action`.`id`, `Action`.`article_id`, `Action`.`begin`, `Action`.`end`, `Article`.`id`, `Article`.`title`, `Article`.`intro`, `Article`.`content`, `Article`.`permalink`, `Article`.`markup`, `Article`.`weight`, `Article`.`icon_pdf`, `Article`.`icon_print`, `Article`.`icon_email`, `Article`.`hits`, `Article`.`revised`, `Article`.`frontpage`, `Article`.`layout`, `Article`.`class_suffix`, `Article`.`commented`, `Article`.`guest_comments`, `Article`.`visible`, `Article`.`in_list`, `Article`.`rating_value`, `Article`.`rating_count`, `Article`.`rating_show`, `Article`.`group_id`, `Article`.`account_id`, `Article`.`passphrase_id`, `Article`.`published`, `Article`.`unpublished`, `Article`.`created`, `Article`.`updated`, `Article`.`deleted`, `Article`.`title_show`, (SELECT COALESCE( CONCAT(`profiles`.`name`,' ',`profiles`.`lastname`), `profiles`.`lastname`, `profiles`.`name`, `accounts`.`login` ) AS author FROM accounts LEFT JOIN profiles ON (`accounts`.`id` = `profiles`.`account_id`) WHERE `accounts`.`id`=`Article`.`account_id`) AS `Article__author` FROM `actions` AS `Action` LEFT JOIN `articles` AS `Article` ON (`Action`.`article_id` = `Article`.`id`) WHERE `Article`.`deleted` IS NULL AND `Article`.`published` IS NOT NULL AND `Article`.`in_list` = 1 AND `Action`.`end` < '2012-05-16 00:00:00' AND ((`Article`.`group_id` IS NULL) OR (`Article`.`group_id` IS NULL)) ORDER BY `Action`.`begin` desc LIMIT 2 | | 2 | 2 | 2 |
| 21 | SELECT `Action`.`id`, `Action`.`article_id`, `Action`.`begin`, `Action`.`end`, `Article`.`id`, `Article`.`title`, `Article`.`intro`, `Article`.`content`, `Article`.`permalink`, `Article`.`markup`, `Article`.`weight`, `Article`.`icon_pdf`, `Article`.`icon_print`, `Article`.`icon_email`, `Article`.`hits`, `Article`.`revised`, `Article`.`frontpage`, `Article`.`layout`, `Article`.`class_suffix`, `Article`.`commented`, `Article`.`guest_comments`, `Article`.`visible`, `Article`.`in_list`, `Article`.`rating_value`, `Article`.`rating_count`, `Article`.`rating_show`, `Article`.`group_id`, `Article`.`account_id`, `Article`.`passphrase_id`, `Article`.`published`, `Article`.`unpublished`, `Article`.`created`, `Article`.`updated`, `Article`.`deleted`, `Article`.`title_show`, (SELECT COALESCE( CONCAT(`profiles`.`name`,' ',`profiles`.`lastname`), `profiles`.`lastname`, `profiles`.`name`, `accounts`.`login` ) AS author FROM accounts LEFT JOIN profiles ON (`accounts`.`id` = `profiles`.`account_id`) WHERE `accounts`.`id`=`Article`.`account_id`) AS `Article__author` FROM `actions` AS `Action` LEFT JOIN `articles` AS `Article` ON (`Action`.`article_id` = `Article`.`id`) WHERE `Article`.`deleted` IS NULL AND `Article`.`published` IS NOT NULL AND `Article`.`in_list` = 1 AND ((`Article`.`group_id` IS NULL) OR (`Article`.`group_id` IS NULL)) ORDER BY `Action`.`begin` desc | | 25 | 25 | 2 |
| 22 | SELECT `Discussion`.`id`, `Discussion`.`article_id`, `Article`.`id`, `Article`.`title`, `Article`.`intro`, `Article`.`content`, `Article`.`permalink`, `Article`.`markup`, `Article`.`weight`, `Article`.`icon_pdf`, `Article`.`icon_print`, `Article`.`icon_email`, `Article`.`hits`, `Article`.`revised`, `Article`.`frontpage`, `Article`.`layout`, `Article`.`class_suffix`, `Article`.`commented`, `Article`.`guest_comments`, `Article`.`visible`, `Article`.`in_list`, `Article`.`rating_value`, `Article`.`rating_count`, `Article`.`rating_show`, `Article`.`group_id`, `Article`.`account_id`, `Article`.`passphrase_id`, `Article`.`published`, `Article`.`unpublished`, `Article`.`created`, `Article`.`updated`, `Article`.`deleted`, `Article`.`title_show`, (SELECT COALESCE( CONCAT(`profiles`.`name`,' ',`profiles`.`lastname`), `profiles`.`lastname`, `profiles`.`name`, `accounts`.`login` ) AS author FROM accounts LEFT JOIN profiles ON (`accounts`.`id` = `profiles`.`account_id`) WHERE `accounts`.`id`=`Article`.`account_id`) AS `Article__author` FROM `discussions` AS `Discussion` LEFT JOIN `articles` AS `Article` ON (`Discussion`.`article_id` = `Article`.`id`) WHERE `Article`.`deleted` IS NULL AND `Article`.`published` IS NOT NULL AND `Article`.`in_list` = 1 AND ((`Article`.`group_id` IS NULL) OR (`Article`.`group_id` IS NULL)) ORDER BY `Article`.`created` desc LIMIT 10 | | 4 | 4 | 1 |
| 23 | SELECT `Discussion`.*, `Article`.*, COUNT(`Comment`.id) `comments` FROM `discussions` AS `Discussion` LEFT JOIN `articles` AS `Article` ON (`Discussion`.`article_id` = `Article`.`id`) JOIN `comments` AS `Comment` ON (`Article`.`id` = `Comment`.`article_id`) WHERE `Article`.`deleted` IS NULL AND `Article`.`published` IS NOT NULL AND `Article`.`in_list` = 1 AND ((`Article`.`group_id` IS NULL)) AND `Comment`.`created` > '2012-03-17 00:00:00' GROUP BY Discussion.id ORDER BY `comments` DESC LIMIT 10 | | 0 | 0 | 1 |
| 24 | SELECT `Article`.`id`, `Article`.`title`, `Article`.`intro`, `Article`.`content`, `Article`.`permalink`, `Article`.`markup`, `Article`.`weight`, `Article`.`icon_pdf`, `Article`.`icon_print`, `Article`.`icon_email`, `Article`.`hits`, `Article`.`revised`, `Article`.`frontpage`, `Article`.`layout`, `Article`.`class_suffix`, `Article`.`commented`, `Article`.`guest_comments`, `Article`.`visible`, `Article`.`in_list`, `Article`.`rating_value`, `Article`.`rating_count`, `Article`.`rating_show`, `Article`.`group_id`, `Article`.`account_id`, `Article`.`passphrase_id`, `Article`.`published`, `Article`.`unpublished`, `Article`.`created`, `Article`.`updated`, `Article`.`deleted`, `Article`.`title_show`, (SELECT COALESCE( CONCAT(`profiles`.`name`,' ',`profiles`.`lastname`), `profiles`.`lastname`, `profiles`.`name`, `accounts`.`login` ) AS author FROM accounts LEFT JOIN profiles ON (`accounts`.`id` = `profiles`.`account_id`) WHERE `accounts`.`id`=`Article`.`account_id`) AS `Article__author`, `Account`.`id`, `Account`.`login`, `Account`.`email`, `Account`.`crypted_password`, `Account`.`salt`, `Account`.`password_reset_code`, `Account`.`remember_token`, `Account`.`remember_token_expires`, `Account`.`activation_code`, `Account`.`activated`, `Account`.`state`, `Account`.`deleted`, `Account`.`created`, `Account`.`updated`, (SELECT COALESCE( CONCAT(`profiles`.`name`,' ',`profiles`.`lastname`), `profiles`.`lastname`, `profiles`.`name`, `accounts`.`login` ) AS display FROM accounts LEFT JOIN profiles ON (`accounts`.`id` = `profiles`.`account_id`) WHERE `accounts`.`id`=`Account`.`id`) AS `Account__display`, `Group`.`id`, `Group`.`name`, `Group`.`type`, `Group`.`created`, `Passphrase`.`id`, `Passphrase`.`used`, `Passphrase`.`value`, `Passphrase`.`tryes`, `Action`.`id`, `Action`.`article_id`, `Action`.`begin`, `Action`.`end`, `Discussion`.`id`, `Discussion`.`article_id` FROM `articles` AS `Article` LEFT JOIN `accounts` AS `Account` ON (`Article`.`account_id` = `Account`.`id`) LEFT JOIN `groups` AS `Group` ON (`Article`.`group_id` = `Group`.`id`) LEFT JOIN `passphrases` AS `Passphrase` ON (`Article`.`passphrase_id` = `Passphrase`.`id`) LEFT JOIN `actions` AS `Action` ON (`Action`.`article_id` = `Article`.`id`) LEFT JOIN `discussions` AS `Discussion` ON (`Discussion`.`article_id` = `Article`.`id`) WHERE `Article`.`deleted` IS NULL AND `Article`.`published` IS NOT NULL AND `Article`.`in_list` = 1 AND `Article`.`visible` = 1 AND ((`Article`.`group_id` IS NULL) OR (`Article`.`group_id` IS NULL)) ORDER BY `Article`.`created` desc LIMIT 10 | | 3 | 3 | 1 |
| 25 | SELECT `Article`.`id`, `Article`.`title`, `Article`.`intro`, `Article`.`content`, `Article`.`permalink`, `Article`.`markup`, `Article`.`weight`, `Article`.`icon_pdf`, `Article`.`icon_print`, `Article`.`icon_email`, `Article`.`hits`, `Article`.`revised`, `Article`.`frontpage`, `Article`.`layout`, `Article`.`class_suffix`, `Article`.`commented`, `Article`.`guest_comments`, `Article`.`visible`, `Article`.`in_list`, `Article`.`rating_value`, `Article`.`rating_count`, `Article`.`rating_show`, `Article`.`group_id`, `Article`.`account_id`, `Article`.`passphrase_id`, `Article`.`published`, `Article`.`unpublished`, `Article`.`created`, `Article`.`updated`, `Article`.`deleted`, `Article`.`title_show`, (SELECT COALESCE( CONCAT(`profiles`.`name`,' ',`profiles`.`lastname`), `profiles`.`lastname`, `profiles`.`name`, `accounts`.`login` ) AS author FROM accounts LEFT JOIN profiles ON (`accounts`.`id` = `profiles`.`account_id`) WHERE `accounts`.`id`=`Article`.`account_id`) AS `Article__author`, `Account`.`id`, `Account`.`login`, `Account`.`email`, `Account`.`crypted_password`, `Account`.`salt`, `Account`.`password_reset_code`, `Account`.`remember_token`, `Account`.`remember_token_expires`, `Account`.`activation_code`, `Account`.`activated`, `Account`.`state`, `Account`.`deleted`, `Account`.`created`, `Account`.`updated`, (SELECT COALESCE( CONCAT(`profiles`.`name`,' ',`profiles`.`lastname`), `profiles`.`lastname`, `profiles`.`name`, `accounts`.`login` ) AS display FROM accounts LEFT JOIN profiles ON (`accounts`.`id` = `profiles`.`account_id`) WHERE `accounts`.`id`=`Account`.`id`) AS `Account__display`, `Group`.`id`, `Group`.`name`, `Group`.`type`, `Group`.`created`, `Passphrase`.`id`, `Passphrase`.`used`, `Passphrase`.`value`, `Passphrase`.`tryes`, `Action`.`id`, `Action`.`article_id`, `Action`.`begin`, `Action`.`end`, `Discussion`.`id`, `Discussion`.`article_id` FROM `articles` AS `Article` LEFT JOIN `accounts` AS `Account` ON (`Article`.`account_id` = `Account`.`id`) LEFT JOIN `groups` AS `Group` ON (`Article`.`group_id` = `Group`.`id`) LEFT JOIN `passphrases` AS `Passphrase` ON (`Article`.`passphrase_id` = `Passphrase`.`id`) LEFT JOIN `actions` AS `Action` ON (`Action`.`article_id` = `Article`.`id`) LEFT JOIN `discussions` AS `Discussion` ON (`Discussion`.`article_id` = `Article`.`id`) WHERE `Article`.`frontpage` = 1 LIMIT 1 | | 1 | 1 | 0 |
| 26 | SELECT `Comments`.`id`, `Comments`.`parent_id`, `Comments`.`lft`, `Comments`.`rght`, `Comments`.`article_id`, `Comments`.`account_id`, `Comments`.`message`, `Comments`.`created`, `Comments`.`deleted`, (SELECT COALESCE( CONCAT(`profiles`.`name`,' ',`profiles`.`lastname`), `profiles`.`lastname`, `profiles`.`name`, `accounts`.`login` ) AS author FROM accounts LEFT JOIN profiles ON (`accounts`.`id` = `profiles`.`account_id`) WHERE `accounts`.`id`=`Comments`.`account_id`) AS `Comments__author`, (SELECT count(*) FROM comments WHERE deleted IS NULL AND parent_id=`Comments`.`id`) AS `Comments__children_count` FROM `comments` AS `Comments` WHERE `Comments`.`article_id` = (154) ORDER BY `Comments`.`lft` ASC | | 0 | 0 | 0 |