587.23592758179 大分 デリヘル 桃色奥様 お店からのお知らせ

お店からのお知らせ本日の営業状況や女の子の出勤状況、新人入店やイベント情報などをリアルタイムでお知らせしています。


(default) 66 queries took 587 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `users`19191
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';111
3SHOW FULL COLUMNS FROM `plans`22221
4SHOW FULL COLUMNS FROM `shops`34342
5SHOW FULL COLUMNS FROM `large_areas`661
6SHOW FULL COLUMNS FROM `m_shops_business_categories`441
7SHOW FULL COLUMNS FROM `girls`21211
8SHOW FULL COLUMNS FROM `m_girls_cups`551
9SHOW FULL COLUMNS FROM `m_girls_types`551
10SHOW FULL COLUMNS FROM `m_girls_smokes`441
11SHOW FULL COLUMNS FROM `m_girls_tattoos`441
12SHOW FULL COLUMNS FROM `girls_accesses`881
13SHOW FULL COLUMNS FROM `m_girls_characters`441
14SHOW FULL COLUMNS FROM `discounts`551
15SHOW FULL COLUMNS FROM `shops_small_areas`661
16SHOW FULL COLUMNS FROM `small_areas`661
17SHOW FULL COLUMNS FROM `girls_schedules`881
18SHOW FULL COLUMNS FROM `m_schedule_categories`441
19SHOW FULL COLUMNS FROM `news`661
20SHOW FULL COLUMNS FROM `jobs`13131
21SHOW FULL COLUMNS FROM `m_jobs_back_rates`441
22SHOW FULL COLUMNS FROM `m_jobs_business_categories`441
23SHOW FULL COLUMNS FROM `jobsquicks`661
24SHOW FULL COLUMNS FROM `m_jobs_characters`441
25SHOW FULL COLUMNS FROM `reviews`22221
26SHOW FULL COLUMNS FROM `m_reviews_ages`441
27SHOW FULL COLUMNS FROM `m_reviews_body_heights`441
28SHOW FULL COLUMNS FROM `m_reviews_cups`441
29SHOW FULL COLUMNS FROM `m_reviews_types`441
30SHOW FULL COLUMNS FROM `m_reviews_styles`441
31SHOW FULL COLUMNS FROM `m_reviews_compares`441
32SHOW FULL COLUMNS FROM `m_reviews_blowjobs`441
33SHOW FULL COLUMNS FROM `m_reviews_smokes`441
34SHOW FULL COLUMNS FROM `m_reviews_tattoos`441
35SHOW FULL COLUMNS FROM `reviews_characters`661
36SHOW FULL COLUMNS FROM `m_reviews_characters`441
37SHOW FULL COLUMNS FROM `bbs`771
38SHOW FULL COLUMNS FROM `shops_services`661
39SHOW FULL COLUMNS FROM `m_shops_services`441
40SHOW FULL COLUMNS FROM `shops_characters`661
41SHOW FULL COLUMNS FROM `m_shops_characters`441
42SHOW FULL COLUMNS FROM `shops_hours`661
43SHOW FULL COLUMNS FROM `m_shops_hours`441
44SHOW FULL COLUMNS FROM `shops_credit_cards`661
45SHOW FULL COLUMNS FROM `m_shops_credit_cards`441
46SHOW FULL COLUMNS FROM `quicks`661
47SHOW FULL COLUMNS FROM `shop_base_plays`661
48SHOW FULL COLUMNS FROM `shop_cources`771
49SHOW FULL COLUMNS FROM `shop_options`771
50SHOW FULL COLUMNS FROM `shop_expenses`771
51SHOW FULL COLUMNS FROM `shops_accesses`881
52SELECT `LargeArea`.`id`, `LargeArea`.`name`, `LargeArea`.`url`, `LargeArea`.`banner_search_order`, `LargeArea`.`created`, `LargeArea`.`modified` FROM `large_areas` AS `LargeArea` WHERE `LargeArea`.`id` = 10 LIMIT 1110
53SELECT COUNT(*) AS `count` FROM `users` AS `User` LEFT JOIN `plans` AS `Plan` ON (`Plan`.`id` = `User`.`plan_id`) WHERE `User`.`id` = 5052 AND `User`.`is_running` = 1 110
54SELECT COUNT(*) AS `count` FROM `shops` AS `Shop` LEFT JOIN `users` AS `User` ON (`User`.`id` = `Shop`.`user_id`) LEFT JOIN `large_areas` AS `LargeArea` ON (`User`.`large_area_id` = `LargeArea`.`id`) LEFT JOIN `m_shops_business_categories` AS `MShopsBusinessCategory` ON (`Shop`.`shops_business_category_id` = `MShopsBusinessCategory`.`id`) LEFT JOIN `plans` AS `Plan` ON (`Plan`.`id` = `User`.`plan_id`) WHERE `Shop`.`user_id` = 5052 AND `Shop`.`is_created` = 1 110
55SELECT COUNT(*) AS `count` FROM `shops_accesses` AS `ShopsAccess` WHERE `ShopsAccess`.`user_id` = 5052 AND `ShopsAccess`.`view_id` = 5 AND `ShopsAccess`.`ip` = '34.203.225.78' AND `ShopsAccess`.`created` >= '2018-12-14 17:05:50' 11530
56INSERT INTO `shops_accesses` (`user_id`, `view_id`, `ip`, `modified`, `created`) VALUES (5052, 5, '34.203.225.78', '2018-12-14 18:05:50', '2018-12-14 18:05:50')11
57SELECT LAST_INSERT_ID() AS insertID110
58SHOW FULL COLUMNS FROM `points`661
59SELECT COUNT(*) AS `count` FROM `points` AS `Point` WHERE `Point`.`user_id` = 5052 AND `Point`.`ip` = '34.203.225.78' AND `Point`.`created` >= '2018-12-14 17:05:50' 111
60INSERT INTO `points` (`user_id`, `points`, `ip`, `modified`, `created`) VALUES (5052, 1, '34.203.225.78', '2018-12-14 18:05:50', '2018-12-14 18:05:50')10
61SELECT LAST_INSERT_ID() AS insertID110
62SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`kana`, `User`.`large_area_id`, `User`.`small_area_id`, `User`.`is_review_display`, `User`.`is_running`, `User`.`plan_id`, `User`.`is_access_enabled`, `User`.`review_accept`, `User`.`is_shops_headline`, `User`.`is_jobs_headline`, `User`.`is_yellowpage_headline`, `User`.`is_official_layout`, `User`.`is_background_image_upload`, `User`.`is_template`, `User`.`created`, `User`.`modified`, `Plan`.`id`, `Plan`.`name`, `Plan`.`rate`, `Plan`.`news_count`, `Plan`.`quick_count`, `Plan`.`is_jobsquicks`, `Plan`.`jobsquicks_count`, `Plan`.`is_review_manage`, `Plan`.`review_delete_target`, `Plan`.`banner_width_pc`, `Plan`.`banner_height_pc`, `Plan`.`banner_width_mobile`, `Plan`.`banner_height_mobile`, `Plan`.`cast_count`, `Plan`.`is_job_img`, `Plan`.`is_mini_banner`, `Plan`.`plan_order`, `Plan`.`is_side_bar`, `Plan`.`is_job_message_receive`, `Plan`.`is_fixed_shift`, `Plan`.`created`, `Plan`.`midified` FROM `users` AS `User` LEFT JOIN `plans` AS `Plan` ON (`Plan`.`id` = `User`.`plan_id`) WHERE `User`.`id` = 5052 LIMIT 1110
63SELECT `ShopsSmallArea`.`id`, `ShopsSmallArea`.`user_id`, `ShopsSmallArea`.`small_area_id`, `ShopsSmallArea`.`selected`, `ShopsSmallArea`.`created`, `ShopsSmallArea`.`modified`, `SmallArea`.`id`, `SmallArea`.`large_area_id`, `SmallArea`.`name`, `SmallArea`.`show_order`, `SmallArea`.`created`, `SmallArea`.`modified`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`kana`, `User`.`large_area_id`, `User`.`small_area_id`, `User`.`is_review_display`, `User`.`is_running`, `User`.`plan_id`, `User`.`is_access_enabled`, `User`.`review_accept`, `User`.`is_shops_headline`, `User`.`is_jobs_headline`, `User`.`is_yellowpage_headline`, `User`.`is_official_layout`, `User`.`is_background_image_upload`, `User`.`is_template`, `User`.`created`, `User`.`modified` FROM `shops_small_areas` AS `ShopsSmallArea` LEFT JOIN `small_areas` AS `SmallArea` ON (`SmallArea`.`id` = `ShopsSmallArea`.`small_area_id`) LEFT JOIN `users` AS `User` ON (`ShopsSmallArea`.`user_id` = `User`.`id`) WHERE `selected` = 1 AND `ShopsSmallArea`.`user_id` = 5052 ORDER BY `SmallArea`.`show_order` ASC 000
64SELECT `Shop`.`id`, `Shop`.`user_id`, `Shop`.`name`, `Shop`.`shops_business_category_id`, `Shop`.`phone_number`, `Shop`.`email`, `Shop`.`shop_hour_open`, `Shop`.`shop_hour_close`, `Shop`.`url_pc`, `Shop`.`url_mobile`, `Shop`.`url_smartphone`, `Shop`.`shops_price_id`, `Shop`.`shops_discount_id`, `Shop`.`notify_number`, `Shop`.`girls_mobile_email`, `Shop`.`banner_pc`, `Shop`.`banner_mobile`, `Shop`.`mini_banner_pc`, `Shop`.`mini_banner_mobile`, `Shop`.`head_pc`, `Shop`.`head_mobile`, `Shop`.`background_image_pc`, `Shop`.`background_image_mobile`, `Shop`.`background_image_smartphone`, `Shop`.`pc_template_id`, `Shop`.`mobile_template_id`, `Shop`.`smartphone_template_id`, `Shop`.`is_job_message_receive_mail`, `Shop`.`recommend_girl`, `Shop`.`recommend_comment`, `Shop`.`other_price_system`, `Shop`.`is_created`, `Shop`.`created`, `Shop`.`modified`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`kana`, `User`.`large_area_id`, `User`.`small_area_id`, `User`.`is_review_display`, `User`.`is_running`, `User`.`plan_id`, `User`.`is_access_enabled`, `User`.`review_accept`, `User`.`is_shops_headline`, `User`.`is_jobs_headline`, `User`.`is_yellowpage_headline`, `User`.`is_official_layout`, `User`.`is_background_image_upload`, `User`.`is_template`, `User`.`created`, `User`.`modified`, `LargeArea`.`id`, `LargeArea`.`name`, `LargeArea`.`url`, `LargeArea`.`banner_search_order`, `LargeArea`.`created`, `LargeArea`.`modified`, `MShopsBusinessCategory`.`id`, `MShopsBusinessCategory`.`name`, `MShopsBusinessCategory`.`created`, `MShopsBusinessCategory`.`modified`, `Plan`.`id`, `Plan`.`name`, `Plan`.`rate`, `Plan`.`news_count`, `Plan`.`quick_count`, `Plan`.`is_jobsquicks`, `Plan`.`jobsquicks_count`, `Plan`.`is_review_manage`, `Plan`.`review_delete_target`, `Plan`.`banner_width_pc`, `Plan`.`banner_height_pc`, `Plan`.`banner_width_mobile`, `Plan`.`banner_height_mobile`, `Plan`.`cast_count`, `Plan`.`is_job_img`, `Plan`.`is_mini_banner`, `Plan`.`plan_order`, `Plan`.`is_side_bar`, `Plan`.`is_job_message_receive`, `Plan`.`is_fixed_shift`, `Plan`.`created`, `Plan`.`midified` FROM `shops` AS `Shop` LEFT JOIN `users` AS `User` ON (`User`.`id` = `Shop`.`user_id`) LEFT JOIN `large_areas` AS `LargeArea` ON (`User`.`large_area_id` = `LargeArea`.`id`) LEFT JOIN `m_shops_business_categories` AS `MShopsBusinessCategory` ON (`Shop`.`shops_business_category_id` = `MShopsBusinessCategory`.`id`) LEFT JOIN `plans` AS `Plan` ON (`Plan`.`id` = `User`.`plan_id`) WHERE `Shop`.`user_id` = 5052 LIMIT 1111
65SELECT COUNT(*) AS `count` FROM `news` AS `News` LEFT JOIN `users` AS `User` ON (`User`.`id` = `News`.`user_id`) LEFT JOIN `large_areas` AS `LargeArea` ON (`User`.`large_area_id` = `LargeArea`.`id`) LEFT JOIN `shops` AS `Shop` ON (`Shop`.`user_id` = `News`.`user_id`) WHERE `News`.`user_id` = 5052 GROUP BY `News`.`id` 000
66SELECT `News`.`id`, `News`.`user_id`, `News`.`title`, `News`.`comment`, `News`.`created`, `News`.`modified`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`kana`, `User`.`large_area_id`, `User`.`small_area_id`, `User`.`is_review_display`, `User`.`is_running`, `User`.`plan_id`, `User`.`is_access_enabled`, `User`.`review_accept`, `User`.`is_shops_headline`, `User`.`is_jobs_headline`, `User`.`is_yellowpage_headline`, `User`.`is_official_layout`, `User`.`is_background_image_upload`, `User`.`is_template`, `User`.`created`, `User`.`modified`, `LargeArea`.`id`, `LargeArea`.`name`, `LargeArea`.`url`, `LargeArea`.`banner_search_order`, `LargeArea`.`created`, `LargeArea`.`modified`, `Shop`.`id`, `Shop`.`user_id`, `Shop`.`name`, `Shop`.`shops_business_category_id`, `Shop`.`phone_number`, `Shop`.`email`, `Shop`.`shop_hour_open`, `Shop`.`shop_hour_close`, `Shop`.`url_pc`, `Shop`.`url_mobile`, `Shop`.`url_smartphone`, `Shop`.`shops_price_id`, `Shop`.`shops_discount_id`, `Shop`.`notify_number`, `Shop`.`girls_mobile_email`, `Shop`.`banner_pc`, `Shop`.`banner_mobile`, `Shop`.`mini_banner_pc`, `Shop`.`mini_banner_mobile`, `Shop`.`head_pc`, `Shop`.`head_mobile`, `Shop`.`background_image_pc`, `Shop`.`background_image_mobile`, `Shop`.`background_image_smartphone`, `Shop`.`pc_template_id`, `Shop`.`mobile_template_id`, `Shop`.`smartphone_template_id`, `Shop`.`is_job_message_receive_mail`, `Shop`.`recommend_girl`, `Shop`.`recommend_comment`, `Shop`.`other_price_system`, `Shop`.`is_created`, `Shop`.`created`, `Shop`.`modified` FROM `news` AS `News` LEFT JOIN `users` AS `User` ON (`User`.`id` = `News`.`user_id`) LEFT JOIN `large_areas` AS `LargeArea` ON (`User`.`large_area_id` = `LargeArea`.`id`) LEFT JOIN `shops` AS `Shop` ON (`Shop`.`user_id` = `News`.`user_id`) WHERE `News`.`user_id` = 5052 GROUP BY `News`.`id` ORDER BY `News`.`modified` desc LIMIT 10001