Search
(default) 53 queries took 75 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `onsale_coupons_categories`331
2DESCRIBE `onsale_coupons_categories_divisions`221
3DESCRIBE `onsale_coupons`14141
4DESCRIBE `onsale_merchants`12121
5DESCRIBE `sales_people`551
6DESCRIBE `onsale_merchants_addresses`12121
7DESCRIBE `onsale_merchants_addresses_cities`221
8DESCRIBE `merchant_categories`661
9DESCRIBE `merchant_categories_onsale_merchants`331
10DESCRIBE `onsale_coupons_views`661
11DESCRIBE `onsale_coupons_onsale_coupons_categories`331
12DESCRIBE `special_sections`11112
13DESCRIBE `popular_links`991
14DESCRIBE `about_us_comments`881
15DESCRIBE `contests`15151
16DESCRIBE `contest_icons`331
17DESCRIBE `contest_winners`11111
18DESCRIBE `contest_archives`12121
19DESCRIBE `contest_categories`331
20DESCRIBE `contest_categories_contests`331
21DESCRIBE `contest_archives_contest_categories`331
22SELECT `OnsaleCoupon`.`id`, `OnsaleCoupon`.`onsale_merchant_id` FROM `onsale_coupons` AS `OnsaleCoupon` WHERE `OnsaleCoupon`.`datestart` <= CURDATE() AND `OnsaleCoupon`.`dateend` >= CURDATE() ORDER BY `OnsaleCoupon`.`created` DESC 67671
23SELECT `OnsaleCoupon`.`id`, `OnsaleCoupon`.`onsale_merchant_id`, `OnsaleCoupon`.`title`, `OnsaleCoupon`.`content`, `OnsaleCoupon`.`extended_content`, `OnsaleCoupon`.`datestart`, `OnsaleCoupon`.`dateend`, `OnsaleCoupon`.`retail_price`, `OnsaleCoupon`.`sale_price`, `OnsaleCoupon`.`conditions`, `OnsaleCoupon`.`img1`, `OnsaleCoupon`.`img2`, `OnsaleCoupon`.`created`, `OnsaleCoupon`.`modified`, `OnsaleMerchant`.`id`, `OnsaleMerchant`.`name`, `OnsaleMerchant`.`website`, `OnsaleMerchant`.`about_us`, `OnsaleMerchant`.`hours`, `OnsaleMerchant`.`logo`, `OnsaleMerchant`.`img1`, `OnsaleMerchant`.`img2`, `OnsaleMerchant`.`menu`, `OnsaleMerchant`.`sales_person_id`, `OnsaleMerchant`.`contact_name`, `OnsaleMerchant`.`contact_email` FROM `onsale_coupons` AS `OnsaleCoupon` LEFT JOIN `onsale_merchants` AS `OnsaleMerchant` ON (`OnsaleCoupon`.`onsale_merchant_id` = `OnsaleMerchant`.`id`) WHERE `OnsaleCoupon`.`id` = 204 ORDER BY `OnsaleCoupon`.`created` DESC LIMIT 1112
24SELECT `OnsaleCouponsView`.`id`, `OnsaleCouponsView`.`date`, `OnsaleCouponsView`.`onsale_coupon_id`, `OnsaleCouponsView`.`screen_views`, `OnsaleCouponsView`.`print_view`, `OnsaleCouponsView`.`mobile_view` FROM `onsale_coupons_views` AS `OnsaleCouponsView` WHERE `OnsaleCouponsView`.`onsale_coupon_id` = (204) 1661664
25SELECT `OnsaleCouponsCategory`.`id`, `OnsaleCouponsCategory`.`title`, `OnsaleCouponsCategory`.`onsale_coupons_categories_division_id`, `OnsaleCouponsOnsaleCouponsCategory`.`id`, `OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupon_id`, `OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupons_category_id` FROM `onsale_coupons_categories` AS `OnsaleCouponsCategory` JOIN `onsale_coupons_onsale_coupons_categories` AS `OnsaleCouponsOnsaleCouponsCategory` ON (`OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupon_id` = 204 AND `OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupons_category_id` = `OnsaleCouponsCategory`.`id`) WHERE 1 = 1 991
26SELECT `OnsaleMerchant`.`id`, `OnsaleMerchant`.`name`, `OnsaleMerchant`.`website`, `OnsaleMerchant`.`about_us`, `OnsaleMerchant`.`hours`, `OnsaleMerchant`.`logo`, `OnsaleMerchant`.`img1`, `OnsaleMerchant`.`img2`, `OnsaleMerchant`.`menu`, `OnsaleMerchant`.`sales_person_id`, `OnsaleMerchant`.`contact_name`, `OnsaleMerchant`.`contact_email`, `SalesPerson`.`id`, `SalesPerson`.`first_name`, `SalesPerson`.`last_name`, `SalesPerson`.`email`, `SalesPerson`.`phone` FROM `onsale_merchants` AS `OnsaleMerchant` LEFT JOIN `sales_people` AS `SalesPerson` ON (`OnsaleMerchant`.`sales_person_id` = `SalesPerson`.`id`) WHERE `OnsaleMerchant`.`id` = 58 ORDER BY `OnsaleMerchant`.`name` ASC LIMIT 1111
27SELECT `SalesPerson`.`id`, `SalesPerson`.`first_name`, `SalesPerson`.`last_name`, `SalesPerson`.`email`, `SalesPerson`.`phone` FROM `sales_people` AS `SalesPerson` WHERE `SalesPerson`.`id` = 3 111
28SELECT `OnsaleMerchant`.`id`, `OnsaleMerchant`.`name`, `OnsaleMerchant`.`website`, `OnsaleMerchant`.`about_us`, `OnsaleMerchant`.`hours`, `OnsaleMerchant`.`logo`, `OnsaleMerchant`.`img1`, `OnsaleMerchant`.`img2`, `OnsaleMerchant`.`menu`, `OnsaleMerchant`.`sales_person_id`, `OnsaleMerchant`.`contact_name`, `OnsaleMerchant`.`contact_email` FROM `onsale_merchants` AS `OnsaleMerchant` WHERE `OnsaleMerchant`.`sales_person_id` = (3) 11113
29SELECT `OnsaleCoupon`.`id`, `OnsaleCoupon`.`onsale_merchant_id`, `OnsaleCoupon`.`title`, `OnsaleCoupon`.`content`, `OnsaleCoupon`.`extended_content`, `OnsaleCoupon`.`datestart`, `OnsaleCoupon`.`dateend`, `OnsaleCoupon`.`retail_price`, `OnsaleCoupon`.`sale_price`, `OnsaleCoupon`.`conditions`, `OnsaleCoupon`.`img1`, `OnsaleCoupon`.`img2`, `OnsaleCoupon`.`created`, `OnsaleCoupon`.`modified` FROM `onsale_coupons` AS `OnsaleCoupon` WHERE `OnsaleCoupon`.`onsale_merchant_id` = (58) ORDER BY `OnsaleCoupon`.`created` DESC 331
30SELECT `OnsaleMerchant`.`id`, `OnsaleMerchant`.`name`, `OnsaleMerchant`.`website`, `OnsaleMerchant`.`about_us`, `OnsaleMerchant`.`hours`, `OnsaleMerchant`.`logo`, `OnsaleMerchant`.`img1`, `OnsaleMerchant`.`img2`, `OnsaleMerchant`.`menu`, `OnsaleMerchant`.`sales_person_id`, `OnsaleMerchant`.`contact_name`, `OnsaleMerchant`.`contact_email` FROM `onsale_merchants` AS `OnsaleMerchant` WHERE `OnsaleMerchant`.`id` = 58 111
31SELECT `OnsaleMerchant`.`id`, `OnsaleMerchant`.`name`, `OnsaleMerchant`.`website`, `OnsaleMerchant`.`about_us`, `OnsaleMerchant`.`hours`, `OnsaleMerchant`.`logo`, `OnsaleMerchant`.`img1`, `OnsaleMerchant`.`img2`, `OnsaleMerchant`.`menu`, `OnsaleMerchant`.`sales_person_id`, `OnsaleMerchant`.`contact_name`, `OnsaleMerchant`.`contact_email` FROM `onsale_merchants` AS `OnsaleMerchant` WHERE `OnsaleMerchant`.`id` = 58 111
32SELECT `OnsaleMerchant`.`id`, `OnsaleMerchant`.`name`, `OnsaleMerchant`.`website`, `OnsaleMerchant`.`about_us`, `OnsaleMerchant`.`hours`, `OnsaleMerchant`.`logo`, `OnsaleMerchant`.`img1`, `OnsaleMerchant`.`img2`, `OnsaleMerchant`.`menu`, `OnsaleMerchant`.`sales_person_id`, `OnsaleMerchant`.`contact_name`, `OnsaleMerchant`.`contact_email` FROM `onsale_merchants` AS `OnsaleMerchant` WHERE `OnsaleMerchant`.`id` = 58 111
33SELECT `OnsaleCouponsView`.`id`, `OnsaleCouponsView`.`date`, `OnsaleCouponsView`.`onsale_coupon_id`, `OnsaleCouponsView`.`screen_views`, `OnsaleCouponsView`.`print_view`, `OnsaleCouponsView`.`mobile_view` FROM `onsale_coupons_views` AS `OnsaleCouponsView` WHERE `OnsaleCouponsView`.`onsale_coupon_id` IN (204, 203, 202) 4984986
34SELECT `OnsaleCouponsCategory`.`id`, `OnsaleCouponsCategory`.`title`, `OnsaleCouponsCategory`.`onsale_coupons_categories_division_id`, `OnsaleCouponsOnsaleCouponsCategory`.`id`, `OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupon_id`, `OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupons_category_id` FROM `onsale_coupons_categories` AS `OnsaleCouponsCategory` JOIN `onsale_coupons_onsale_coupons_categories` AS `OnsaleCouponsOnsaleCouponsCategory` ON (`OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupon_id` IN (204, 203, 202) AND `OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupons_category_id` = `OnsaleCouponsCategory`.`id`) WHERE 1 = 1 28281
35SELECT `OnsaleMerchantsAddress`.`id`, `OnsaleMerchantsAddress`.`onsale_merchant_id`, `OnsaleMerchantsAddress`.`address`, `OnsaleMerchantsAddress`.`onsale_merchants_addresses_city_id`, `OnsaleMerchantsAddress`.`state`, `OnsaleMerchantsAddress`.`zip`, `OnsaleMerchantsAddress`.`phone`, `OnsaleMerchantsAddress`.`phone2`, `OnsaleMerchantsAddress`.`fax`, `OnsaleMerchantsAddress`.`email`, `OnsaleMerchantsAddress`.`lat`, `OnsaleMerchantsAddress`.`long` FROM `onsale_merchants_addresses` AS `OnsaleMerchantsAddress` WHERE `OnsaleMerchantsAddress`.`onsale_merchant_id` = (58) 111
36SELECT `OnsaleMerchant`.`id`, `OnsaleMerchant`.`name`, `OnsaleMerchant`.`website`, `OnsaleMerchant`.`about_us`, `OnsaleMerchant`.`hours`, `OnsaleMerchant`.`logo`, `OnsaleMerchant`.`img1`, `OnsaleMerchant`.`img2`, `OnsaleMerchant`.`menu`, `OnsaleMerchant`.`sales_person_id`, `OnsaleMerchant`.`contact_name`, `OnsaleMerchant`.`contact_email` FROM `onsale_merchants` AS `OnsaleMerchant` WHERE `OnsaleMerchant`.`id` = 58 111
37SELECT `OnsaleMerchantsAddressesCity`.`id`, `OnsaleMerchantsAddressesCity`.`title` FROM `onsale_merchants_addresses_cities` AS `OnsaleMerchantsAddressesCity` WHERE `OnsaleMerchantsAddressesCity`.`id` = 1 111
38SELECT `MerchantCategory`.`id`, `MerchantCategory`.`title`, `MerchantCategory`.`ad_zone_id`, `MerchantCategory`.`parent_id`, `MerchantCategory`.`lft`, `MerchantCategory`.`rght`, `MerchantCategoriesOnsaleMerchant`.`id`, `MerchantCategoriesOnsaleMerchant`.`merchant_category_id`, `MerchantCategoriesOnsaleMerchant`.`onsale_merchant_id` FROM `merchant_categories` AS `MerchantCategory` JOIN `merchant_categories_onsale_merchants` AS `MerchantCategoriesOnsaleMerchant` ON (`MerchantCategoriesOnsaleMerchant`.`onsale_merchant_id` = 58 AND `MerchantCategoriesOnsaleMerchant`.`merchant_category_id` = `MerchantCategory`.`id`) WHERE 1 = 1 001
39SELECT `OnsaleCouponsCategory`.`id`, `OnsaleCouponsCategory`.`title`, `OnsaleCouponsCategory`.`onsale_coupons_categories_division_id` FROM `onsale_coupons_categories` AS `OnsaleCouponsCategory` WHERE `OnsaleCouponsCategory`.`title` = 'Let\'s Eat Out' LIMIT 1111
40SELECT `OnsaleCouponsCategory`.`id`, `OnsaleCouponsCategory`.`title`, `OnsaleCouponsCategory`.`onsale_coupons_categories_division_id`, `OnsaleCouponsCategoriesDivision`.`id`, `OnsaleCouponsCategoriesDivision`.`title` FROM `onsale_coupons_categories` AS `OnsaleCouponsCategory` LEFT JOIN `onsale_coupons_categories_divisions` AS `OnsaleCouponsCategoriesDivision` ON (`OnsaleCouponsCategory`.`onsale_coupons_categories_division_id` = `OnsaleCouponsCategoriesDivision`.`id`) WHERE `OnsaleCouponsCategory`.`id` = (6) 111
41SELECT `OnsaleCoupon`.`id`, `OnsaleCoupon`.`onsale_merchant_id`, `OnsaleCoupon`.`title`, `OnsaleCoupon`.`content`, `OnsaleCoupon`.`extended_content`, `OnsaleCoupon`.`datestart`, `OnsaleCoupon`.`dateend`, `OnsaleCoupon`.`retail_price`, `OnsaleCoupon`.`sale_price`, `OnsaleCoupon`.`conditions`, `OnsaleCoupon`.`img1`, `OnsaleCoupon`.`img2`, `OnsaleCoupon`.`created`, `OnsaleCoupon`.`modified`, `OnsaleCouponsOnsaleCouponsCategory`.`id`, `OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupon_id`, `OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupons_category_id` FROM `onsale_coupons` AS `OnsaleCoupon` JOIN `onsale_coupons_onsale_coupons_categories` AS `OnsaleCouponsOnsaleCouponsCategory` ON (`OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupons_category_id` = 6 AND `OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupon_id` = `OnsaleCoupon`.`id`) WHERE 1 = 1 1311315
42SELECT `OnsaleCoupon`.`id`, `OnsaleCoupon`.`onsale_merchant_id` FROM `onsale_coupons` AS `OnsaleCoupon` WHERE `OnsaleCoupon`.`datestart` <= CURDATE() AND `OnsaleCoupon`.`dateend` >= CURDATE() AND `OnsaleCoupon`.`id` IN (1,3,4,5,6,7,10,13,14,15,16,17,18,19,20,21,81,23,24,219,218,217,28,29,30,31,32,145,144,36,190,235,42,43,44,226,223,48,49,50,109,108,54,260,347,259,58,59,60,65,66,67,221,220,78,95,94,96,98,99,265,246,102,103,104,216,126,127,128,129,130,141,142,143,152,157,158,159,215,166,167,168,169,300,346,293,292,182,183,184,247,194,195,369,202,203,204,205,206,207,208,209,210,211,212,213,214,261,267,268,352,272,345,368,289,290,301,302,304,317,318,319,320,373,372,324,325,351,353,371,370) ORDER BY `OnsaleCoupon`.`created` DESC 53532
43SELECT `OnsaleCoupon`.`id`, `OnsaleCoupon`.`onsale_merchant_id`, `OnsaleCoupon`.`title`, `OnsaleCoupon`.`content`, `OnsaleCoupon`.`extended_content`, `OnsaleCoupon`.`datestart`, `OnsaleCoupon`.`dateend`, `OnsaleCoupon`.`retail_price`, `OnsaleCoupon`.`sale_price`, `OnsaleCoupon`.`conditions`, `OnsaleCoupon`.`img1`, `OnsaleCoupon`.`img2`, `OnsaleCoupon`.`created`, `OnsaleCoupon`.`modified`, `OnsaleMerchant`.`id`, `OnsaleMerchant`.`name`, `OnsaleMerchant`.`website`, `OnsaleMerchant`.`about_us`, `OnsaleMerchant`.`hours`, `OnsaleMerchant`.`logo`, `OnsaleMerchant`.`img1`, `OnsaleMerchant`.`img2`, `OnsaleMerchant`.`menu`, `OnsaleMerchant`.`sales_person_id`, `OnsaleMerchant`.`contact_name`, `OnsaleMerchant`.`contact_email` FROM `onsale_coupons` AS `OnsaleCoupon` LEFT JOIN `onsale_merchants` AS `OnsaleMerchant` ON (`OnsaleCoupon`.`onsale_merchant_id` = `OnsaleMerchant`.`id`) WHERE `OnsaleCoupon`.`id` IN (235,353,217,18,304) ORDER BY `OnsaleCoupon`.`created` DESC 553
44SELECT `OnsaleCouponsCategory`.`id`, `OnsaleCouponsCategory`.`title`, `OnsaleCouponsCategory`.`onsale_coupons_categories_division_id` FROM `onsale_coupons_categories` AS `OnsaleCouponsCategory` WHERE `OnsaleCouponsCategory`.`title` = 'Onsale' LIMIT 1111
45SELECT `OnsaleCouponsCategory`.`id`, `OnsaleCouponsCategory`.`title`, `OnsaleCouponsCategory`.`onsale_coupons_categories_division_id`, `OnsaleCouponsCategoriesDivision`.`id`, `OnsaleCouponsCategoriesDivision`.`title` FROM `onsale_coupons_categories` AS `OnsaleCouponsCategory` LEFT JOIN `onsale_coupons_categories_divisions` AS `OnsaleCouponsCategoriesDivision` ON (`OnsaleCouponsCategory`.`onsale_coupons_categories_division_id` = `OnsaleCouponsCategoriesDivision`.`id`) WHERE `OnsaleCouponsCategory`.`id` = (5) 111
46SELECT `OnsaleCoupon`.`id`, `OnsaleCoupon`.`onsale_merchant_id`, `OnsaleCoupon`.`title`, `OnsaleCoupon`.`content`, `OnsaleCoupon`.`extended_content`, `OnsaleCoupon`.`datestart`, `OnsaleCoupon`.`dateend`, `OnsaleCoupon`.`retail_price`, `OnsaleCoupon`.`sale_price`, `OnsaleCoupon`.`conditions`, `OnsaleCoupon`.`img1`, `OnsaleCoupon`.`img2`, `OnsaleCoupon`.`created`, `OnsaleCoupon`.`modified`, `OnsaleCouponsOnsaleCouponsCategory`.`id`, `OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupon_id`, `OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupons_category_id` FROM `onsale_coupons` AS `OnsaleCoupon` JOIN `onsale_coupons_onsale_coupons_categories` AS `OnsaleCouponsOnsaleCouponsCategory` ON (`OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupons_category_id` = 5 AND `OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupon_id` = `OnsaleCoupon`.`id`) WHERE 1 = 1 31312
47SELECT `OnsaleCoupon`.`id`, `OnsaleCoupon`.`onsale_merchant_id` FROM `onsale_coupons` AS `OnsaleCoupon` WHERE `OnsaleCoupon`.`datestart` <= CURDATE() AND `OnsaleCoupon`.`dateend` >= CURDATE() AND `OnsaleCoupon`.`id` IN (192,191,120,119,250,249,93,92,91,121,156,165,176,177,178,193,288,146,147,148,349,348,277,284,316,315,314,327,326,328,350) ORDER BY `OnsaleCoupon`.`created` DESC 14141
48SELECT `OnsaleCoupon`.`id`, `OnsaleCoupon`.`onsale_merchant_id`, `OnsaleCoupon`.`title`, `OnsaleCoupon`.`content`, `OnsaleCoupon`.`extended_content`, `OnsaleCoupon`.`datestart`, `OnsaleCoupon`.`dateend`, `OnsaleCoupon`.`retail_price`, `OnsaleCoupon`.`sale_price`, `OnsaleCoupon`.`conditions`, `OnsaleCoupon`.`img1`, `OnsaleCoupon`.`img2`, `OnsaleCoupon`.`created`, `OnsaleCoupon`.`modified`, `OnsaleMerchant`.`id`, `OnsaleMerchant`.`name`, `OnsaleMerchant`.`website`, `OnsaleMerchant`.`about_us`, `OnsaleMerchant`.`hours`, `OnsaleMerchant`.`logo`, `OnsaleMerchant`.`img1`, `OnsaleMerchant`.`img2`, `OnsaleMerchant`.`menu`, `OnsaleMerchant`.`sales_person_id`, `OnsaleMerchant`.`contact_name`, `OnsaleMerchant`.`contact_email` FROM `onsale_coupons` AS `OnsaleCoupon` LEFT JOIN `onsale_merchants` AS `OnsaleMerchant` ON (`OnsaleCoupon`.`onsale_merchant_id` = `OnsaleMerchant`.`id`) WHERE `OnsaleCoupon`.`id` IN (92,91,284,328,315) ORDER BY `OnsaleCoupon`.`created` DESC 552
49SELECT `PopularLink`.`id`, `PopularLink`.`title`, `PopularLink`.`link_path`, `PopularLink`.`link_color`, `PopularLink`.`parent_id`, `PopularLink`.`lft`, `PopularLink`.`rght`, `PopularLink`.`created`, `PopularLink`.`modified` FROM `popular_links` AS `PopularLink` WHERE 1 = 1 ORDER BY `lft` ASC 17171
50DESCRIBE `widgets`661
51SELECT `Widget`.`id`, `Widget`.`name`, `Widget`.`content_feed_url`, `Widget`.`data`, `Widget`.`update_frequency`, `Widget`.`modified` FROM `widgets` AS `Widget` WHERE `Widget`.`name` = 'weather' LIMIT 1111
52DESCRIBE `navigation_links`10101
53SELECT `NavigationLink`.`id`, `NavigationLink`.`title`, `NavigationLink`.`link_path`, `NavigationLink`.`link_color`, `NavigationLink`.`open_new`, `NavigationLink`.`parent_id`, `NavigationLink`.`lft`, `NavigationLink`.`rght`, `NavigationLink`.`created`, `NavigationLink`.`modified` FROM `navigation_links` AS `NavigationLink` WHERE 1 = 1 ORDER BY `lft` ASC 35352
(bloggers) 2 queries took 72 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `blog_posts`6636
2DESCRIBE `blog_providers`9936