| 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 `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'あ' AND `display_flag` = '1' |  10 |  10 |  1 |  maybe slow | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'い' AND `display_flag` = '1' |  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 `initial` = 'う' AND `display_flag` = '1' |  3 |  3 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'え' AND `display_flag` = '1' |  5 |  5 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'お' AND `display_flag` = '1' |  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 `initial` = 'か' AND `display_flag` = '1' |  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 `initial` = 'き' AND `display_flag` = '1' |  3 |  3 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'く' AND `display_flag` = '1' |  4 |  4 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'け' AND `display_flag` = '1' |  2 |  2 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'こ' AND `display_flag` = '1' |  6 |  6 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'さ' AND `display_flag` = '1' |  5 |  5 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'し' AND `display_flag` = '1' |  12 |  12 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'す' AND `display_flag` = '1' |  7 |  7 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'せ' AND `display_flag` = '1' |  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 `initial` = 'そ' AND `display_flag` = '1' |  6 |  6 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'た' AND `display_flag` = '1' |  4 |  4 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'ち' AND `display_flag` = '1' |  6 |  6 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'つ' AND `display_flag` = '1' |  1 |  1 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'て' AND `display_flag` = '1' |  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 `initial` = 'と' AND `display_flag` = '1' |  3 |  3 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'な' AND `display_flag` = '1' |  2 |  2 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'に' AND `display_flag` = '1' |  2 |  2 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'ぬ' AND `display_flag` = '1' |  0 |  0 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'ね' AND `display_flag` = '1' |  0 |  0 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'の' AND `display_flag` = '1' |  0 |  0 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'は' AND `display_flag` = '1' |  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 `initial` = 'ひ' AND `display_flag` = '1' |  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 `initial` = 'ふ' AND `display_flag` = '1' |  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 `initial` = 'へ' AND `display_flag` = '1' |  2 |  2 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'ほ' AND `display_flag` = '1' |  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 `initial` = 'ま' AND `display_flag` = '1' |  3 |  3 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'み' AND `display_flag` = '1' |  3 |  3 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'む' AND `display_flag` = '1' |  2 |  2 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'め' AND `display_flag` = '1' |  3 |  3 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'も' AND `display_flag` = '1' |  1 |  1 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'や' AND `display_flag` = '1' |  0 |  0 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'ゆ' AND `display_flag` = '1' |  3 |  3 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'よ' AND `display_flag` = '1' |  2 |  2 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'ら' AND `display_flag` = '1' |  1 |  1 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'り' AND `display_flag` = '1' |  2 |  2 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'る' AND `display_flag` = '1' |  0 |  0 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'れ' AND `display_flag` = '1' |  1 |  1 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'ろ' AND `display_flag` = '1' |  2 |  2 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'わ' AND `display_flag` = '1' |  0 |  0 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'を' AND `display_flag` = '1' |  0 |  0 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = 'ん' AND `display_flag` = '1' |  0 |  0 |  0 |   | 
| SELECT `Dictionary`.`id`, `Dictionary`.`display_flag`, `Dictionary`.`category`, `Dictionary`.`initial`, `Dictionary`.`word`, `Dictionary`.`explanation`, `Dictionary`.`date` FROM `kir060294_recruit`.`dictionaries` AS `Dictionary`   WHERE `initial` = '英数' AND `display_flag` = '1' |  11 |  11 |  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 |  1 |   | 
| 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 |   |