941.92790985107 大分 デリヘル 桃色奥様 高収入求人情報

業種
電話番号
メールアドレス
資格
こだわり
バック率

お店からのメッセージ


(default) 67 queries took 923 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`22222
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` = 6 AND `ShopsAccess`.`ip` = '54.210.158.163' AND `ShopsAccess`.`created` >= '2019-06-19 16:22:19' 11580
56INSERT INTO `shops_accesses` (`user_id`, `view_id`, `ip`, `modified`, `created`) VALUES (5052, 6, '54.210.158.163', '2019-06-19 17:22:20', '2019-06-19 17:22:20')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` = '54.210.158.163' AND `Point`.`created` >= '2019-06-19 16:22:20' 111
60SELECT `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
61SELECT `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
62SELECT `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
63SELECT `MJobsCharacter`.`id`, `MJobsCharacter`.`name`, `MJobsCharacter`.`created`, `MJobsCharacter`.`modified` FROM `m_jobs_characters` AS `MJobsCharacter` WHERE 1 = 1 22220
64SHOW FULL COLUMNS FROM `jobs_characters`661
65SELECT `Job`.`id`, `Job`.`user_id`, `Job`.`catch_phrase`, `Job`.`phone_number`, `Job`.`email`, `Job`.`jobs_business_category_id`, `Job`.`qualification`, `Job`.`jobs_back_rate_id`, `Job`.`comment`, `Job`.`image_pc`, `Job`.`image_mobile`, `Job`.`created`, `Job`.`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`, `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`, `MJobsBackRate`.`id`, `MJobsBackRate`.`name`, `MJobsBackRate`.`created`, `MJobsBackRate`.`modified`, `MJobsBusinessCategory`.`id`, `MJobsBusinessCategory`.`name`, `MJobsBusinessCategory`.`created`, `MJobsBusinessCategory`.`modified` FROM `jobs` AS `Job` LEFT JOIN `users` AS `User` ON (`User`.`id` = `Job`.`user_id`) LEFT JOIN `large_areas` AS `LargeArea` ON (`User`.`large_area_id` = `LargeArea`.`id`) LEFT JOIN `shops` AS `Shop` ON (`Job`.`user_id` = `Shop`.`user_id`) LEFT JOIN `plans` AS `Plan` ON (`Plan`.`id` = `User`.`plan_id`) LEFT JOIN `m_jobs_back_rates` AS `MJobsBackRate` ON (`MJobsBackRate`.`id` = `Job`.`jobs_back_rate_id`) LEFT JOIN `m_jobs_business_categories` AS `MJobsBusinessCategory` ON (`MJobsBusinessCategory`.`id` = `Job`.`jobs_business_category_id`) WHERE `Job`.`user_id` = 5052 LIMIT 1001
66SELECT COUNT(*) AS `count` FROM `jobsquicks` AS `Jobsquick` LEFT JOIN `users` AS `User` ON (`User`.`id` = `Jobsquick`.`user_id`) LEFT JOIN `large_areas` AS `LargeArea` ON (`User`.`large_area_id` = `LargeArea`.`id`) LEFT JOIN `shops` AS `Shop` ON (`Shop`.`user_id` = `Jobsquick`.`user_id`) LEFT JOIN `plans` AS `Plan` ON (`Plan`.`id` = `User`.`plan_id`) WHERE `Jobsquick`.`user_id` = 5052 GROUP BY `Jobsquick`.`id` 0075
67SELECT `Jobsquick`.`id`, `Jobsquick`.`user_id`, `Jobsquick`.`title`, `Jobsquick`.`comment`, `Jobsquick`.`created`, `Jobsquick`.`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`, `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 `jobsquicks` AS `Jobsquick` LEFT JOIN `users` AS `User` ON (`User`.`id` = `Jobsquick`.`user_id`) LEFT JOIN `large_areas` AS `LargeArea` ON (`User`.`large_area_id` = `LargeArea`.`id`) LEFT JOIN `shops` AS `Shop` ON (`Shop`.`user_id` = `Jobsquick`.`user_id`) LEFT JOIN `plans` AS `Plan` ON (`Plan`.`id` = `User`.`plan_id`) WHERE `Jobsquick`.`user_id` = 5052 GROUP BY `Jobsquick`.`id` ORDER BY `Jobsquick`.`modified` desc LIMIT 1000209