Facebook


Telephone: (505) 690-5858 (Mark Bentley)
mark@307netradio.com
59 North Lobban
Buffalo, Wy 82834

(default) 39 queries took 78 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Placement`.`id`, `Placement`.`place` FROM `netradio_live`.`placements` AS `Placement` WHERE `Placement`.`ad_type` = 'image' AND `Placement`.`active` = 110100
2SELECT `AdsPlacement`.`ad_id`, `AdsPlacement`.`placement_id` FROM `netradio_live`.`ads_placements` AS `AdsPlacement` LEFT JOIN `netradio_live`.`ads` AS `Ad` ON (`AdsPlacement`.`ad_id` = `Ad`.`id`) LEFT JOIN `netradio_live`.`placements` AS `Placement` ON (`AdsPlacement`.`placement_id` = `Placement`.`id`) WHERE `AdsPlacement`.`placement_id` IN (1, 2, 3, 4, 5, 6, 7, 11, 12, 13) GROUP BY `AdsPlacement`.`placement_id` ORDER BY rand() ASC660
3SELECT `Ad`.`id`, `Ad`.`user_id`, `Ad`.`ad_size`, `Ad`.`image`, `Ad`.`ad_type`, `Ad`.`link`, `Ad`.`link_target`, `Ad`.`from_date`, `Ad`.`to_date`, `Ad`.`status`, `Ad`.`paid`, `Ad`.`price`, `Ad`.`active` FROM `netradio_live`.`ads` AS `Ad` WHERE `Ad`.`id` = 16000
4SELECT `Ad`.`id`, `Ad`.`user_id`, `Ad`.`ad_size`, `Ad`.`image`, `Ad`.`ad_type`, `Ad`.`link`, `Ad`.`link_target`, `Ad`.`from_date`, `Ad`.`to_date`, `Ad`.`status`, `Ad`.`paid`, `Ad`.`price`, `Ad`.`active` FROM `netradio_live`.`ads` AS `Ad` WHERE `Ad`.`id` = 17000
5SELECT `Ad`.`id`, `Ad`.`user_id`, `Ad`.`ad_size`, `Ad`.`image`, `Ad`.`ad_type`, `Ad`.`link`, `Ad`.`link_target`, `Ad`.`from_date`, `Ad`.`to_date`, `Ad`.`status`, `Ad`.`paid`, `Ad`.`price`, `Ad`.`active` FROM `netradio_live`.`ads` AS `Ad` WHERE `Ad`.`id` = 18000
6SELECT `Ad`.`id`, `Ad`.`user_id`, `Ad`.`ad_size`, `Ad`.`image`, `Ad`.`ad_type`, `Ad`.`link`, `Ad`.`link_target`, `Ad`.`from_date`, `Ad`.`to_date`, `Ad`.`status`, `Ad`.`paid`, `Ad`.`price`, `Ad`.`active` FROM `netradio_live`.`ads` AS `Ad` WHERE `Ad`.`id` = 14000
7SELECT `Ad`.`id`, `Ad`.`user_id`, `Ad`.`ad_size`, `Ad`.`image`, `Ad`.`ad_type`, `Ad`.`link`, `Ad`.`link_target`, `Ad`.`from_date`, `Ad`.`to_date`, `Ad`.`status`, `Ad`.`paid`, `Ad`.`price`, `Ad`.`active` FROM `netradio_live`.`ads` AS `Ad` WHERE `Ad`.`id` = 15000
8SELECT `Ad`.`id`, `Ad`.`user_id`, `Ad`.`ad_size`, `Ad`.`image`, `Ad`.`ad_type`, `Ad`.`link`, `Ad`.`link_target`, `Ad`.`from_date`, `Ad`.`to_date`, `Ad`.`status`, `Ad`.`paid`, `Ad`.`price`, `Ad`.`active` FROM `netradio_live`.`ads` AS `Ad` WHERE `Ad`.`id` = 19000
9SELECT `Placement`.`id`, `Placement`.`place`, `Placement`.`description`, `Placement`.`size_id`, `Placement`.`price`, `Placement`.`ad_type`, `Placement`.`image`, `Placement`.`link`, `Placement`.`link_target`, `Placement`.`active` FROM `netradio_live`.`placements` AS `Placement` WHERE `Placement`.`id` = 11110
10SELECT `Size`.`id`, `Size`.`size`, `Size`.`active` FROM `netradio_live`.`sizes` AS `Size` WHERE `Size`.`id` = 2110
11SELECT `AdsPlacement`.`id`, `AdsPlacement`.`ad_id`, `AdsPlacement`.`placement_id` FROM `netradio_live`.`ads_placements` AS `AdsPlacement` WHERE `AdsPlacement`.`placement_id` = (11)110
12SELECT `Placement`.`id`, `Placement`.`place`, `Placement`.`description`, `Placement`.`size_id`, `Placement`.`price`, `Placement`.`ad_type`, `Placement`.`image`, `Placement`.`link`, `Placement`.`link_target`, `Placement`.`active` FROM `netradio_live`.`placements` AS `Placement` WHERE `Placement`.`id` = 2110
13SELECT `Size`.`id`, `Size`.`size`, `Size`.`active` FROM `netradio_live`.`sizes` AS `Size` WHERE `Size`.`id` = 5110
14SELECT `AdsPlacement`.`id`, `AdsPlacement`.`ad_id`, `AdsPlacement`.`placement_id` FROM `netradio_live`.`ads_placements` AS `AdsPlacement` WHERE `AdsPlacement`.`placement_id` = (2)110
15SELECT `Placement`.`id`, `Placement`.`place`, `Placement`.`description`, `Placement`.`size_id`, `Placement`.`price`, `Placement`.`ad_type`, `Placement`.`image`, `Placement`.`link`, `Placement`.`link_target`, `Placement`.`active` FROM `netradio_live`.`placements` AS `Placement` WHERE `Placement`.`id` = 6110
16SELECT `Size`.`id`, `Size`.`size`, `Size`.`active` FROM `netradio_live`.`sizes` AS `Size` WHERE `Size`.`id` = 2110
17SELECT `AdsPlacement`.`id`, `AdsPlacement`.`ad_id`, `AdsPlacement`.`placement_id` FROM `netradio_live`.`ads_placements` AS `AdsPlacement` WHERE `AdsPlacement`.`placement_id` = (6)110
18SELECT `Placement`.`id`, `Placement`.`place`, `Placement`.`description`, `Placement`.`size_id`, `Placement`.`price`, `Placement`.`ad_type`, `Placement`.`image`, `Placement`.`link`, `Placement`.`link_target`, `Placement`.`active` FROM `netradio_live`.`placements` AS `Placement` WHERE `Placement`.`id` = 3110
19SELECT `Size`.`id`, `Size`.`size`, `Size`.`active` FROM `netradio_live`.`sizes` AS `Size` WHERE `Size`.`id` = 2110
20SELECT `AdsPlacement`.`id`, `AdsPlacement`.`ad_id`, `AdsPlacement`.`placement_id` FROM `netradio_live`.`ads_placements` AS `AdsPlacement` WHERE `AdsPlacement`.`placement_id` = (3)110
21SELECT `Placement`.`id`, `Placement`.`place`, `Placement`.`description`, `Placement`.`size_id`, `Placement`.`price`, `Placement`.`ad_type`, `Placement`.`image`, `Placement`.`link`, `Placement`.`link_target`, `Placement`.`active` FROM `netradio_live`.`placements` AS `Placement` WHERE `Placement`.`id` = 1110
22SELECT `Size`.`id`, `Size`.`size`, `Size`.`active` FROM `netradio_live`.`sizes` AS `Size` WHERE `Size`.`id` = 5110
23SELECT `AdsPlacement`.`id`, `AdsPlacement`.`ad_id`, `AdsPlacement`.`placement_id` FROM `netradio_live`.`ads_placements` AS `AdsPlacement` WHERE `AdsPlacement`.`placement_id` = (1)110
24SELECT `Placement`.`id`, `Placement`.`place`, `Placement`.`description`, `Placement`.`size_id`, `Placement`.`price`, `Placement`.`ad_type`, `Placement`.`image`, `Placement`.`link`, `Placement`.`link_target`, `Placement`.`active` FROM `netradio_live`.`placements` AS `Placement` WHERE `Placement`.`id` = 13110
25SELECT `Size`.`id`, `Size`.`size`, `Size`.`active` FROM `netradio_live`.`sizes` AS `Size` WHERE `Size`.`id` = 2110
26SELECT `AdsPlacement`.`id`, `AdsPlacement`.`ad_id`, `AdsPlacement`.`placement_id` FROM `netradio_live`.`ads_placements` AS `AdsPlacement` WHERE `AdsPlacement`.`placement_id` = (13)110
27SELECT `Category`.`id`, `Category`.`name` FROM `netradio_live`.`categories` AS `Category` WHERE 1 = 1440
28SELECT `ClassifiedCategory`.`id`, `ClassifiedCategory`.`name` FROM `netradio_live`.`classified_categories` AS `ClassifiedCategory` WHERE 1 = 1550
29SELECT `Article`.`id`, `Article`.`title`, `Article`.`slug`, `Article`.`excerpt`, `Article`.`article`, `Article`.`article_date`, `Article`.`hide_date`, `Article`.`large_image`, `Article`.`medium_image`, `Article`.`small_image`, `Article`.`mini_image`, `Article`.`views`, `Article`.`url`, `Article`.`target`, `Article`.`active`, `Article`.`ismain`, `Article`.`created`, `Article`.`modified` FROM `netradio_live`.`articles` AS `Article` WHERE 1 = 1 ORDER BY `Article`.`article_date` DESC9159158
30SELECT `Category`.`id`, `Category`.`name`, `Category`.`image`, `Category`.`description` FROM `netradio_live`.`categories` AS `Category` WHERE 1 = 1440
31SELECT `Event`.`id`, `Event`.`title`, `Event`.`description`, `Event`.`active`, `Event`.`event_date`, `Event`.`url`, `Event`.`target` FROM `netradio_live`.`events` AS `Event` WHERE `Event`.`event_date` > '2016-12-04' ORDER BY `Event`.`event_date` ASC000
32INSERT INTO `netradio_live`.`logs_pageviews` (`tstamp`, `request_uri`, `ip_addr`, `referer`) VALUES ('2016-12-04 03:35:47', '/', '54.159.231.135', '')1168
33SELECT `Ad`.`id`, `Ad`.`user_id`, `Ad`.`ad_size`, `Ad`.`image`, `Ad`.`ad_type`, `Ad`.`link`, `Ad`.`link_target`, `Ad`.`from_date`, `Ad`.`to_date`, `Ad`.`status`, `Ad`.`paid`, `Ad`.`price`, `Ad`.`active` FROM `netradio_live`.`ads` AS `Ad` WHERE `Ad`.`active` = 1 AND `Ad`.`status` = 'approved' AND `Ad`.`from_date` <= '2016-12-04' AND `Ad`.`to_date` >= '2016-12-04' ORDER BY rand() ASC15151
34BEGIN15151
35INSERT INTO `netradio_live`.`ads_logs` (`ad_id`, `remote_addr`, `ads_placements_id`) VALUES (31, '54.159.231.135', 3)110
36INSERT INTO `netradio_live`.`ads_logs` (`ad_id`, `remote_addr`, `ads_placements_id`) VALUES (57, '54.159.231.135', 11)110
37INSERT INTO `netradio_live`.`ads_logs` (`ad_id`, `remote_addr`, `ads_placements_id`) VALUES (54, '54.159.231.135', 5)110
38COMMIT110
39SELECT `Ondemands`.`id`, `Ondemands`.`showtitle_id`, `Ondemands`.`user_id`, `Ondemands`.`title`, `Ondemands`.`link`, `Ondemands`.`show_date`, `Ondemands`.`tags`, `Ondemands`.`logo`, `Ondemands`.`featured`, `Ondemands`.`active`, `Ondemands`.`datetime`, `Ondemands`.`views`, `Ondemands`.`plays` FROM `netradio_live`.`ondemands` AS `Ondemands` WHERE 1 = 1 ORDER BY `show_date` DESC LIMIT 1010100