© 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 | 2 | |
| 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 | 6 | |
| 3 | SELECT `Committeecategory`.`id`, `Committeecategory`.`title`, `Committeecategory`.`type` FROM `ipsitaltd_liver`.`committeecategories` AS `Committeecategory` WHERE 1 = 1 ORDER BY `Committeecategory`.`serial` ASC | 0 | 0 | 3 | |
| 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 | 3 | |
| 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 | 2 | |
| 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 | 19 | |
| 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` FROM `ipsitaltd_liver`.`contents` AS `Content` WHERE `Content`.`type` = 8 LIMIT 1 | 1 | 1 | 2 | |
| 10 | 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 ORDER BY `id` DESC LIMIT 20 | 1 | 1 | 1 | |
| 11 | 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` = '' LIMIT 5 | 0 | 0 | 1 | |
| 12 | SELECT `Derectory`.`id`, `Derectory`.`links`, `Derectory`.`name` FROM `ipsitaltd_liver`.`derectories` AS `Derectory` WHERE 1 = 1 LIMIT 3 | 0 | 0 | 29 | |
| 13 | SELECT `Doctor`.`id`, `Doctor`.`contenttype_id`, `Doctor`.`type`, `Doctor`.`name`, `Doctor`.`degree`, `Doctor`.`designation`, `Doctor`.`created`, `Doctor`.`modified`, `Doctor`.`status`, `Doctor`.`order` FROM `ipsitaltd_liver`.`doctors` AS `Doctor` WHERE `Doctor`.`type` = '1' ORDER BY `Doctor`.`order` ASC | 12 | 12 | 2 | |
| 14 | SELECT `Metting`.`id`, `Metting`.`type`, `Metting`.`committeecategory_id`, `Metting`.`resultid`, `Metting`.`title`, `Metting`.`date`, `Metting`.`time`, `Metting`.`venue`, `Metting`.`content`, `Metting`.`ext`, `Metting`.`reportext`, `Metting`.`created`, `Metting`.`modified`, `Committeecategory`.`id`, `Committeecategory`.`serial`, `Committeecategory`.`title`, `Committeecategory`.`activity`, `Committeecategory`.`object`, `Committeecategory`.`type`, `Committeecategory`.`status`, `Committeecategory`.`created`, `Committeecategory`.`modified` FROM `ipsitaltd_liver`.`mettings` AS `Metting` LEFT JOIN `ipsitaltd_liver`.`committeecategories` AS `Committeecategory` ON (`Metting`.`committeecategory_id` = `Committeecategory`.`id`) WHERE date>'2026-07-15' ORDER BY `Metting`.`id` desc LIMIT 3 | 0 | 0 | 3 |