Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Area`.`id`, `Area`.`display_flag`, `Area`.`name`, `Area`.`name_jp`, `Area`.`number` FROM `kir060294_recruit`.`areas` AS `Area` WHERE `Area`.`display_flag` = '1' ORDER BY `number` asc | 4 | 4 | 1 | maybe slow |
SELECT `Shop`.`id`, `Shop`.`display_flag`, `Shop`.`area_id`, `Shop`.`name`, `Shop`.`name_eng`, `Shop`.`open`, `Shop`.`close`, `Shop`.`mail`, `Shop`.`admin_mail`, `Shop`.`line`, `Shop`.`qr`, `Shop`.`tel`, `Shop`.`free_dial`, `Shop`.`address`, `Shop`.`lat`, `Shop`.`lng`, `Shop`.`text`, `Shop`.`src`, `Shop`.`color`, `Shop`.`official_url`, `Shop`.`recruit_url`, `Shop`.`number` FROM `kir060294_recruit`.`shops` AS `Shop` WHERE `display_flag` = '1' AND `Shop`.`area_id` IN (1, 2, 3, 4) ORDER BY `number` asc | 9 | 9 | 1 | maybe slow |
SELECT `Category`.`id` FROM `kir060294_recruit`.`categories` AS `Category` WHERE ((`flag` = '1') AND (`name` = 'リアルグループ')) LIMIT 1 | 1 | 1 | 0 | |
SELECT `Topic`.`id`, `Topic`.`title` FROM `kir060294_recruit`.`topics` AS `Topic` WHERE `Topic`.`flag` = '1' ORDER BY `date` desc LIMIT 5 | 5 | 5 | 1 | maybe slow |
SELECT `Image`.`id`, `Image`.`topic_id`, `Image`.`src`, `Image`.`alt`, `Image`.`order` FROM `kir060294_recruit`.`images` AS `Image` WHERE `Image`.`topic_id` IN (209, 208, 207, 206, 205) ORDER BY `Image`.`order` ASC | 5 | 5 | 0 | |
SELECT `HashTag`.`id`, `HashTag`.`topic_id`, `HashTag`.`flag`, `HashTag`.`hash`, `HashTag`.`updated` FROM `kir060294_recruit`.`hash_tags` AS `HashTag` WHERE `HashTag`.`topic_id` IN (209, 208, 207, 206, 205) | 5 | 5 | 0 | |
SELECT `Shop`.`area_id` FROM `kir060294_recruit`.`shops` AS `Shop` WHERE 1 = 1 ORDER BY `area_id` asc LIMIT 1 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`shops` AS `Shop` WHERE `display_flag` = '1' AND `area_id` = 1 | 1 | 1 | 0 | |
SELECT `Shop`.`id`, `Shop`.`display_flag`, `Shop`.`area_id`, `Shop`.`name`, `Shop`.`name_eng`, `Shop`.`open`, `Shop`.`close`, `Shop`.`mail`, `Shop`.`admin_mail`, `Shop`.`line`, `Shop`.`qr`, `Shop`.`tel`, `Shop`.`free_dial`, `Shop`.`address`, `Shop`.`lat`, `Shop`.`lng`, `Shop`.`text`, `Shop`.`src`, `Shop`.`color`, `Shop`.`official_url`, `Shop`.`recruit_url`, `Shop`.`number` FROM `kir060294_recruit`.`shops` AS `Shop` WHERE `display_flag` = '1' AND `area_id` = 1 ORDER BY `number` asc | 4 | 4 | 0 | |
SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`shops` AS `Shop` WHERE `display_flag` = '1' AND `area_id` = 2 | 1 | 1 | 0 | |
SELECT `Shop`.`id`, `Shop`.`display_flag`, `Shop`.`area_id`, `Shop`.`name`, `Shop`.`name_eng`, `Shop`.`open`, `Shop`.`close`, `Shop`.`mail`, `Shop`.`admin_mail`, `Shop`.`line`, `Shop`.`qr`, `Shop`.`tel`, `Shop`.`free_dial`, `Shop`.`address`, `Shop`.`lat`, `Shop`.`lng`, `Shop`.`text`, `Shop`.`src`, `Shop`.`color`, `Shop`.`official_url`, `Shop`.`recruit_url`, `Shop`.`number` FROM `kir060294_recruit`.`shops` AS `Shop` WHERE `display_flag` = '1' AND `area_id` = 2 ORDER BY `number` asc | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`shops` AS `Shop` WHERE `display_flag` = '1' AND `area_id` = 3 | 1 | 1 | 0 | |
SELECT `Shop`.`id`, `Shop`.`display_flag`, `Shop`.`area_id`, `Shop`.`name`, `Shop`.`name_eng`, `Shop`.`open`, `Shop`.`close`, `Shop`.`mail`, `Shop`.`admin_mail`, `Shop`.`line`, `Shop`.`qr`, `Shop`.`tel`, `Shop`.`free_dial`, `Shop`.`address`, `Shop`.`lat`, `Shop`.`lng`, `Shop`.`text`, `Shop`.`src`, `Shop`.`color`, `Shop`.`official_url`, `Shop`.`recruit_url`, `Shop`.`number` FROM `kir060294_recruit`.`shops` AS `Shop` WHERE `display_flag` = '1' AND `area_id` = 3 ORDER BY `number` asc | 2 | 2 | 0 | |
SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`shops` AS `Shop` WHERE `display_flag` = '1' AND `area_id` = 4 | 1 | 1 | 0 | |
SELECT `Shop`.`id`, `Shop`.`display_flag`, `Shop`.`area_id`, `Shop`.`name`, `Shop`.`name_eng`, `Shop`.`open`, `Shop`.`close`, `Shop`.`mail`, `Shop`.`admin_mail`, `Shop`.`line`, `Shop`.`qr`, `Shop`.`tel`, `Shop`.`free_dial`, `Shop`.`address`, `Shop`.`lat`, `Shop`.`lng`, `Shop`.`text`, `Shop`.`src`, `Shop`.`color`, `Shop`.`official_url`, `Shop`.`recruit_url`, `Shop`.`number` FROM `kir060294_recruit`.`shops` AS `Shop` WHERE `display_flag` = '1' AND `area_id` = 4 ORDER BY `number` asc | 2 | 2 | 0 | |
SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`shops` AS `Shop` WHERE `display_flag` = '1' AND `area_id` = 5 | 1 | 1 | 0 | |
SELECT `Shop`.`id`, `Shop`.`display_flag`, `Shop`.`area_id`, `Shop`.`name`, `Shop`.`name_eng`, `Shop`.`open`, `Shop`.`close`, `Shop`.`mail`, `Shop`.`admin_mail`, `Shop`.`line`, `Shop`.`qr`, `Shop`.`tel`, `Shop`.`free_dial`, `Shop`.`address`, `Shop`.`lat`, `Shop`.`lng`, `Shop`.`text`, `Shop`.`src`, `Shop`.`color`, `Shop`.`official_url`, `Shop`.`recruit_url`, `Shop`.`number` FROM `kir060294_recruit`.`shops` AS `Shop` WHERE `name_eng` IN ('real', 'teco', 'vivid') AND `display_flag` = '1' ORDER BY `number` asc | 6 | 6 | 0 | |
SELECT `Shop`.`id`, `Shop`.`display_flag`, `Shop`.`area_id`, `Shop`.`name`, `Shop`.`name_eng`, `Shop`.`open`, `Shop`.`close`, `Shop`.`mail`, `Shop`.`admin_mail`, `Shop`.`line`, `Shop`.`qr`, `Shop`.`tel`, `Shop`.`free_dial`, `Shop`.`address`, `Shop`.`lat`, `Shop`.`lng`, `Shop`.`text`, `Shop`.`src`, `Shop`.`color`, `Shop`.`official_url`, `Shop`.`recruit_url`, `Shop`.`number` FROM `kir060294_recruit`.`shops` AS `Shop` WHERE `name_eng` IN ('real', 'mrs', 'teco', 'vivid') AND `display_flag` = '1' ORDER BY `number` asc | 9 | 9 | 0 | |
SELECT `Shop`.`id`, `Shop`.`display_flag`, `Shop`.`area_id`, `Shop`.`name`, `Shop`.`name_eng`, `Shop`.`open`, `Shop`.`close`, `Shop`.`mail`, `Shop`.`admin_mail`, `Shop`.`line`, `Shop`.`qr`, `Shop`.`tel`, `Shop`.`free_dial`, `Shop`.`address`, `Shop`.`lat`, `Shop`.`lng`, `Shop`.`text`, `Shop`.`src`, `Shop`.`color`, `Shop`.`official_url`, `Shop`.`recruit_url`, `Shop`.`number` FROM `kir060294_recruit`.`shops` AS `Shop` WHERE `name_eng` IN ('real', 'mrs', 'vivid') AND `display_flag` = '1' ORDER BY `number` asc | 8 | 8 | 0 | |
SELECT `Shop`.`id`, `Shop`.`display_flag`, `Shop`.`area_id`, `Shop`.`name`, `Shop`.`name_eng`, `Shop`.`open`, `Shop`.`close`, `Shop`.`mail`, `Shop`.`admin_mail`, `Shop`.`line`, `Shop`.`qr`, `Shop`.`tel`, `Shop`.`free_dial`, `Shop`.`address`, `Shop`.`lat`, `Shop`.`lng`, `Shop`.`text`, `Shop`.`src`, `Shop`.`color`, `Shop`.`official_url`, `Shop`.`recruit_url`, `Shop`.`number` FROM `kir060294_recruit`.`shops` AS `Shop` WHERE name_eng = ('teco') AND `display_flag` = '1' ORDER BY `number` asc | 1 | 1 | 0 | |
SELECT `Shop`.`id`, `Shop`.`display_flag`, `Shop`.`area_id`, `Shop`.`name`, `Shop`.`name_eng`, `Shop`.`open`, `Shop`.`close`, `Shop`.`mail`, `Shop`.`admin_mail`, `Shop`.`line`, `Shop`.`qr`, `Shop`.`tel`, `Shop`.`free_dial`, `Shop`.`address`, `Shop`.`lat`, `Shop`.`lng`, `Shop`.`text`, `Shop`.`src`, `Shop`.`color`, `Shop`.`official_url`, `Shop`.`recruit_url`, `Shop`.`number` FROM `kir060294_recruit`.`shops` AS `Shop` WHERE `name_eng` IN ('real', 'mrs') AND `display_flag` = '1' ORDER BY `number` asc | 7 | 7 | 0 | |
SELECT `Shop`.`id`, `Shop`.`display_flag`, `Shop`.`area_id`, `Shop`.`name`, `Shop`.`name_eng`, `Shop`.`open`, `Shop`.`close`, `Shop`.`mail`, `Shop`.`admin_mail`, `Shop`.`line`, `Shop`.`qr`, `Shop`.`tel`, `Shop`.`free_dial`, `Shop`.`address`, `Shop`.`lat`, `Shop`.`lng`, `Shop`.`text`, `Shop`.`src`, `Shop`.`color`, `Shop`.`official_url`, `Shop`.`recruit_url`, `Shop`.`number` FROM `kir060294_recruit`.`shops` AS `Shop` WHERE name_eng = ('vivid') AND `display_flag` = '1' ORDER BY `number` asc | 1 | 1 | 0 | |
SELECT `Topic`.`title`, `Topic`.`date`, `Topic`.`id` FROM `kir060294_recruit`.`topics` AS `Topic` WHERE `flag` = '1' ORDER BY `date` desc LIMIT 1 | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`topic_id`, `Image`.`src`, `Image`.`alt`, `Image`.`order` FROM `kir060294_recruit`.`images` AS `Image` WHERE `Image`.`topic_id` = (209) ORDER BY `Image`.`order` ASC | 1 | 1 | 0 | |
SELECT `HashTag`.`id`, `HashTag`.`topic_id`, `HashTag`.`flag`, `HashTag`.`hash`, `HashTag`.`updated` FROM `kir060294_recruit`.`hash_tags` AS `HashTag` WHERE `HashTag`.`topic_id` = (209) | 1 | 1 | 0 | |