Testimonial Member

Get the Flash Player to see this player.
(default) 11 queries took 70 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `testimonial`661
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
3SHOW FULL COLUMNS FROM `online`550
4SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';110
5SELECT `Online`.`id`, `Online`.`tanggal`, `Online`.`ip`, `Online`.`browser`, `Online`.`referer` FROM `online` AS `Online` WHERE `ip` = '54.211.62.182' AND date(tanggal) = '2015-03-03' LIMIT 1000
6INSERT INTO `online` (`ip`, `tanggal`, `browser`, `referer`) VALUES ('54.211.62.182', '2015-03-03 17:52:53', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '')168
7SELECT LAST_INSERT_ID() AS insertID110
8SELECT COUNT(*) AS `count` FROM `testimonial` AS `Testimonial` left JOIN `members` AS `Member` ON (`Member`.`id` = `Testimonial`.`member_id`) left JOIN `member_images` AS `MemberImage` ON (`MemberImage`.`member_id` = `Testimonial`.`member_id`) WHERE `Testimonial`.`status` = 1 110
9SELECT `Testimonial`.*, `Member`.`username`, `Member`.`name`, `MemberImage`.`path` FROM `testimonial` AS `Testimonial` left JOIN `members` AS `Member` ON (`Member`.`id` = `Testimonial`.`member_id`) left JOIN `member_images` AS `MemberImage` ON (`MemberImage`.`member_id` = `Testimonial`.`member_id`) WHERE `Testimonial`.`status` = 1 ORDER BY `Testimonial`.`id` DESC LIMIT 5000
10SELECT `News`.*, `User`.`username`, `I18n__judul`.`content`, `I18n__content`.`content`, `News`.`id` FROM `news` AS `News` INNER JOIN `i18n` AS `I18n__judul` ON (`News`.`id` = `I18n__judul`.`foreign_key` AND `I18n__judul`.`model` = 'News' AND `I18n__judul`.`field` = 'judul' AND `I18n__judul`.`locale` = 'ind') INNER JOIN `i18n` AS `I18n__content` ON (`News`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'News' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'ind') LEFT JOIN `users` AS `User` ON (`News`.`user_id` = `User`.`id`) LEFT JOIN `category` AS `Category` ON (`News`.`category_id` = `Category`.`id`) WHERE 1 = 1 ORDER BY `News`.`tanggal` DESC LIMIT 1111
11SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`lft`, `Comment`.`rght`, `Comment`.`news_id`, `Comment`.`created`, `Comment`.`name`, `Comment`.`email`, `Comment`.`url`, `Comment`.`comment`, `Comment`.`ip`, `Comment`.`useragent`, `Comment`.`status`, `Comment`.`is_spam` FROM `comments` AS `Comment` WHERE `Comment`.`news_id` = (62) LIMIT 20110