Advertisements

Awal | « previous 1 | 2 | 3 | 4 | 5 | 6 | 7 | Akhir
Halaman 1 dari 7, ditampilkan 10 rekord dari 66 total, dimulai pada rekord 1, berakhir pada 10
Get the Flash Player to see this player.
(default) 36 queries took 226 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `advertisements`991
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
3SHOW FULL COLUMNS FROM `members`28281
4SHOW FULL COLUMNS FROM `religions`220
5SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';110
6SHOW FULL COLUMNS FROM `employments`220
7SHOW FULL COLUMNS FROM `member_statuses`220
8SHOW FULL COLUMNS FROM `propinsi`220
9SHOW FULL COLUMNS FROM `kota_kabupaten`440
10SHOW FULL COLUMNS FROM `card_types`440
11SHOW FULL COLUMNS FROM `cards`991
12SHOW FULL COLUMNS FROM `card_statuses`221
13SHOW FULL COLUMNS FROM `advertisement_categories`660
14SHOW FULL COLUMNS FROM `advertisement_buyers`770
15SHOW FULL COLUMNS FROM `transactions`550
16SHOW FULL COLUMNS FROM `transaction_types`220
17SHOW FULL COLUMNS FROM `transaction_mutations`550
18SHOW FULL COLUMNS FROM `advertisement_photos`660
19SHOW FULL COLUMNS FROM `online`550
20SELECT `Online`.`id`, `Online`.`tanggal`, `Online`.`ip`, `Online`.`browser`, `Online`.`referer` FROM `online` AS `Online` WHERE `ip` = '54.163.83.95' AND date(tanggal) = '2015-04-21' LIMIT 10057
21INSERT INTO `online` (`ip`, `tanggal`, `browser`, `referer`) VALUES ('54.163.83.95', '2015-04-21 14:56:51', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '')1150
22SELECT LAST_INSERT_ID() AS insertID110
23SELECT COUNT(*) AS `count` FROM `advertisements` AS `Advertisement` LEFT JOIN `members` AS `Member` ON (`Advertisement`.`member_id` = `Member`.`id`) LEFT JOIN `advertisement_categories` AS `AdvertisementCategory` ON (`Advertisement`.`advertisement_category_id` = `AdvertisementCategory`.`id`) LEFT JOIN `propinsi` AS `Propinsi` ON (`Propinsi`.`propinsi_id` = `Member`.`province`) LEFT JOIN `kota_kabupaten` AS `Kota` ON (`Kota`.`id` = `Member`.`regency`) WHERE 1 = 1 111
24SELECT `Advertisement`.`created`, `Advertisement`.`id`, `Advertisement`.`title`, `Advertisement`.`description`, `AdvertisementCategory`.`name`, `Advertisement`.`price`, `Member`.`username`, `Member`.`name`, `Propinsi`.`propinsi`, `Kota`.`kota_kabupaten` FROM `advertisements` AS `Advertisement` LEFT JOIN `members` AS `Member` ON (`Advertisement`.`member_id` = `Member`.`id`) LEFT JOIN `advertisement_categories` AS `AdvertisementCategory` ON (`Advertisement`.`advertisement_category_id` = `AdvertisementCategory`.`id`) LEFT JOIN `propinsi` AS `Propinsi` ON (`Propinsi`.`propinsi_id` = `Member`.`province`) LEFT JOIN `kota_kabupaten` AS `Kota` ON (`Kota`.`id` = `Member`.`regency`) WHERE 1 = 1 ORDER BY `Advertisement`.`id` DESC LIMIT 1010108
25SELECT `AdvertisementPhoto`.`id`, `AdvertisementPhoto`.`advertisement_id`, `AdvertisementPhoto`.`title`, `AdvertisementPhoto`.`primary`, `AdvertisementPhoto`.`path`, `AdvertisementPhoto`.`created` FROM `advertisement_photos` AS `AdvertisementPhoto` WHERE ((`AdvertisementPhoto`.`primary` = 1) OR (`AdvertisementPhoto`.`primary` IS NULL)) AND `AdvertisementPhoto`.`advertisement_id` = (79) ORDER BY `AdvertisementPhoto`.`primary` DESC, `AdvertisementPhoto`.`id` ASC LIMIT 1000
26SELECT `AdvertisementPhoto`.`id`, `AdvertisementPhoto`.`advertisement_id`, `AdvertisementPhoto`.`title`, `AdvertisementPhoto`.`primary`, `AdvertisementPhoto`.`path`, `AdvertisementPhoto`.`created` FROM `advertisement_photos` AS `AdvertisementPhoto` WHERE ((`AdvertisementPhoto`.`primary` = 1) OR (`AdvertisementPhoto`.`primary` IS NULL)) AND `AdvertisementPhoto`.`advertisement_id` = (78) ORDER BY `AdvertisementPhoto`.`primary` DESC, `AdvertisementPhoto`.`id` ASC LIMIT 1000
27SELECT `AdvertisementPhoto`.`id`, `AdvertisementPhoto`.`advertisement_id`, `AdvertisementPhoto`.`title`, `AdvertisementPhoto`.`primary`, `AdvertisementPhoto`.`path`, `AdvertisementPhoto`.`created` FROM `advertisement_photos` AS `AdvertisementPhoto` WHERE ((`AdvertisementPhoto`.`primary` = 1) OR (`AdvertisementPhoto`.`primary` IS NULL)) AND `AdvertisementPhoto`.`advertisement_id` = (77) ORDER BY `AdvertisementPhoto`.`primary` DESC, `AdvertisementPhoto`.`id` ASC LIMIT 1000
28SELECT `AdvertisementPhoto`.`id`, `AdvertisementPhoto`.`advertisement_id`, `AdvertisementPhoto`.`title`, `AdvertisementPhoto`.`primary`, `AdvertisementPhoto`.`path`, `AdvertisementPhoto`.`created` FROM `advertisement_photos` AS `AdvertisementPhoto` WHERE ((`AdvertisementPhoto`.`primary` = 1) OR (`AdvertisementPhoto`.`primary` IS NULL)) AND `AdvertisementPhoto`.`advertisement_id` = (76) ORDER BY `AdvertisementPhoto`.`primary` DESC, `AdvertisementPhoto`.`id` ASC LIMIT 1000
29SELECT `AdvertisementPhoto`.`id`, `AdvertisementPhoto`.`advertisement_id`, `AdvertisementPhoto`.`title`, `AdvertisementPhoto`.`primary`, `AdvertisementPhoto`.`path`, `AdvertisementPhoto`.`created` FROM `advertisement_photos` AS `AdvertisementPhoto` WHERE ((`AdvertisementPhoto`.`primary` = 1) OR (`AdvertisementPhoto`.`primary` IS NULL)) AND `AdvertisementPhoto`.`advertisement_id` = (73) ORDER BY `AdvertisementPhoto`.`primary` DESC, `AdvertisementPhoto`.`id` ASC LIMIT 1000
30SELECT `AdvertisementPhoto`.`id`, `AdvertisementPhoto`.`advertisement_id`, `AdvertisementPhoto`.`title`, `AdvertisementPhoto`.`primary`, `AdvertisementPhoto`.`path`, `AdvertisementPhoto`.`created` FROM `advertisement_photos` AS `AdvertisementPhoto` WHERE ((`AdvertisementPhoto`.`primary` = 1) OR (`AdvertisementPhoto`.`primary` IS NULL)) AND `AdvertisementPhoto`.`advertisement_id` = (72) ORDER BY `AdvertisementPhoto`.`primary` DESC, `AdvertisementPhoto`.`id` ASC LIMIT 1000
31SELECT `AdvertisementPhoto`.`id`, `AdvertisementPhoto`.`advertisement_id`, `AdvertisementPhoto`.`title`, `AdvertisementPhoto`.`primary`, `AdvertisementPhoto`.`path`, `AdvertisementPhoto`.`created` FROM `advertisement_photos` AS `AdvertisementPhoto` WHERE ((`AdvertisementPhoto`.`primary` = 1) OR (`AdvertisementPhoto`.`primary` IS NULL)) AND `AdvertisementPhoto`.`advertisement_id` = (71) ORDER BY `AdvertisementPhoto`.`primary` DESC, `AdvertisementPhoto`.`id` ASC LIMIT 1000
32SELECT `AdvertisementPhoto`.`id`, `AdvertisementPhoto`.`advertisement_id`, `AdvertisementPhoto`.`title`, `AdvertisementPhoto`.`primary`, `AdvertisementPhoto`.`path`, `AdvertisementPhoto`.`created` FROM `advertisement_photos` AS `AdvertisementPhoto` WHERE ((`AdvertisementPhoto`.`primary` = 1) OR (`AdvertisementPhoto`.`primary` IS NULL)) AND `AdvertisementPhoto`.`advertisement_id` = (70) ORDER BY `AdvertisementPhoto`.`primary` DESC, `AdvertisementPhoto`.`id` ASC LIMIT 1000
33SELECT `AdvertisementPhoto`.`id`, `AdvertisementPhoto`.`advertisement_id`, `AdvertisementPhoto`.`title`, `AdvertisementPhoto`.`primary`, `AdvertisementPhoto`.`path`, `AdvertisementPhoto`.`created` FROM `advertisement_photos` AS `AdvertisementPhoto` WHERE ((`AdvertisementPhoto`.`primary` = 1) OR (`AdvertisementPhoto`.`primary` IS NULL)) AND `AdvertisementPhoto`.`advertisement_id` = (69) ORDER BY `AdvertisementPhoto`.`primary` DESC, `AdvertisementPhoto`.`id` ASC LIMIT 1000
34SELECT `AdvertisementPhoto`.`id`, `AdvertisementPhoto`.`advertisement_id`, `AdvertisementPhoto`.`title`, `AdvertisementPhoto`.`primary`, `AdvertisementPhoto`.`path`, `AdvertisementPhoto`.`created` FROM `advertisement_photos` AS `AdvertisementPhoto` WHERE ((`AdvertisementPhoto`.`primary` = 1) OR (`AdvertisementPhoto`.`primary` IS NULL)) AND `AdvertisementPhoto`.`advertisement_id` = (68) ORDER BY `AdvertisementPhoto`.`primary` DESC, `AdvertisementPhoto`.`id` ASC LIMIT 1000
35SELECT `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 1116
36SELECT `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