604.38203811646 大分 デリヘル 柏 桃色クリスタル キャスト

在籍キャスト


中谷 うみ(21)
166cm/95(F)/60/87

朝摘 いちご(19)
156cm/86(B)/57/85

神崎 翔子(24)
149cm/82(C)/55/83

立川 奈々(22)
156cm/87(D)/57/86

松本 ゆい(19)
150cm/79(C)/57/78

高梨鈴(25)
156cm/90(E)/59/88

岡本 せな(20)
163cm/82(C)/56/84

木の実くるみ(21)
157cm/85(C)/56/85

氷室 嶺(22)
160cm/88(D)/55/86

藤井 優(19)
163cm/87(D)/57/88

月影 ライス(25)
159cm/85(C)/55/83

秋元 みおん(25)
153cm/83(B)/58/84

浅倉 ひろ(24)
154cm/86(E)/59/86

石原 あやか(20)
158cm/84(B)/57/83

北野あすか(21)
155cm/82(B)/58/85

一色 瞬花(21)
148cm/82(B)/57/84

鈴木 莉緒(18)
151cm/85(C)/56/81

廣瀬るな(20)
148cm/75(B)/55/78

白鳥ことり(22)
163cm/84(C)/56/85

鳥山 つばさ(24)
163cm/85(C)/58/85

鳥山 つばめ(24)
163cm/85(C)/58/85

蓮咲 れんか(19)
154cm/89(E)/58/88

天使 もえ(20)
150cm/84(C)/58/83

源 しずか(19)
152cm/90(E)/58/88

早川 ありさ(26)
168cm/85(D)/58/87

(default) 65 queries took 616 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `users`19191
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
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`4413
22SHOW FULL COLUMNS FROM `m_jobs_business_categories`4413
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` = 5582 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` = 5582 AND `Shop`.`is_created` = 1 110
55SELECT COUNT(*) AS `count` FROM `shops_accesses` AS `ShopsAccess` WHERE `ShopsAccess`.`user_id` = 5582 AND `ShopsAccess`.`view_id` = 3 AND `ShopsAccess`.`ip` = '54.163.20.57' AND `ShopsAccess`.`created` >= '2018-11-20 09:14:35' 11532
56INSERT INTO `shops_accesses` (`user_id`, `view_id`, `ip`, `modified`, `created`) VALUES (5582, 3, '54.163.20.57', '2018-11-20 10:14:35', '2018-11-20 10:14:35')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` = 5582 AND `Point`.`ip` = '54.163.20.57' AND `Point`.`created` >= '2018-11-20 09:14:35' 111
60INSERT INTO `points` (`user_id`, `points`, `ip`, `modified`, `created`) VALUES (5582, 1, '54.163.20.57', '2018-11-20 10:14:35', '2018-11-20 10:14:35')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` = 5582 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` = 5582 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` = 5582 LIMIT 1111
65SELECT `Girl`.`id`, `Girl`.`user_id`, `Girl`.`name`, `Girl`.`bbs_mail`, `Girl`.`blog_url`, `Girl`.`age`, `Girl`.`body_height`, `Girl`.`girls_cup_id`, `Girl`.`bust`, `Girl`.`waist`, `Girl`.`hip`, `Girl`.`girls_type_id`, `Girl`.`girls_smoke_id`, `Girl`.`girls_tattoo_id`, `Girl`.`girls_face_id`, `Girl`.`comment`, `Girl`.`show_order`, `Girl`.`is_fixed_shift`, `Girl`.`is_hidden`, `Girl`.`created`, `Girl`.`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`, `MGirlsCup`.`id`, `MGirlsCup`.`name`, `MGirlsCup`.`name2`, `MGirlsCup`.`created`, `MGirlsCup`.`modified`, `MShopsBusinessCategory`.`id`, `MShopsBusinessCategory`.`name`, `MShopsBusinessCategory`.`created`, `MShopsBusinessCategory`.`modified`, `MGirlsType`.`id`, `MGirlsType`.`name`, `MGirlsType`.`show_order`, `MGirlsType`.`created`, `MGirlsType`.`modified`, `MGirlsSmoke`.`id`, `MGirlsSmoke`.`name`, `MGirlsSmoke`.`created`, `MGirlsSmoke`.`modified`, `MGirlsTattoo`.`id`, `MGirlsTattoo`.`name`, `MGirlsTattoo`.`created`, `MGirlsTattoo`.`modified` FROM `girls` AS `Girl` LEFT JOIN `users` AS `User` ON (`User`.`id` = `Girl`.`user_id`) LEFT JOIN `large_areas` AS `LargeArea` ON (`User`.`large_area_id` = `LargeArea`.`id`) LEFT JOIN `shops` AS `Shop` ON (`Shop`.`user_id` = `Girl`.`user_id`) LEFT JOIN `m_girls_cups` AS `MGirlsCup` ON (`MGirlsCup`.`id` = `Girl`.`girls_cup_id`) LEFT JOIN `m_shops_business_categories` AS `MShopsBusinessCategory` ON (`Shop`.`shops_business_category_id` = `MShopsBusinessCategory`.`id`) LEFT JOIN `m_girls_types` AS `MGirlsType` ON (`Girl`.`girls_type_id` = `MGirlsType`.`id`) LEFT JOIN `m_girls_smokes` AS `MGirlsSmoke` ON (`Girl`.`girls_smoke_id` = `MGirlsSmoke`.`id`) LEFT JOIN `m_girls_tattoos` AS `MGirlsTattoo` ON (`Girl`.`girls_tattoo_id` = `MGirlsTattoo`.`id`) WHERE `Girl`.`user_id` = 5582 AND `Girl`.`is_hidden` <> '1' GROUP BY `Girl`.`id` ORDER BY `Girl`.`show_order` ASC, `Girl`.`created` ASC 25255