イヤサレは、風俗エステ・メンズエステ情報が満載のサイトです。

お店を探す

エリアから探す

新宿・池袋エリア

上野・神田エリア

東京・銀座エリア

目黒・品川エリア

渋谷・下北エリア

西東京エリア

神奈川エリア

埼玉エリア

千葉エリア

北関東エリア

こだわりから探す

(default) 30 queries took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Shop`.`id`, `Shop`.`shopname` FROM `iyasare`.`shops` AS `Shop` LEFT JOIN `iyasare`.`areas` AS `Area` ON (`Shop`.`area_id` = `Area`.`id`) WHERE `Shop`.`view` = '1' AND `Shop`.`delflag` = '0' AND `Shop`.`newflag` = '1' AND `Shop`.`created` >= '2019-09-11 11:12:00' ORDER BY `Shop`.`created` DESC LIMIT 5000
2SELECT `Shop`.`id`, `Shop`.`shopname`, `Shop`.`image_hbanner_pc` FROM `iyasare`.`shops` AS `Shop` LEFT JOIN `iyasare`.`areas` AS `Area` ON (`Shop`.`area_id` = `Area`.`id`) WHERE `Shop`.`view` = '1' AND `Shop`.`delflag` = '0' AND `Shop`.`rank` = 1 AND NOT (`Shop`.`image_hbanner_pc` = '') ORDER BY RAND() ASC LIMIT 2220
3SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555015) ORDER BY `Girl`.`pos` ASC LIMIT 2220
4SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555004) ORDER BY `Girl`.`pos` ASC LIMIT 2220
5SELECT `Shop`.`id`, `Shop`.`shopname`, `Shop`.`image_sbanner_pc` FROM `iyasare`.`shops` AS `Shop` LEFT JOIN `iyasare`.`areas` AS `Area` ON (`Shop`.`area_id` = `Area`.`id`) WHERE `Shop`.`view` = '1' AND `Shop`.`delflag` = '0' AND `Shop`.`rank` IN (1, 2) AND NOT (`Shop`.`image_sbanner_pc` = '') ORDER BY RAND() ASC LIMIT 10551
6SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555019) ORDER BY `Girl`.`pos` ASC LIMIT 2220
7SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555020) ORDER BY `Girl`.`pos` ASC LIMIT 2220
8SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555016) ORDER BY `Girl`.`pos` ASC LIMIT 2220
9SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555006) ORDER BY `Girl`.`pos` ASC LIMIT 2220
10SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555029) ORDER BY `Girl`.`pos` ASC LIMIT 2220
11SELECT `Area`.`id`, `Area`.`name`, `Area`.`area1` FROM `iyasare`.`areas` AS `Area` WHERE 1 = 1 ORDER BY `Area`.`view` ASC32320
12SELECT `Kodawari`.`id`, `Kodawari`.`name` FROM `iyasare`.`kodawaris` AS `Kodawari` WHERE 1 = 1 ORDER BY `Kodawari`.`view` ASC18180
13SELECT `Shop`.`id`, `Shop`.`pw`, `Shop`.`agency_name`, `Shop`.`rank`, `Shop`.`rank_2_c`, `Shop`.`shopname`, `Shop`.`view`, `Shop`.`tel`, `Shop`.`hp`, `Shop`.`hp_sp`, `Shop`.`email`, `Shop`.`area_id`, `Shop`.`address`, `Shop`.`address2`, `Shop`.`map_access`, `Shop`.`map_view`, `Shop`.`lat`, `Shop`.`lon`, `Shop`.`station`, `Shop`.`open24`, `Shop`.`open_add`, `Shop`.`open_hour`, `Shop`.`open_minute`, `Shop`.`close_hour`, `Shop`.`close_minute`, `Shop`.`price_0`, `Shop`.`price_1`, `Shop`.`price_2`, `Shop`.`price_3`, `Shop`.`price_1_name`, `Shop`.`price_2_name`, `Shop`.`price_3_name`, `Shop`.`price_0_minute`, `Shop`.`price_1_minute`, `Shop`.`price_2_minute`, `Shop`.`price_3_minute`, `Shop`.`catch`, `Shop`.`link_blog`, `Shop`.`link_facebook`, `Shop`.`link_twitter`, `Shop`.`link_hw`, `Shop`.`tokuwari`, `Shop`.`tokuwari_title`, `Shop`.`tokuwari_price`, `Shop`.`tokuwari_cond`, `Shop`.`search_word`, `Shop`.`image_hbanner_pc`, `Shop`.`image_sbanner_pc`, `Shop`.`created`, `Shop`.`modified`, `Shop`.`delflag`, `Shop`.`newflag`, `Area`.`id`, `Area`.`name` FROM `iyasare`.`shops` AS `Shop` LEFT JOIN `iyasare`.`areas` AS `Area` ON (`Shop`.`area_id` = `Area`.`id`) WHERE `Shop`.`id` = 555029 LIMIT 1110
14SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555029) ORDER BY `Girl`.`pos` ASC LIMIT 2220
15SELECT `Area`.`id`, `Area`.`name` FROM `iyasare`.`areas` AS `Area` WHERE `Area`.`id` = 2 LIMIT 1110
16SELECT `Plan`.`rank_1` FROM `iyasare`.`plans` AS `Plan` WHERE `Plan`.`id` = 2 LIMIT 1110
17SELECT `Girl`.`id`, `Girl`.`shop_id`, `Girl`.`name`, `Girl`.`age`, `Girl`.`height`, `Girl`.`bust`, `Girl`.`cup`, `Girl`.`waist`, `Girl`.`hip`, `Girl`.`comment`, `Girl`.`profile_image`, `Girl`.`pos`, `Girl`.`created`, `Girl`.`modified`, `Girl`.`view` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = 555029 ORDER BY `Girl`.`pos` ASC LIMIT 6330
18SELECT COUNT(*) AS `count` FROM `iyasare`.`blogs` AS `Blog` LEFT JOIN `iyasare`.`shops` AS `Shop` ON (`Blog`.`shop_id` = `Shop`.`id`) WHERE `Blog`.`shop_id` = 555029110
19SELECT COUNT(*) AS `count` FROM `iyasare`.`voices` AS `Voice` LEFT JOIN `iyasare`.`shops` AS `Shop` ON (`Voice`.`shop_id` = `Shop`.`id`) WHERE `Voice`.`shop_id` = 555029110
20SELECT `Realtime`.`id`, `Realtime`.`shop_id`, `Realtime`.`body`, `Realtime`.`modified`, `Shop`.`id`, `Shop`.`shopname` FROM `iyasare`.`realtimes` AS `Realtime` LEFT JOIN `iyasare`.`shops` AS `Shop` ON (`Realtime`.`shop_id` = `Shop`.`id`) WHERE `Realtime`.`shop_id` = 555029 AND `Realtime`.`modified` < '2019-09-22 11:12:00' ORDER BY `Realtime`.`modified` DESC LIMIT 1000
21SELECT `Kodawari`.`id`, `Kodawari`.`name` FROM `iyasare`.`kodawaris` AS `Kodawari` WHERE 1 = 1 ORDER BY `view` ASC18180
22SELECT `ShopKodawari`.`id`, `ShopKodawari`.`kodawariid` FROM `iyasare`.`shop_kodawaris` AS `ShopKodawari` WHERE `ShopKodawari`.`shopid` = 555029440
23SELECT `AccessShop`.`id`, `AccessShop`.`count_pc`, `AccessShop`.`count_sp` FROM `iyasare`.`access_shops` AS `AccessShop` WHERE `AccessShop`.`created` = '2019-09-22' AND `AccessShop`.`shopid` = 555029 LIMIT 1110
24BEGIN000
25SELECT COUNT(*) AS `count` FROM `iyasare`.`access_shops` AS `AccessShop` WHERE `AccessShop`.`id` = 11702110
26SELECT COUNT(*) AS `count` FROM `iyasare`.`access_shops` AS `AccessShop` WHERE `AccessShop`.`id` = 11702110
27SELECT COUNT(*) AS `count` FROM `iyasare`.`access_shops` AS `AccessShop` WHERE `AccessShop`.`id` = 11702110
28UPDATE `iyasare`.`access_shops` SET `created` = '2019-09-22', `shopid` = 555029, `count_pc` = 2, `id` = 11702 WHERE `iyasare`.`access_shops`.`id` = '11702'110
29COMMIT000
30SELECT `Movie`.`id`, `Movie`.`shop_id`, `Movie`.`youtube`, `Movie`.`youtube_text`, `Movie`.`youtube_status`, `Movie`.`youtube_modified`, `Movie`.`youtube_num`, `Shop`.`id`, `Shop`.`shopname`, `Shop`.`area_id`, `Shop`.`view`, `Shop`.`delflag` FROM `iyasare`.`movies` AS `Movie` LEFT JOIN `iyasare`.`shops` AS `Shop` ON (`Movie`.`shop_id` = `Shop`.`id`) WHERE `Movie`.`shop_id` = 555029000