| 1 | DESCRIBE `articles` | | 26 | 26 | 6 |
| 2 | DESCRIBE `forumtopics` | | 11 | 11 | 4 |
| 3 | DESCRIBE `users` | | 11 | 11 | 3 |
| 4 | DESCRIBE `forumposts` | | 8 | 8 | 7 |
| 5 | DESCRIBE `redeempoints` | | 6 | 6 | 1 |
| 6 | SELECT `Article`.`id`, `Article`.`aid`, `Article`.`wid`, `Article`.`categoryId`, `Article`.`subcategoryId`, `Article`.`metakeyword`, `Article`.`heading`, `Article`.`subject`, `Article`.`description`, `Article`.`user_id`, `Article`.`publishDate`, `Article`.`PublishDuration`, `Article`.`isActive`, `Article`.`ratings`, `Article`.`rate_count`, `Article`.`hits`, `Article`.`image`, `Article`.`image_caption`, `Article`.`video_url`, `Article`.`IsPornVideo`, `Article`.`EmbedVideoUrl`, `Article`.`isPublish`, `Article`.`isDraft`, `Article`.`emailed`, `Article`.`metadesc`, `Article`.`url` FROM `articles` AS `Article` WHERE `categoryId` = 24 ORDER BY `publishDate` desc LIMIT 5 | | 5 | 5 | 1 |
| 7 | SELECT `Article`.`id`, `Article`.`aid`, `Article`.`wid`, `Article`.`categoryId`, `Article`.`subcategoryId`, `Article`.`metakeyword`, `Article`.`heading`, `Article`.`subject`, `Article`.`description`, `Article`.`user_id`, `Article`.`publishDate`, `Article`.`PublishDuration`, `Article`.`isActive`, `Article`.`ratings`, `Article`.`rate_count`, `Article`.`hits`, `Article`.`image`, `Article`.`image_caption`, `Article`.`video_url`, `Article`.`IsPornVideo`, `Article`.`EmbedVideoUrl`, `Article`.`isPublish`, `Article`.`isDraft`, `Article`.`emailed`, `Article`.`metadesc`, `Article`.`url` FROM `articles` AS `Article` WHERE `isPublish` = 1 ORDER BY `publishDate` desc LIMIT 10 | | 10 | 10 | 4 |
| 8 | SELECT `Forumtopic`.`id`, `Forumtopic`.`forumid`, `Forumtopic`.`topicname`, `Forumtopic`.`detail`, `Forumtopic`.`UserId`, `Forumtopic`.`user_id`, `Forumtopic`.`CreatedDate`, `Forumtopic`.`No_of_Replies`, `Forumtopic`.`LastActivity`, `Forumtopic`.`LastActivityByUser`, `Forumtopic`.`url` FROM `forumtopics` AS `Forumtopic` WHERE 1 = 1 GROUP BY LastActivityByUser ORDER BY `Forumtopic`.`LastActivity` DESC LIMIT 10 | | 10 | 10 | 1 |
| 9 | DESCRIBE `categories` | | 8 | 8 | 2 |
| 10 | DESCRIBE `subcategories` | | 9 | 9 | 2 |
| 11 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`desc`, `Category`.`isdefault`, `Category`.`order`, `Category`.`metakeyword`, `Category`.`metadesc`, `Category`.`url` FROM `categories` AS `Category` WHERE 1 = 1 ORDER BY `Category`.`order` asc | | 24 | 24 | 1 |
| 12 | SELECT `Subcategory`.`id`, `Subcategory`.`categoryId`, `Subcategory`.`name`, `Subcategory`.`desc`, `Subcategory`.`isdefault`, `Subcategory`.`order`, `Subcategory`.`metakeyword`, `Subcategory`.`metadesc`, `Subcategory`.`url` FROM `subcategories` AS `Subcategory` WHERE `Subcategory`.`categoryId` = 15 | | 16 | 16 | 1 |
| 13 | SELECT `Subcategory`.`id`, `Subcategory`.`categoryId`, `Subcategory`.`name`, `Subcategory`.`desc`, `Subcategory`.`isdefault`, `Subcategory`.`order`, `Subcategory`.`metakeyword`, `Subcategory`.`metadesc`, `Subcategory`.`url` FROM `subcategories` AS `Subcategory` WHERE `Subcategory`.`categoryId` = 14 | | 1 | 1 | 3 |
| 14 | SELECT `Subcategory`.`id`, `Subcategory`.`categoryId`, `Subcategory`.`name`, `Subcategory`.`desc`, `Subcategory`.`isdefault`, `Subcategory`.`order`, `Subcategory`.`metakeyword`, `Subcategory`.`metadesc`, `Subcategory`.`url` FROM `subcategories` AS `Subcategory` WHERE `Subcategory`.`categoryId` = 1 | | 1 | 1 | 3 |
| 15 | SELECT `Subcategory`.`id`, `Subcategory`.`categoryId`, `Subcategory`.`name`, `Subcategory`.`desc`, `Subcategory`.`isdefault`, `Subcategory`.`order`, `Subcategory`.`metakeyword`, `Subcategory`.`metadesc`, `Subcategory`.`url` FROM `subcategories` AS `Subcategory` WHERE `Subcategory`.`categoryId` = 2 | | 1 | 1 | 0 |
| 16 | SELECT `Subcategory`.`id`, `Subcategory`.`categoryId`, `Subcategory`.`name`, `Subcategory`.`desc`, `Subcategory`.`isdefault`, `Subcategory`.`order`, `Subcategory`.`metakeyword`, `Subcategory`.`metadesc`, `Subcategory`.`url` FROM `subcategories` AS `Subcategory` WHERE `Subcategory`.`categoryId` = 3 | | 1 | 1 | 0 |
| 17 | SELECT `Subcategory`.`id`, `Subcategory`.`categoryId`, `Subcategory`.`name`, `Subcategory`.`desc`, `Subcategory`.`isdefault`, `Subcategory`.`order`, `Subcategory`.`metakeyword`, `Subcategory`.`metadesc`, `Subcategory`.`url` FROM `subcategories` AS `Subcategory` WHERE `Subcategory`.`categoryId` = 4 | | 1 | 1 | 0 |
| 18 | SELECT `Subcategory`.`id`, `Subcategory`.`categoryId`, `Subcategory`.`name`, `Subcategory`.`desc`, `Subcategory`.`isdefault`, `Subcategory`.`order`, `Subcategory`.`metakeyword`, `Subcategory`.`metadesc`, `Subcategory`.`url` FROM `subcategories` AS `Subcategory` WHERE `Subcategory`.`categoryId` = 7 | | 1 | 1 | 0 |
| 19 | SELECT `Subcategory`.`id`, `Subcategory`.`categoryId`, `Subcategory`.`name`, `Subcategory`.`desc`, `Subcategory`.`isdefault`, `Subcategory`.`order`, `Subcategory`.`metakeyword`, `Subcategory`.`metadesc`, `Subcategory`.`url` FROM `subcategories` AS `Subcategory` WHERE `Subcategory`.`categoryId` = 6 | | 1 | 1 | 0 |
| 20 | SELECT `Subcategory`.`id`, `Subcategory`.`categoryId`, `Subcategory`.`name`, `Subcategory`.`desc`, `Subcategory`.`isdefault`, `Subcategory`.`order`, `Subcategory`.`metakeyword`, `Subcategory`.`metadesc`, `Subcategory`.`url` FROM `subcategories` AS `Subcategory` WHERE `Subcategory`.`categoryId` = 10 | | 23 | 23 | 1 |
| 21 | SELECT `Subcategory`.`id`, `Subcategory`.`categoryId`, `Subcategory`.`name`, `Subcategory`.`desc`, `Subcategory`.`isdefault`, `Subcategory`.`order`, `Subcategory`.`metakeyword`, `Subcategory`.`metadesc`, `Subcategory`.`url` FROM `subcategories` AS `Subcategory` WHERE `Subcategory`.`categoryId` = 21 | | 19 | 19 | 2 |
| 22 | SELECT `Subcategory`.`id`, `Subcategory`.`categoryId`, `Subcategory`.`name`, `Subcategory`.`desc`, `Subcategory`.`isdefault`, `Subcategory`.`order`, `Subcategory`.`metakeyword`, `Subcategory`.`metadesc`, `Subcategory`.`url` FROM `subcategories` AS `Subcategory` WHERE `Subcategory`.`categoryId` = 11 | | 18 | 18 | 1 |
| 23 | SELECT `Subcategory`.`id`, `Subcategory`.`categoryId`, `Subcategory`.`name`, `Subcategory`.`desc`, `Subcategory`.`isdefault`, `Subcategory`.`order`, `Subcategory`.`metakeyword`, `Subcategory`.`metadesc`, `Subcategory`.`url` FROM `subcategories` AS `Subcategory` WHERE `Subcategory`.`categoryId` = 8 | | 21 | 21 | 1 |
| 24 | SELECT `Subcategory`.`id`, `Subcategory`.`categoryId`, `Subcategory`.`name`, `Subcategory`.`desc`, `Subcategory`.`isdefault`, `Subcategory`.`order`, `Subcategory`.`metakeyword`, `Subcategory`.`metadesc`, `Subcategory`.`url` FROM `subcategories` AS `Subcategory` WHERE `Subcategory`.`categoryId` = 22 | | 17 | 17 | 1 |
| 25 | SELECT `Subcategory`.`id`, `Subcategory`.`categoryId`, `Subcategory`.`name`, `Subcategory`.`desc`, `Subcategory`.`isdefault`, `Subcategory`.`order`, `Subcategory`.`metakeyword`, `Subcategory`.`metadesc`, `Subcategory`.`url` FROM `subcategories` AS `Subcategory` WHERE `Subcategory`.`categoryId` = 23 | | 3 | 3 | 1 |
| 26 | SELECT `Subcategory`.`id`, `Subcategory`.`categoryId`, `Subcategory`.`name`, `Subcategory`.`desc`, `Subcategory`.`isdefault`, `Subcategory`.`order`, `Subcategory`.`metakeyword`, `Subcategory`.`metadesc`, `Subcategory`.`url` FROM `subcategories` AS `Subcategory` WHERE `Subcategory`.`categoryId` = 12 | | 20 | 20 | 1 |
| 27 | SELECT `Subcategory`.`id`, `Subcategory`.`categoryId`, `Subcategory`.`name`, `Subcategory`.`desc`, `Subcategory`.`isdefault`, `Subcategory`.`order`, `Subcategory`.`metakeyword`, `Subcategory`.`metadesc`, `Subcategory`.`url` FROM `subcategories` AS `Subcategory` WHERE `Subcategory`.`categoryId` = 5 | | 1 | 1 | 0 |
| 28 | SELECT `Subcategory`.`id`, `Subcategory`.`categoryId`, `Subcategory`.`name`, `Subcategory`.`desc`, `Subcategory`.`isdefault`, `Subcategory`.`order`, `Subcategory`.`metakeyword`, `Subcategory`.`metadesc`, `Subcategory`.`url` FROM `subcategories` AS `Subcategory` WHERE `Subcategory`.`categoryId` = 9 | | 1 | 1 | 1 |
| 29 | SELECT `Subcategory`.`id`, `Subcategory`.`categoryId`, `Subcategory`.`name`, `Subcategory`.`desc`, `Subcategory`.`isdefault`, `Subcategory`.`order`, `Subcategory`.`metakeyword`, `Subcategory`.`metadesc`, `Subcategory`.`url` FROM `subcategories` AS `Subcategory` WHERE `Subcategory`.`categoryId` = 13 | | 1 | 1 | 0 |
| 30 | SELECT `Subcategory`.`id`, `Subcategory`.`categoryId`, `Subcategory`.`name`, `Subcategory`.`desc`, `Subcategory`.`isdefault`, `Subcategory`.`order`, `Subcategory`.`metakeyword`, `Subcategory`.`metadesc`, `Subcategory`.`url` FROM `subcategories` AS `Subcategory` WHERE `Subcategory`.`categoryId` = 16 | | 1 | 1 | 1 |
| 31 | SELECT `Subcategory`.`id`, `Subcategory`.`categoryId`, `Subcategory`.`name`, `Subcategory`.`desc`, `Subcategory`.`isdefault`, `Subcategory`.`order`, `Subcategory`.`metakeyword`, `Subcategory`.`metadesc`, `Subcategory`.`url` FROM `subcategories` AS `Subcategory` WHERE `Subcategory`.`categoryId` = 17 | | 1 | 1 | 1 |
| 32 | SELECT `Subcategory`.`id`, `Subcategory`.`categoryId`, `Subcategory`.`name`, `Subcategory`.`desc`, `Subcategory`.`isdefault`, `Subcategory`.`order`, `Subcategory`.`metakeyword`, `Subcategory`.`metadesc`, `Subcategory`.`url` FROM `subcategories` AS `Subcategory` WHERE `Subcategory`.`categoryId` = 18 | | 1 | 1 | 0 |
| 33 | SELECT `Subcategory`.`id`, `Subcategory`.`categoryId`, `Subcategory`.`name`, `Subcategory`.`desc`, `Subcategory`.`isdefault`, `Subcategory`.`order`, `Subcategory`.`metakeyword`, `Subcategory`.`metadesc`, `Subcategory`.`url` FROM `subcategories` AS `Subcategory` WHERE `Subcategory`.`categoryId` = 19 | | 1 | 1 | 1 |
| 34 | SELECT `Subcategory`.`id`, `Subcategory`.`categoryId`, `Subcategory`.`name`, `Subcategory`.`desc`, `Subcategory`.`isdefault`, `Subcategory`.`order`, `Subcategory`.`metakeyword`, `Subcategory`.`metadesc`, `Subcategory`.`url` FROM `subcategories` AS `Subcategory` WHERE `Subcategory`.`categoryId` = 20 | | 0 | 0 | 0 |
| 35 | SELECT `Subcategory`.`id`, `Subcategory`.`categoryId`, `Subcategory`.`name`, `Subcategory`.`desc`, `Subcategory`.`isdefault`, `Subcategory`.`order`, `Subcategory`.`metakeyword`, `Subcategory`.`metadesc`, `Subcategory`.`url` FROM `subcategories` AS `Subcategory` WHERE `Subcategory`.`categoryId` = 24 | | 4 | 4 | 4 |
| 36 | SELECT `Article`.`id`, `Article`.`hits`, `Article`.`heading`, `Article`.`image`, `User`.`user_name`, `Article`.`url` FROM `articles` AS `Article` LEFT JOIN `users` AS `User` ON (`User`.`id` = `Article`.`user_id`) WHERE YEARweek( `publishDate` )=YEARweek(current_DATE) AND `ispublish` = 1 AND `Article`.`categoryId` <> 24 ORDER BY `Article`.`hits` desc LIMIT 5 | | 0 | 0 | 15 |
| 37 | SELECT `Article`.`id`, `Article`.`hits`, `Article`.`heading`, `Article`.`image`, `User`.`user_name`, `Article`.`url` FROM `articles` AS `Article` LEFT JOIN `users` AS `User` ON (`User`.`id` = `Article`.`user_id`) WHERE `ispublish` = 1 AND `Article`.`categoryId` <> 24 ORDER BY `Article`.`publishDate` desc LIMIT 5 | | 5 | 5 | 1 |
| 38 | DESCRIBE `userinfos` | | 18 | 18 | 2 |
| 39 | SELECT `Userinfo`.`id` FROM `userinfos` AS `Userinfo` WHERE `Userinfo`.`featuredate` = '2012-05-17' AND `is_featured` = 1 LIMIT 1 | | 1 | 1 | 0 |
| 40 | SELECT `User`.`user_name`, `Userinfo`.`image`, `User`.`created_date` FROM `userinfos` AS `Userinfo` LEFT JOIN `users` AS `User` ON (`Userinfo`.`User_id` = `User`.`id`) WHERE `Userinfo`.`featuredate` = '2012-05-17' AND `Userinfo`.`is_featured` = 1 LIMIT 1 | | 1 | 1 | 1 |
| 41 | SELECT `Article`.`id`, `Article`.`aid`, `Article`.`wid`, `Article`.`categoryId`, `Article`.`subcategoryId`, `Article`.`metakeyword`, `Article`.`heading`, `Article`.`subject`, `Article`.`description`, `Article`.`user_id`, `Article`.`publishDate`, `Article`.`PublishDuration`, `Article`.`isActive`, `Article`.`ratings`, `Article`.`rate_count`, `Article`.`hits`, `Article`.`image`, `Article`.`image_caption`, `Article`.`video_url`, `Article`.`IsPornVideo`, `Article`.`EmbedVideoUrl`, `Article`.`isPublish`, `Article`.`isDraft`, `Article`.`emailed`, `Article`.`metadesc`, `Article`.`url`, `User`.`id`, `User`.`user_name`, `User`.`password`, `User`.`email`, `User`.`sec_ques`, `User`.`sec_ans`, `User`.`is_approved`, `User`.`created_date`, `last login`, `User`.`user_id`, `User`.`suspended` FROM `articles` AS `Article` LEFT JOIN `users` AS `User` ON (`Article`.`User_id` = `User`.`id`) WHERE `Article`.`categoryId` = 18 ORDER BY `publishDate` desc LIMIT 5 | | 5 | 5 | 3 |
| 42 | SELECT `Article`.`id`, `Article`.`aid`, `Article`.`wid`, `Article`.`categoryId`, `Article`.`subcategoryId`, `Article`.`metakeyword`, `Article`.`heading`, `Article`.`subject`, `Article`.`description`, `Article`.`user_id`, `Article`.`publishDate`, `Article`.`PublishDuration`, `Article`.`isActive`, `Article`.`ratings`, `Article`.`rate_count`, `Article`.`hits`, `Article`.`image`, `Article`.`image_caption`, `Article`.`video_url`, `Article`.`IsPornVideo`, `Article`.`EmbedVideoUrl`, `Article`.`isPublish`, `Article`.`isDraft`, `Article`.`emailed`, `Article`.`metadesc`, `Article`.`url` FROM `articles` AS `Article` WHERE `Article`.`categoryId` <> 24 ORDER BY `publishDate` desc LIMIT 1 | | 1 | 1 | 2 |
| 43 | SELECT `User`.`id`, `User`.`user_name`, `User`.`password`, `User`.`email`, `User`.`sec_ques`, `User`.`sec_ans`, `User`.`is_approved`, `User`.`created_date`, `last login`, `User`.`user_id`, `User`.`suspended`, `Userinfo`.`id`, `Userinfo`.`user_id`, `Userinfo`.`uid`, `Userinfo`.`first_name`, `Userinfo`.`last_name`, `Userinfo`.`location`, `Userinfo`.`is_active`, `Userinfo`.`rating`, `Userinfo`.`is_featured`, `Userinfo`.`image`, `Userinfo`.`homepage`, `Userinfo`.`prifile_text`, `Userinfo`.`hear_from`, `Userinfo`.`referrel_user`, `Userinfo`.`forums_count`, `Userinfo`.`terms`, `Userinfo`.`user_type`, `Userinfo`.`featuredate` FROM `users` AS `User` LEFT JOIN `userinfos` AS `Userinfo` ON (`Userinfo`.`user_id` = `User`.`id`) WHERE `User`.`id` = 889 LIMIT 1 | | 1 | 1 | 2 |
| 44 | SELECT `Article`.`id`, `Article`.`aid`, `Article`.`wid`, `Article`.`categoryId`, `Article`.`subcategoryId`, `Article`.`metakeyword`, `Article`.`heading`, `Article`.`subject`, `Article`.`description`, `Article`.`user_id`, `Article`.`publishDate`, `Article`.`PublishDuration`, `Article`.`isActive`, `Article`.`ratings`, `Article`.`rate_count`, `Article`.`hits`, `Article`.`image`, `Article`.`image_caption`, `Article`.`video_url`, `Article`.`IsPornVideo`, `Article`.`EmbedVideoUrl`, `Article`.`isPublish`, `Article`.`isDraft`, `Article`.`emailed`, `Article`.`metadesc`, `Article`.`url` FROM `articles` AS `Article` WHERE `Article`.`categoryId` <> 24 ORDER BY `publishDate` desc LIMIT 4 | | 4 | 4 | 1 |
| 45 | DESCRIBE `tags` | | 3 | 3 | 1 |
| 46 | SELECT `Tag`.`id`, `Tag`.`metakeyword`, `Tag`.`metadesc` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 1 LIMIT 1 | | 1 | 1 | 3 |