FORUM FOR THE STUDY OF THE LIVER
BANGLADESH
FORUM FOR THE STUDY OF THE LIVER
BANGLADESH
© 2016 Liver Forum. All Rights Reserved
Developed & Designed by : IPSITA COMPUTERS PTE LTD.
© 2016 Liver Forum. All Rights Reserved
Developed & Designed by : IPSITA COMPUTERS PTE LTD.
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Setting`.`id`, `Setting`.`site_title`, `Setting`.`slogan`, `Setting`.`metatags`, `Setting`.`metadisc`, `Setting`.`address`, `Setting`.`facebook`, `Setting`.`twitter`, `Setting`.`youtube`, `Setting`.`googleplus`, `Setting`.`mobile`, `Setting`.`phone`, `Setting`.`email`, `Setting`.`openingtime`, `Setting`.`readStatus` FROM `ipsitaltd_liver`.`settings` AS `Setting` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 1 | |
| 2 | SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`name`, `Menu`.`namebn`, `Menu`.`slug`, `Menu`.`url`, `Menu`.`type` FROM `ipsitaltd_liver`.`menus` AS `Menu` WHERE `Menu`.`status` = 1 ORDER BY `Menu`.`order` ASC | 26 | 26 | 1 | |
| 3 | SELECT `Committeecategory`.`id`, `Committeecategory`.`title`, `Committeecategory`.`type` FROM `ipsitaltd_liver`.`committeecategories` AS `Committeecategory` WHERE 1 = 1 ORDER BY `Committeecategory`.`serial` ASC | 0 | 0 | 1 | |
| 4 | SELECT `Content`.`id`, `Content`.`title`, `Content`.`titlebn`, `Content`.`slug`, `Content`.`contenttype_id`, `Content`.`content`, `Content`.`contentbn`, `Content`.`type`, `Content`.`created`, `Content`.`modified`, `Contenttype`.`id`, `Contenttype`.`name`, `Contenttype`.`slug`, `Contenttype`.`ctype` FROM `ipsitaltd_liver`.`contents` AS `Content` LEFT JOIN `ipsitaltd_liver`.`contenttypes` AS `Contenttype` ON (`Content`.`contenttype_id` = `Contenttype`.`id`) WHERE `Content`.`type` = 2 ORDER BY `Content`.`id` desc | 5 | 5 | 1 | |
| 5 | SELECT `Contentimage`.`id`, `Contentimage`.`content_id`, `Contentimage`.`imgTitle`, `Contentimage`.`imgTxt`, `Contentimage`.`imgTitlebn`, `Contentimage`.`imgTxtbn`, `Contentimage`.`order`, `Contentimage`.`type` FROM `ipsitaltd_liver`.`contentimages` AS `Contentimage` WHERE `Contentimage`.`content_id` IN (48, 47, 46, 2, 1) | 0 | 0 | 1 | |
| 6 | SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`namebn`, `Menu`.`slug`, `Menu`.`parent_id`, `Menu`.`type`, `Menu`.`content_id`, `Menu`.`url`, `Menu`.`role`, `Menu`.`status`, `Menu`.`order` FROM `ipsitaltd_liver`.`menus` AS `Menu` WHERE `Menu`.`content_id` IN (48, 47, 46, 2, 1) | 0 | 0 | 1 | |
| 7 | SELECT `Post`.`id`, `Post`.`subject`, `Post`.`message`, `Post`.`user_id`, `Post`.`fullName`, `Post`.`constituency`, `Post`.`email`, `Post`.`location`, `Post`.`ipAddress`, `Post`.`ext`, `Post`.`readStatus`, `Post`.`status`, `Post`.`created`, `Post`.`modified`, `User`.`id`, `User`.`subcommittee_id`, `User`.`name`, `User`.`username`, `User`.`password`, `User`.`role`, `User`.`created`, `User`.`modified`, `User`.`status` FROM `ipsitaltd_liver`.`posts` AS `Post` LEFT JOIN `ipsitaltd_liver`.`users` AS `User` ON (`Post`.`user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY `Post`.`id` DESC LIMIT 5 | 0 | 0 | 1 | |
| 8 | SELECT COUNT(`Post`.`id`) AS count FROM `ipsitaltd_liver`.`posts` AS `Post` LEFT JOIN `ipsitaltd_liver`.`users` AS `User` ON (`Post`.`user_id` = `User`.`id`) WHERE `Post`.`readStatus`='2' ORDER BY `Post`.`id` DESC | 1 | 1 | 2 | |
| 9 | SELECT `Content`.`id`, `Content`.`title`, `Content`.`titlebn`, `Content`.`slug`, `Content`.`contenttype_id`, `Content`.`content`, `Content`.`contentbn`, `Content`.`type`, `Content`.`created`, `Content`.`modified`, `Contenttype`.`id`, `Contenttype`.`name`, `Contenttype`.`slug`, `Contenttype`.`ctype` FROM `ipsitaltd_liver`.`contents` AS `Content` LEFT JOIN `ipsitaltd_liver`.`contenttypes` AS `Contenttype` ON (`Content`.`contenttype_id` = `Contenttype`.`id`) WHERE `Content`.`type` = 14 LIMIT 20 | 10 | 10 | 2 | |
| 10 | SELECT `Contentimage`.`id`, `Contentimage`.`content_id`, `Contentimage`.`imgTitle`, `Contentimage`.`imgTxt`, `Contentimage`.`imgTitlebn`, `Contentimage`.`imgTxtbn`, `Contentimage`.`order`, `Contentimage`.`type` FROM `ipsitaltd_liver`.`contentimages` AS `Contentimage` WHERE `Contentimage`.`content_id` IN (20, 21, 22, 23, 24, 25, 26, 27, 28, 29) | 0 | 0 | 1 | |
| 11 | SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`namebn`, `Menu`.`slug`, `Menu`.`parent_id`, `Menu`.`type`, `Menu`.`content_id`, `Menu`.`url`, `Menu`.`role`, `Menu`.`status`, `Menu`.`order` FROM `ipsitaltd_liver`.`menus` AS `Menu` WHERE `Menu`.`content_id` IN (20, 21, 22, 23, 24, 25, 26, 27, 28, 29) | 0 | 0 | 0 | |
| 12 | SELECT `Content`.`id`, `Content`.`title`, `Content`.`titlebn`, `Content`.`slug`, `Content`.`contenttype_id`, `Content`.`content`, `Content`.`contentbn`, `Content`.`type`, `Content`.`created`, `Content`.`modified` FROM `ipsitaltd_liver`.`contents` AS `Content` WHERE `Content`.`type` = 6 LIMIT 3 | 1 | 1 | 0 |