1 | SHOW FULL COLUMNS FROM `topics` | | 23 | 23 | 1 |
2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | | 1 | 1 | 0 |
3 | SHOW FULL COLUMNS FROM `entries` | | 12 | 12 | 0 |
4 | SHOW FULL COLUMNS FROM `logs` | | 5 | 5 | 0 |
5 | SHOW FULL COLUMNS FROM `users` | | 15 | 15 | 1 |
6 | INSERT INTO logs (url, unique_id, refer) VALUES ('/16_kids_who_are_not_excited_for_halloween/7473', '707058287507787c063217', '-') | | 1 | | 0 |
7 | SELECT `Entry`.`id`, `Entry`.`topic_id`, `Entry`.`user_id`, `Entry`.`created`, `Entry`.`title`, `Entry`.`media`, `Entry`.`link`, `Entry`.`full_size`, `Entry`.`image_server`, `Entry`.`type`, `Entry`.`description`, `Entry`.`visible` FROM `entries` AS `Entry` WHERE `Entry`.`id` = 7473 LIMIT 1 | | 1 | 1 | 0 |
8 | SELECT `Topic`.`id`, `Topic`.`user_id`, `Topic`.`created`, `Topic`.`type`, `Topic`.`title`, `Topic`.`title_url`, `Topic`.`image`, `Topic`.`image_server`, `Topic`.`link`, `Topic`.`category`, `Topic`.`write_yourself`, `Topic`.`diggs`, `Topic`.`description`, `Topic`.`description_fb`, `Topic`.`likes_fb`, `Topic`.`shares_fb`, `Topic`.`comments_fb`, `Topic`.`clicks_fb`, `Topic`.`posted_fb`, `Topic`.`moderate`, `Topic`.`auto_post`, `Topic`.`modified`, `Topic`.`visible` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 1842 LIMIT 1 | | 1 | 1 | 0 |
9 | SELECT `Entry`.`id`, `Entry`.`topic_id`, `Entry`.`user_id`, `Entry`.`created`, `Entry`.`title`, `Entry`.`media`, `Entry`.`link`, `Entry`.`full_size`, `Entry`.`image_server`, `Entry`.`type`, `Entry`.`description`, `Entry`.`visible` FROM `entries` AS `Entry` WHERE `topic_id` = 1842 | | 16 | 16 | 0 |
10 | SHOW FULL COLUMNS FROM `analytics` | | 7 | 7 | 1 |
11 | SHOW FULL COLUMNS FROM `refers` | | 6 | 6 | 0 |
12 | SHOW FULL COLUMNS FROM `seo_urls` | | 3 | 3 | 0 |
13 | SELECT `Analytic`.`id`, `Analytic`.`category`, `Analytic`.`unique_id`, `Analytic`.`ctr`, `Analytic`.`display`, `Analytic`.`weight`, `Analytic`.`visible` FROM `analytics` AS `Analytic` WHERE `category` = 1 AND `unique_id` <> '1842' ORDER BY (weight * rand()) DESC LIMIT 1 | | 0 | 0 | 0 |
14 | SELECT `Analytic`.`id`, `Analytic`.`category`, `Analytic`.`unique_id`, `Analytic`.`ctr`, `Analytic`.`display`, `Analytic`.`weight`, `Analytic`.`visible` FROM `analytics` AS `Analytic` WHERE `category` = 1 ORDER BY (weight * rand()) DESC LIMIT 1 | | 1 | 1 | 0 |
15 | UPDATE analytics SET display = display + 1 WHERE id = '1796' | | 1 | | 0 |
16 | SELECT `Topic`.`id`, `Topic`.`user_id`, `Topic`.`created`, `Topic`.`type`, `Topic`.`title`, `Topic`.`title_url`, `Topic`.`image`, `Topic`.`image_server`, `Topic`.`link`, `Topic`.`category`, `Topic`.`write_yourself`, `Topic`.`diggs`, `Topic`.`description`, `Topic`.`description_fb`, `Topic`.`likes_fb`, `Topic`.`shares_fb`, `Topic`.`comments_fb`, `Topic`.`clicks_fb`, `Topic`.`posted_fb`, `Topic`.`moderate`, `Topic`.`auto_post`, `Topic`.`modified`, `Topic`.`visible` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 1842 LIMIT 1 | | 1 | 1 | 0 |