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 | 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 `id` = 348 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 | 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 | |