Subscribe & Get your Deals by Email

Siam Therapy Massage & Spa

Recommend Y/N Comments: 0 Score: 0
Daily Deals: 0 Ended Deals: 25
Comments
Share your opinion
Would you recommend this merchant to your friends?

("0" Absolutely not, "10" Absolutely)

Browsing history

    Countries

    (default) 59 queries took 1159 ms
    NrQueryErrorAffectedNum. rowsTook (ms)
    1DESCRIBE `tuan_categories`441
    2DESCRIBE `users`25251
    3DESCRIBE `user_profiles`54542
    4DESCRIBE `user_relations`441
    5DESCRIBE `tuan_logs`31311
    6DESCRIBE `tuan_subscripts`121211
    7DESCRIBE `tuan_cities`13132
    8DESCRIBE `tuan_domains`37371
    9DESCRIBE `comments`333339
    10DESCRIBE `user_orders`121296
    11DESCRIBE `user_bookmarkers`662
    12DESCRIBE `provinces`441
    13DESCRIBE `cities`4495
    14DESCRIBE `attachments`88100
    15DESCRIBE `tuan_category_relations`551
    16DESCRIBE `tuan_subcategories`551
    17SELECT * FROM tuan_ad_partners WHERE flag=1110
    18SELECT `TuanCategories`.`id`, `TuanCategories`.`name`, `TuanCategories`.`name_en`, `TuanCategories`.`create_time` FROM `tuan_categories` AS `TuanCategories` WHERE 1 = 1 550
    19SELECT `TuanCities`.`id`, `TuanCities`.`name`, `TuanCities`.`name_en`, `TuanCities`.`hot`, `TuanCities`.`daily_send_num`, `TuanCities`.`daily_open_num`, `TuanCities`.`longitude`, `TuanCities`.`latitude`, `TuanCities`.`not_display`, `TuanCities`.`real_name`, `TuanCities`.`population`, `TuanCities`.`tuanprovince_id`, `TuanCities`.`square_measure` FROM `tuan_cities` AS `TuanCities` WHERE name_en='sydney' LIMIT 1111
    20SELECT `TuanCategories`.`id`, `TuanCategories`.`name`, `TuanCategories`.`name_en`, `TuanCategories`.`create_time` FROM `tuan_categories` AS `TuanCategories` WHERE 1 = 1 550
    21SELECT `TuanCities`.`id`, `TuanCities`.`name`, `TuanCities`.`name_en`, `TuanCities`.`hot`, `TuanCities`.`daily_send_num`, `TuanCities`.`daily_open_num`, `TuanCities`.`longitude`, `TuanCities`.`latitude`, `TuanCities`.`not_display`, `TuanCities`.`real_name`, `TuanCities`.`population`, `TuanCities`.`tuanprovince_id`, `TuanCities`.`square_measure` FROM `tuan_cities` AS `TuanCities` WHERE hot>0 ORDER BY hot ASC 1111380
    22SELECT id FROM ipdata WHERE ipfrom<= 911927705 AND ipto >= 911927705115
    23SELECT id,area FROM ipdata WHERE id=2173 110
    24SELECT * FROM tuan_cities WHERE '美国' LIKE CONCAT( '%', name, '%' )001
    25SELECT id,if(hot=0,1,0) as sort_hot FROM tuan_cities WHERE not_display='0' ORDER BY sort_hot asc,hot asc,id asc LIMIT 1110
    26SELECT `TuanCities`.`id`, `TuanCities`.`name`, `TuanCities`.`name_en`, `TuanCities`.`hot`, `TuanCities`.`daily_send_num`, `TuanCities`.`daily_open_num`, `TuanCities`.`longitude`, `TuanCities`.`latitude`, `TuanCities`.`not_display`, `TuanCities`.`real_name`, `TuanCities`.`population`, `TuanCities`.`tuanprovince_id`, `TuanCities`.`square_measure` FROM `tuan_cities` AS `TuanCities` WHERE id='4' LIMIT 1110
    27SELECT `TuanCities`.`id`, `TuanCities`.`name`, `TuanCities`.`name_en`, `TuanCities`.`hot`, `TuanCities`.`daily_send_num`, `TuanCities`.`daily_open_num`, `TuanCities`.`longitude`, `TuanCities`.`latitude`, `TuanCities`.`not_display`, `TuanCities`.`real_name`, `TuanCities`.`population`, `TuanCities`.`tuanprovince_id`, `TuanCities`.`square_measure` FROM `tuan_cities` AS `TuanCities` WHERE id='4' LIMIT 11111
    28SELECT `TuanCities`.`id`, `TuanCities`.`name`, `TuanCities`.`name_en`, `TuanCities`.`hot`, `TuanCities`.`daily_send_num`, `TuanCities`.`daily_open_num`, `TuanCities`.`longitude`, `TuanCities`.`latitude`, `TuanCities`.`not_display`, `TuanCities`.`real_name`, `TuanCities`.`population`, `TuanCities`.`tuanprovince_id`, `TuanCities`.`square_measure` FROM `tuan_cities` AS `TuanCities` WHERE id='4' LIMIT 111100
    29SELECT tuan_dealers.* FROM tuan_dealers WHERE tuan_dealers.id='11806' 11215
    30SELECT * FROM tuan_dealer_shops WHERE tuan_dealer_shops.dealer_id in (11806) AND belong_id=0 AND city='4' ORDER BY locality 112
    31SELECT * FROM tuan_localities WHERE 1 AND tuancity_id='4' 000
    32SELECT id,name,name_en FROM tuan_subcategories WHERE cat_id='1' 770
    33SELECT id,name,name_en FROM tuan_subcategories WHERE cat_id='2' 660
    34SELECT id,name,name_en FROM tuan_subcategories WHERE cat_id='3' 990
    35SELECT id,name,name_en FROM tuan_subcategories WHERE cat_id='4' 110
    36SELECT id,name,name_en FROM tuan_subcategories WHERE cat_id='5' 880
    37SELECT id FROM tuan_domains WHERE not_display='1' 15150
    38SELECT COUNT(*) AS total FROM tuan_logs LEFT JOIN tuan_dealer_relations ON tuan_dealer_relations.tg_id=tuan_logs.id WHERE 1 AND tuan_dealer_relations.shop_id in (14579) AND not_display = 0 AND tuan NOT IN (1,5,9,10,11,12,14,15,16,17,19,20,21,22,23) AND tuan_logs.city='4' AND flag=0 AND end_date>'1416844596' GROUP BY tuan_dealer_relations.tg_id ORDER BY tuan_dealer_relations.tg_id desc 0027
    39SELECT COUNT(*) AS total FROM tuan_logs LEFT JOIN tuan_dealer_relations ON tuan_dealer_relations.tg_id=tuan_logs.id WHERE 1 AND tuan_dealer_relations.shop_id in (14579) AND not_display = 0 AND tuan NOT IN (1,5,9,10,11,12,14,15,16,17,19,20,21,22,23) AND tuan_logs.city='4' AND ( flag=1 OR end_date<='1416844596' ) GROUP BY tuan_dealer_relations.tg_id ORDER BY tuan_dealer_relations.tg_id desc 25254
    40SELECT tuan_logs.id, tuan_logs.title, tuan_logs.url, tuan_logs.original_price, tuan_logs.price, tuan_logs.discount_percent, tuan_logs.discount_amount, tuan_logs.sold, tuan_logs.image, tuan_logs.start_date, tuan_logs.end_date, tuan_logs.creat_time, tuan_logs.tuan, tuan_logs.city, tuan_logs.sellout, tuan_logs.not_display, tuan_logs.flag, tuan_logs.available_from, tuan_logs.available_to, tuan_logs.term FROM tuan_logs LEFT JOIN tuan_dealer_relations ON tuan_dealer_relations.tg_id=tuan_logs.id WHERE 1 AND tuan_dealer_relations.shop_id in (14579) AND not_display = 0 AND tuan NOT IN (1,5,9,10,11,12,14,15,16,17,19,20,21,22,23) AND tuan_logs.city='4' AND ( flag=1 OR end_date<='1416844596' ) GROUP BY tuan_dealer_relations.tg_id ORDER BY tuan_dealer_relations.tg_id desc LIMIT 3331
    41SELECT `TuanDomains`.`id`, `TuanDomains`.`name`, `TuanDomains`.`name_en`, `TuanDomains`.`url`, `TuanDomains`.`is_ok`, `TuanDomains`.`type`, `TuanDomains`.`cat_id`, `TuanDomains`.`subcat_id`, `TuanDomains`.`not_script`, `TuanDomains`.`not_display`, `TuanDomains`.`phone`, `TuanDomains`.`chat_type`, `TuanDomains`.`qq`, `TuanDomains`.`email`, `TuanDomains`.`address`, `TuanDomains`.`description`, `TuanDomains`.`launch_time`, `TuanDomains`.`help_time`, `TuanDomains`.`online_help_time`, `TuanDomains`.`login_str`, `TuanDomains`.`login_url`, `TuanDomains`.`level`, `TuanDomains`.`aff_key`, `TuanDomains`.`aff_start_time`, `TuanDomains`.`use_web_aff`, `TuanDomains`.`web_site_key`, `TuanDomains`.`web_deal_key`, `TuanDomains`.`web_site_position`, `TuanDomains`.`use_api_aff`, `TuanDomains`.`api_site_key`, `TuanDomains`.`api_deal_key`, `TuanDomains`.`api_site_position`, `TuanDomains`.`use_edm_aff`, `TuanDomains`.`edm_site_key`, `TuanDomains`.`edm_deal_key`, `TuanDomains`.`notes`, `TuanDomains`.`use_proxy` FROM `tuan_domains` AS `TuanDomains` WHERE id='8' LIMIT 1110
    42SELECT TuanCities.* FROM tuan_cities as TuanCities WHERE TuanCities.id='4' 110
    43SELECT COUNT(*) AS `count` FROM `comments` AS `Comment` WHERE cat_id =4 AND brand_id = 8 AND pro_id = 505995 AND comment<>'' 110
    44SELECT COUNT(id) as total FROM user_bookmarkers WHERE tg_id='505995' 110
    45SELECT t.locality FROM tuan_log_stores t WHERE t.tg_id='505995' AND t.city='4' 111
    46SELECT `TuanDomains`.`id`, `TuanDomains`.`name`, `TuanDomains`.`name_en`, `TuanDomains`.`url`, `TuanDomains`.`is_ok`, `TuanDomains`.`type`, `TuanDomains`.`cat_id`, `TuanDomains`.`subcat_id`, `TuanDomains`.`not_script`, `TuanDomains`.`not_display`, `TuanDomains`.`phone`, `TuanDomains`.`chat_type`, `TuanDomains`.`qq`, `TuanDomains`.`email`, `TuanDomains`.`address`, `TuanDomains`.`description`, `TuanDomains`.`launch_time`, `TuanDomains`.`help_time`, `TuanDomains`.`online_help_time`, `TuanDomains`.`login_str`, `TuanDomains`.`login_url`, `TuanDomains`.`level`, `TuanDomains`.`aff_key`, `TuanDomains`.`aff_start_time`, `TuanDomains`.`use_web_aff`, `TuanDomains`.`web_site_key`, `TuanDomains`.`web_deal_key`, `TuanDomains`.`web_site_position`, `TuanDomains`.`use_api_aff`, `TuanDomains`.`api_site_key`, `TuanDomains`.`api_deal_key`, `TuanDomains`.`api_site_position`, `TuanDomains`.`use_edm_aff`, `TuanDomains`.`edm_site_key`, `TuanDomains`.`edm_deal_key`, `TuanDomains`.`notes`, `TuanDomains`.`use_proxy` FROM `tuan_domains` AS `TuanDomains` WHERE id='6' LIMIT 1110
    47SELECT COUNT(*) AS `count` FROM `comments` AS `Comment` WHERE cat_id =4 AND brand_id = 6 AND pro_id = 498914 AND comment<>'' 110
    48SELECT COUNT(id) as total FROM user_bookmarkers WHERE tg_id='498914' 110
    49SELECT t.locality FROM tuan_log_stores t WHERE t.tg_id='498914' AND t.city='4' 000
    50SELECT `TuanDomains`.`id`, `TuanDomains`.`name`, `TuanDomains`.`name_en`, `TuanDomains`.`url`, `TuanDomains`.`is_ok`, `TuanDomains`.`type`, `TuanDomains`.`cat_id`, `TuanDomains`.`subcat_id`, `TuanDomains`.`not_script`, `TuanDomains`.`not_display`, `TuanDomains`.`phone`, `TuanDomains`.`chat_type`, `TuanDomains`.`qq`, `TuanDomains`.`email`, `TuanDomains`.`address`, `TuanDomains`.`description`, `TuanDomains`.`launch_time`, `TuanDomains`.`help_time`, `TuanDomains`.`online_help_time`, `TuanDomains`.`login_str`, `TuanDomains`.`login_url`, `TuanDomains`.`level`, `TuanDomains`.`aff_key`, `TuanDomains`.`aff_start_time`, `TuanDomains`.`use_web_aff`, `TuanDomains`.`web_site_key`, `TuanDomains`.`web_deal_key`, `TuanDomains`.`web_site_position`, `TuanDomains`.`use_api_aff`, `TuanDomains`.`api_site_key`, `TuanDomains`.`api_deal_key`, `TuanDomains`.`api_site_position`, `TuanDomains`.`use_edm_aff`, `TuanDomains`.`edm_site_key`, `TuanDomains`.`edm_deal_key`, `TuanDomains`.`notes`, `TuanDomains`.`use_proxy` FROM `tuan_domains` AS `TuanDomains` WHERE id='8' LIMIT 1110
    51SELECT COUNT(*) AS `count` FROM `comments` AS `Comment` WHERE cat_id =4 AND brand_id = 8 AND pro_id = 475241 AND comment<>'' 110
    52SELECT COUNT(id) as total FROM user_bookmarkers WHERE tg_id='475241' 110
    53SELECT t.locality FROM tuan_log_stores t WHERE t.tg_id='475241' AND t.city='4' 110
    54SELECT * FROM tuan_dealer_shops WHERE tuan_dealer_shops.dealer_id in (11806) AND belong_id=0 110
    55SELECT count(id) as total,sum(comment_score) as scores FROM tuan_shop_comments as comments WHERE dealer_id='11806' AND comments.comment<>'' 1153
    56SELECT count(id) as total,sum(comment_score) as scores FROM ( SELECT distinct tg_id from tuan_dealer_relations where 1 and tuan_dealer_relations.shop_id in (14579) ) t LEFT JOIN comments on comments.pro_id=t.tg_id WHERE 1 and comments.pro_id>0 AND comments.comment<>'' 111
    57SELECT count(id) as total,sum(comment_score) as scores FROM tuan_shop_comments as comments WHERE dealer_id='11806' 110
    58SELECT count(id) as total,sum(comment_score) as scores FROM ( SELECT distinct tg_id from tuan_dealer_relations where 1 and tuan_dealer_relations.shop_id in (14579) ) t LEFT JOIN comments on comments.pro_id=t.tg_id WHERE 1 and comments.pro_id>0 111
    59SELECT comments.id,comments.comment,comments.comment_score,comments.pro_id AS tg_id,comments.user_id,comments.comment_create_time AS add_time,comments.comment_ip AS ip FROM tuan_shop_comments as comments WHERE dealer_id='11806' AND comments.comment<>'' UNION ALL ( SELECT comments.id,comments.comment,comments.comment_score,comments.pro_id AS tg_id,comments.user_id,comments.comment_create_time AS add_time,comments.comment_ip AS ip FROM ( SELECT distinct tg_id from tuan_dealer_relations where 1 and tuan_dealer_relations.shop_id in (14579) ) t LEFT JOIN comments on comments.pro_id=t.tg_id WHERE 1 and comments.pro_id>0 AND comments.comment<>'' ) ORDER BY add_time desc LIMIT 3001