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 `Category`.`id`, `Category`.`name`, `Category`.`background`, `Category`.`font` FROM `kir060294_recruit`.`categories` AS `Category` WHERE `flag` = '1' ORDER BY `order` desc | 11 | 11 | 0 | |
SELECT `Topic`.`id`, `Topic`.`category_id`, `Topic`.`title`, `Topic`.`date` FROM `kir060294_recruit`.`topics` AS `Topic` WHERE `Topic`.`flag` = '1' ORDER BY `Topic`.`date` desc LIMIT 20 | 20 | 20 | 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, 204, 203, 202, 201, 200, 199, 198, 197, 196, 195, 194, 193, 192, 191, 189) ORDER BY `Image`.`order` ASC | 20 | 20 | 1 | maybe slow |
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, 204, 203, 202, 201, 200, 199, 198, 197, 196, 195, 194, 193, 192, 191, 189) | 20 | 20 | 0 | |
SELECT COUNT(*) AS `count` FROM `kir060294_recruit`.`topics` AS `Topic` WHERE `Topic`.`flag` = '1' | 1 | 1 | 1 | |
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 | |