| 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 |  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 `Shop`.`area_id` IN (1, 2, 3, 4)   ORDER BY `number` asc |  9 |  9 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `id` = 260    LIMIT 1 |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'あ' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'い' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'う' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'え' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'お' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'か' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'き' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'く' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'け' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'こ' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'さ' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'し' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'す' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'せ' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'そ' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'た' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'ち' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'つ' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'て' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'と' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'な' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'に' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'ぬ' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'ね' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'の' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'は' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'ひ' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'ふ' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'へ' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'ほ' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'ま' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'み' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'む' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'め' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'も' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'や' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'ゆ' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'よ' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'ら' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'り' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'る' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'れ' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'ろ' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'わ' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'を' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = 'ん' |  1 |  1 |  0 |   | 
| SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `display_flag` = '1' AND `initial` = '英数' |  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 |   |