| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Language`.`dir` FROM `niigata`.`language` AS `Language` WHERE 1 = 1 ORDER BY `order_by` ASC | 6 | 6 | 0 | |
| SELECT `ArticleType`.`slug`, `ArticleType`.`id` FROM `niigata`.`article_type` AS `ArticleType` LEFT JOIN `niigata`.`site_type` AS `SiteType` ON (`ArticleType`.`site_type_id` = `SiteType`.`id`) WHERE 1 = 1 | 9 | 9 | 0 | |
| SELECT `AttractionCategoryType`.`id`, `AttractionCategoryType`.`slug` FROM `niigata`.`attraction_category_type` AS `AttractionCategoryType` WHERE 1 = 1 ORDER BY `order_by` ASC | 3 | 3 | 0 | |
| SELECT `AttractionCategoryL`.`id`, `AttractionCategoryL`.`slug`, `AttractionCategoryL`.`attraction_category_type_id` FROM `niigata`.`attraction_category_l` AS `AttractionCategoryL` WHERE `AttractionCategoryL`.`attraction_category_type_id` IN (1, 2, 3) ORDER BY `order_by` ASC | 10 | 10 | 0 | |
| SELECT `FormTypeL`.`slug`, `FormTypeL`.`id` FROM `niigata`.`form_type_l` AS `FormTypeL` WHERE 1 = 1 | 1 | 1 | 0 | |
| SELECT `LinkCategoryL`.`slug`, `LinkCategoryL`.`id` FROM `niigata`.`link_category_l` AS `LinkCategoryL` WHERE 1 = 1 | 1 | 1 | 0 | |
| SELECT `AttractionCategoryM`.`slug`, `AttractionCategoryM`.`id` FROM `niigata`.`attraction_category_m` AS `AttractionCategoryM` LEFT JOIN `niigata`.`attraction_category_l` AS `AttractionCategoryL` ON (`AttractionCategoryM`.`attraction_category_l_id` = `AttractionCategoryL`.`id`) WHERE `AttractionCategoryM`.`attraction_category_l_id` = 7 | 13 | 13 | 0 | |
| SELECT `Language`.`id`, `Language`.`name`, `Language`.`title`, `Language`.`slug`, `Language`.`dir`, `Language`.`locale`, `Language`.`code`, `Language`.`order_by`, `Language`.`created`, `Language`.`modified` FROM `niigata`.`language` AS `Language` WHERE 1 = 1 ORDER BY `order_by` ASC | 6 | 6 | 0 | |
| SELECT `Language`.`id`, `Language`.`name`, `Language`.`title`, `Language`.`slug`, `Language`.`dir`, `Language`.`locale`, `Language`.`code`, `Language`.`order_by`, `Language`.`created`, `Language`.`modified` FROM `niigata`.`language` AS `Language` WHERE `dir` = 'spot' LIMIT 1 | 0 | 0 | 0 | |
| SELECT `UserImageTagL`.`id`, `UserImageTagL`.`name` FROM `niigata`.`user_image_tag_l` AS `UserImageTagL` WHERE `UserImageTagL`.`user_id` = NULL ORDER BY `UserImageTagL`.`order_by` ASC, `UserImageTagL`.`id` ASC | 0 | 0 | 0 | |
| SELECT (DATE_FORMAT(`UserImage`.`modified`, '%Y%m')) AS `UserImage__modified_value`, (DATE_FORMAT(`UserImage`.`modified`, '%Y年%m月')) AS `UserImage__modified_label` FROM `niigata`.`user_image` AS `UserImage` inner JOIN `niigata`.`user` AS `User` ON (`User`.`id` = `UserImage`.`user_id`) WHERE `User`.`image_box` = NULL ORDER BY (DATE_FORMAT(`UserImage`.`modified`, '%Y%m')) desc | 0 | 0 | 0 | |
| SELECT `SiteConfig`.`id`, `SiteConfig`.`slug`, `SiteConfig`.`value`, `SiteConfig`.`created`, `SiteConfig`.`modified` FROM `niigata`.`site_config` AS `SiteConfig` WHERE `slug` = 'mode_confetti' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `niigata`.`cake_sessions` AS `Session` WHERE `Session`.`id` = '2ce194c2a96f9696da4209c7131728cc' LIMIT 1 | 0 | 0 | 0 | |
| SELECT `AttractionCategoryL`.`id`, `AttractionCategoryL`.`attraction_category_type_id`, `AttractionCategoryL`.`name`, `AttractionCategoryL`.`short_name`, `AttractionCategoryL`.`slug`, `AttractionCategoryL`.`sub_title`, `AttractionCategoryL`.`main_title`, `AttractionCategoryL`.`search_title`, `AttractionCategoryL`.`has_static_top`, `AttractionCategoryL`.`list_bread_title`, `AttractionCategoryL`.`is_public`, `AttractionCategoryL`.`view_from`, `AttractionCategoryL`.`view_to`, `AttractionCategoryL`.`order_by`, `AttractionCategoryL`.`order_by_convert`, `AttractionCategoryL`.`created`, `AttractionCategoryL`.`modified` FROM `niigata`.`attraction_category_l` AS `AttractionCategoryL` WHERE `AttractionCategoryL`.`slug` = 'spot' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attraction`.*, `MainAttractionImage`.*, `MainAttractionCategoryType`.*, `MainAttractionCategoryL`.*, `MainAttractionCategoryM`.*, `MainAttractionCategoryX`.*, `AttractionCategoryL`.*, `AttractionCategoryM`.*, `AttractionCategoryX`.*, `AttractionSakuraQualityL`.*, `AttractionFavorite`.`personal`, `Prefecture`.*, `NecessaryTimeL`.*, `Attraction`.`id` FROM `niigata`.`attraction` AS `Attraction` LEFT JOIN `niigata`.`user` AS `User` ON (`Attraction`.`user_id` = `User`.`id`) LEFT JOIN `niigata`.`prefecture` AS `Prefecture` ON (`Attraction`.`prefecture_id` = `Prefecture`.`id`) LEFT JOIN `niigata`.`city_l` AS `CityL` ON (`Attraction`.`city_l_id` = `CityL`.`id`) LEFT JOIN `niigata`.`attraction_relationship` AS `AttractionRelationship` ON (`Attraction`.`id` = `AttractionRelationship`.`attraction_id`) left JOIN `niigata`.`attraction_favorite` AS `AttractionFavorite` ON (`AttractionFavorite`.`attraction_id` = `Attraction`.`id` AND `AttractionFavorite`.`personal` = 'd5ed8884269535140e544ad1778bd32b') left JOIN `niigata`.`attraction_image` AS `MainAttractionImage` ON (`MainAttractionImage`.`attraction_id` = `Attraction`.`id` AND ((`MainAttractionImage`.`order_by` = 100) OR (`MainAttractionImage`.`is_main`))) inner JOIN `niigata`.`attraction_category` AS `MainAttractionCategory` ON (`MainAttractionCategory`.`attraction_id` = `Attraction`.`id` AND `MainAttractionCategory`.`is_main` = 1) inner JOIN `niigata`.`attraction_category_l` AS `MainAttractionCategoryL` ON (`MainAttractionCategoryL`.`id` = `MainAttractionCategory`.`attraction_category_l_id`) inner JOIN `niigata`.`attraction_category_type` AS `MainAttractionCategoryType` ON (`MainAttractionCategoryL`.`attraction_category_type_id` = `MainAttractionCategoryType`.`id`) left JOIN `niigata`.`attraction_category_m` AS `MainAttractionCategoryM` ON (`MainAttractionCategoryM`.`id` = `MainAttractionCategory`.`attraction_category_m_id`) left JOIN `niigata`.`attraction_category_x` AS `MainAttractionCategoryX` ON (`MainAttractionCategoryX`.`id` = `MainAttractionCategory`.`attraction_category_x_id`) inner JOIN `niigata`.`attraction_category` AS `AttractionCategory` ON (`AttractionCategory`.`attraction_id` = `Attraction`.`id`) inner JOIN `niigata`.`attraction_category_l` AS `AttractionCategoryL` ON (`AttractionCategoryL`.`id` = `AttractionCategory`.`attraction_category_l_id`) left JOIN `niigata`.`attraction_category_m` AS `AttractionCategoryM` ON (`AttractionCategoryM`.`id` = `AttractionCategory`.`attraction_category_m_id`) left JOIN `niigata`.`attraction_category_x` AS `AttractionCategoryX` ON (`AttractionCategoryX`.`id` = `AttractionCategory`.`attraction_category_x_id`) left JOIN `niigata`.`attraction_sakura_quality_l` AS `AttractionSakuraQualityL` ON (`AttractionSakuraQualityL`.`id` = `Attraction`.`attraction_sakura_quality_l_id`) left JOIN `niigata`.`attraction_area` AS `AttractionArea` ON (`AttractionArea`.`attraction_id` = `Attraction`.`id`) left JOIN `niigata`.`attraction_area_l` AS `AttractionAreaL` ON (`AttractionAreaL`.`id` = `AttractionArea`.`attraction_area_l_id`) left JOIN `niigata`.`attraction_area_m` AS `AttractionAreaM` ON (`AttractionAreaM`.`id` = `AttractionArea`.`attraction_area_m_id`) left JOIN `niigata`.`attraction_theme` AS `AttractionTheme` ON (`AttractionTheme`.`attraction_id` = `Attraction`.`id`) left JOIN `niigata`.`attraction_theme_l` AS `AttractionThemeL` ON (`AttractionThemeL`.`id` = `AttractionTheme`.`attraction_theme_l_id`) left JOIN `niigata`.`attraction_pickup` AS `AttractionPickup` ON (`AttractionPickup`.`attraction_id` = `Attraction`.`id`) left JOIN `niigata`.`attraction_pickup_l` AS `AttractionPickupL` ON (`AttractionPickupL`.`id` = `AttractionPickup`.`attraction_pickup_l_id`) left JOIN `niigata`.`attraction_tag` AS `AttractionTag` ON (`AttractionTag`.`attraction_id` = `Attraction`.`id`) left JOIN `niigata`.`attraction_tag_l` AS `AttractionTagL` ON (`AttractionTagL`.`id` = `AttractionTag`.`attraction_tag_l_id`) left JOIN `niigata`.`necessary_time_l` AS `NecessaryTimeL` ON (`NecessaryTimeL`.`id` = `Attraction`.`course_necessary_time_l`) left JOIN `niigata`.`attraction_icon` AS `AttractionIcon` ON (`AttractionIcon`.`attraction_id` = `Attraction`.`id`) left JOIN `niigata`.`attraction_icon_l` AS `AttractionIconL` ON (`AttractionIconL`.`id` = `AttractionIcon`.`attraction_icon_l_id`) left JOIN `niigata`.`attraction_icon_m` AS `AttractionIconM` ON (`AttractionIconM`.`id` = `AttractionIcon`.`attraction_icon_m_id`) WHERE `Attraction`.`id` = 10604 AND `Attraction`.`is_public` = '1' AND (`Attraction`.`view_from` is null or date_format(`Attraction`.`view_from`, '%Y%m%d') <= date_format(now(), '%Y%m%d')) AND (`Attraction`.`view_to` is null or date_format(`Attraction`.`view_to`, '%Y%m%d') >= date_format(now(), '%Y%m%d')) GROUP BY `Attraction`.`id` LIMIT 1 | 1 | 1 | 2 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `niigata`.`attraction_category` AS `AttractionCategory` LEFT JOIN `niigata`.`attraction` AS `Attraction` ON (`AttractionCategory`.`attraction_id` = `Attraction`.`id`) LEFT JOIN `niigata`.`attraction_category_l` AS `AttractionCategoryL` ON (`AttractionCategory`.`attraction_category_l_id` = `AttractionCategoryL`.`id`) LEFT JOIN `niigata`.`attraction_category_m` AS `AttractionCategoryM` ON (`AttractionCategory`.`attraction_category_m_id` = `AttractionCategoryM`.`id`) LEFT JOIN `niigata`.`attraction_category_x` AS `AttractionCategoryX` ON (`AttractionCategory`.`attraction_category_x_id` = `AttractionCategoryX`.`id`) WHERE `AttractionCategory`.`attraction_id` = 10604 AND `AttractionCategoryL`.`slug` = 'spot' AND coalesce(`AttractionCategoryL`.`is_public`, 1) = '1' | 1 | 1 | 0 | |
| SELECT `AttractionImage`.* FROM `niigata`.`attraction_image` AS `AttractionImage` WHERE `AttractionImage`.`attraction_id` = 10604 ORDER BY `AttractionImage`.`order_by` ASC, `AttractionImage`.`id` ASC LIMIT 10 | 2 | 2 | 0 | |
| SELECT `AttractionCategory`.*, `AttractionCategoryL`.`name` AS `AttractionCategoryLName`, `AttractionCategoryM`.`name` AS `AttractionCategoryMName`, `AttractionCategoryX`.`name` AS `AttractionCategoryXName`, `AttractionCategoryL`.*, `AttractionCategoryM`.*, `AttractionCategoryX`.* FROM `niigata`.`attraction_category` AS `AttractionCategory` LEFT JOIN `niigata`.`attraction` AS `Attraction` ON (`AttractionCategory`.`attraction_id` = `Attraction`.`id`) LEFT JOIN `niigata`.`attraction_category_l` AS `AttractionCategoryL` ON (`AttractionCategory`.`attraction_category_l_id` = `AttractionCategoryL`.`id`) LEFT JOIN `niigata`.`attraction_category_m` AS `AttractionCategoryM` ON (`AttractionCategory`.`attraction_category_m_id` = `AttractionCategoryM`.`id`) LEFT JOIN `niigata`.`attraction_category_x` AS `AttractionCategoryX` ON (`AttractionCategory`.`attraction_category_x_id` = `AttractionCategoryX`.`id`) inner JOIN `niigata`.`attraction_category_l` AS `AttractionCategoryL1` ON (`AttractionCategoryL1`.`id` = `AttractionCategory`.`attraction_category_l_id`) inner JOIN `niigata`.`attraction_category_type` AS `AttractionCategoryType` ON (`AttractionCategoryType`.`id` = `AttractionCategoryL1`.`attraction_category_type_id` AND `AttractionCategoryType`.`slug` = 'tourism') WHERE 'HOGE'='HOGE' AND `AttractionCategory`.`attraction_id` = 10604 AND coalesce(`AttractionCategoryL`.`is_public`, 1) = '1' AND coalesce(`AttractionCategoryM`.`is_public`, 1) = '1' AND coalesce(`AttractionCategoryX`.`is_public`, 1) = '1' ORDER BY `AttractionCategory`.`is_main` desc, `AttractionCategoryL`.`order_by` ASC, `AttractionCategoryM`.`order_by` ASC, `AttractionCategoryX`.`order_by` ASC | 2 | 2 | 1 | maybe slow |
| SELECT `AttractionArea`.*, `AttractionAreaL`.`name` AS `AttractionAreaLName`, `AttractionAreaM`.`name` AS `AttractionAreaMName`, `AttractionAreaL`.*, `AttractionAreaM`.* FROM `niigata`.`attraction_area` AS `AttractionArea` LEFT JOIN `niigata`.`attraction` AS `Attraction` ON (`AttractionArea`.`attraction_id` = `Attraction`.`id`) LEFT JOIN `niigata`.`attraction_area_l` AS `AttractionAreaL` ON (`AttractionArea`.`attraction_area_l_id` = `AttractionAreaL`.`id`) LEFT JOIN `niigata`.`attraction_area_m` AS `AttractionAreaM` ON (`AttractionArea`.`attraction_area_m_id` = `AttractionAreaM`.`id`) WHERE 'HOGE'='HOGE' AND `AttractionArea`.`attraction_id` = 10604 AND `AttractionAreaL`.`is_public` = '1' AND coalesce(`AttractionAreaM`.`is_public`, 1) = '1' ORDER BY `AttractionAreaL`.`order_by` ASC, `AttractionAreaM`.`order_by` ASC | 1 | 1 | 0 | |
| SELECT `AttractionTheme`.*, `AttractionThemeL`.`name` AS `AttractionThemeLName`, `AttractionThemeL`.*, `AttractionThemeM`.* FROM `niigata`.`attraction_theme` AS `AttractionTheme` LEFT JOIN `niigata`.`attraction` AS `Attraction` ON (`AttractionTheme`.`attraction_id` = `Attraction`.`id`) LEFT JOIN `niigata`.`attraction_theme_l` AS `AttractionThemeL` ON (`AttractionTheme`.`attraction_theme_l_id` = `AttractionThemeL`.`id`) LEFT JOIN `niigata`.`attraction_theme_m` AS `AttractionThemeM` ON (`AttractionTheme`.`attraction_theme_m_id` = `AttractionThemeM`.`id`) WHERE 'HOGE'='HOGE' AND `AttractionTheme`.`attraction_id` = 10604 AND `AttractionThemeL`.`is_public` = '1' AND (`AttractionThemeL`.`view_to` is null or date_format(`AttractionThemeL`.`view_to`, '%Y%m%d') >= date_format(now(), '%Y%m%d')) ORDER BY `AttractionThemeL`.`order_by` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `AttractionTag`.*, `AttractionTagL`.`name` AS `AttractionTagLName`, `AttractionTagL`.* FROM `niigata`.`attraction_tag` AS `AttractionTag` LEFT JOIN `niigata`.`attraction` AS `Attraction` ON (`AttractionTag`.`attraction_id` = `Attraction`.`id`) LEFT JOIN `niigata`.`attraction_tag_l` AS `AttractionTagL` ON (`AttractionTag`.`attraction_tag_l_id` = `AttractionTagL`.`id`) WHERE 'HOGE'='HOGE' AND `AttractionTag`.`attraction_id` = 10604 AND `AttractionTagL`.`is_public` = '1' ORDER BY `AttractionTag`.`order_by` ASC, `AttractionTagL`.`order_by` ASC | 0 | 0 | 0 | |
| SELECT `Attraction`.*, `MainAttractionCategoryL`.*, `Attraction`.`id` FROM `niigata`.`attraction` AS `Attraction` LEFT JOIN `niigata`.`user` AS `User` ON (`Attraction`.`user_id` = `User`.`id`) LEFT JOIN `niigata`.`prefecture` AS `Prefecture` ON (`Attraction`.`prefecture_id` = `Prefecture`.`id`) LEFT JOIN `niigata`.`city_l` AS `CityL` ON (`Attraction`.`city_l_id` = `CityL`.`id`) LEFT JOIN `niigata`.`attraction_relationship` AS `AttractionRelationship` ON (`Attraction`.`id` = `AttractionRelationship`.`attraction_id`) inner JOIN `niigata`.`attraction_category` AS `MainAttractionCategory` ON (`MainAttractionCategory`.`attraction_id` = `Attraction`.`id` AND `MainAttractionCategory`.`is_main` = 1) inner JOIN `niigata`.`attraction_category_l` AS `MainAttractionCategoryL` ON (`MainAttractionCategoryL`.`id` = `MainAttractionCategory`.`attraction_category_l_id` AND `MainAttractionCategoryL`.`slug` not in('course', 'itineraries')) inner JOIN `niigata`.`attraction_category_type` AS `MainAttractionCategoryType` ON (`MainAttractionCategoryL`.`attraction_category_type_id` = `MainAttractionCategoryType`.`id` AND `MainAttractionCategoryType`.`slug` = 'tourism') inner JOIN (select attraction_id, personal from access_log where 1=1 and article = 'attraction' and attraction_id != 10604 group by attraction_id, personal) AS `AccessLogHisTgt` inner JOIN (select attraction_id, personal from access_log where 1=1 and article = 'attraction' and attraction_id = 10604 group by attraction_id, personal) AS `AccessLogHis` WHERE `AccessLogHisTgt`.`personal` = `AccessLogHis`.`personal` AND `AccessLogHisTgt`.`attraction_id` = `Attraction`.`id` AND `Attraction`.`is_public` = '1' GROUP BY `Attraction`.`id` ORDER BY count(*) desc, `Attraction`.`modified` desc LIMIT 20 | 20 | 20 | 411 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `niigata`.`attraction_category` AS `AttractionCategory` LEFT JOIN `niigata`.`attraction` AS `Attraction` ON (`AttractionCategory`.`attraction_id` = `Attraction`.`id`) LEFT JOIN `niigata`.`attraction_category_l` AS `AttractionCategoryL` ON (`AttractionCategory`.`attraction_category_l_id` = `AttractionCategoryL`.`id`) LEFT JOIN `niigata`.`attraction_category_m` AS `AttractionCategoryM` ON (`AttractionCategory`.`attraction_category_m_id` = `AttractionCategoryM`.`id`) LEFT JOIN `niigata`.`attraction_category_x` AS `AttractionCategoryX` ON (`AttractionCategory`.`attraction_category_x_id` = `AttractionCategoryX`.`id`) WHERE `AttractionCategory`.`attraction_id` = 10604 AND `AttractionCategoryL`.`slug` = 'event' AND coalesce(`AttractionCategoryL`.`is_public`, 1) = '1' | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `niigata`.`attraction_category` AS `AttractionCategory` LEFT JOIN `niigata`.`attraction` AS `Attraction` ON (`AttractionCategory`.`attraction_id` = `Attraction`.`id`) LEFT JOIN `niigata`.`attraction_category_l` AS `AttractionCategoryL` ON (`AttractionCategory`.`attraction_category_l_id` = `AttractionCategoryL`.`id`) LEFT JOIN `niigata`.`attraction_category_m` AS `AttractionCategoryM` ON (`AttractionCategory`.`attraction_category_m_id` = `AttractionCategoryM`.`id`) LEFT JOIN `niigata`.`attraction_category_x` AS `AttractionCategoryX` ON (`AttractionCategory`.`attraction_category_x_id` = `AttractionCategoryX`.`id`) WHERE `AttractionCategory`.`attraction_id` = 10604 AND `AttractionCategoryL`.`slug` = 'experience' AND coalesce(`AttractionCategoryL`.`is_public`, 1) = '1' | 1 | 1 | 0 | |
| SELECT `AttractionTopic`.* FROM `niigata`.`attraction_topic` AS `AttractionTopic` LEFT JOIN `niigata`.`attraction` AS `Attraction` ON (`AttractionTopic`.`attraction_id` = `Attraction`.`id`) WHERE 1=1 AND `AttractionTopic`.`attraction_id` = 10604 AND `AttractionTopic`.`is_public` = '1' AND (`AttractionTopic`.`view_to` is null or date_format(`AttractionTopic`.`view_to`, '%Y%m%d') >= date_format(now(), '%Y%m%d')) ORDER BY `AttractionTopic`.`order_by` ASC, `AttractionTopic`.`id` ASC | 0 | 0 | 0 | |
| SELECT `AttractionSeason`.*, `AttractionCategoryM`.* FROM `niigata`.`attraction_season` AS `AttractionSeason` LEFT JOIN `niigata`.`attraction` AS `Attraction` ON (`AttractionSeason`.`attraction_id` = `Attraction`.`id`) LEFT JOIN `niigata`.`attraction_category_m` AS `AttractionCategoryM` ON (`AttractionSeason`.`attraction_category_m_id` = `AttractionCategoryM`.`id`) LEFT JOIN `niigata`.`attraction_category` AS `AttractionCategory` ON (`AttractionCategory`.`attraction_id` = `Attraction`.`id` AND `AttractionCategory`.`attraction_category_m_id` = `AttractionSeason`.`attraction_category_m_id`) WHERE `AttractionSeason`.`attraction_id` = 10604 ORDER BY `AttractionCategoryM`.`order_by` asc, `AttractionSeason`.`modified` desc, `AttractionSeason`.`id` ASC | 1 | 1 | 1 | |
| SELECT `Blog`.*, `BlogType`.`slug`, `FirstBlogImage`.*, `Blog`.`id` FROM `niigata`.`blog` AS `Blog` LEFT JOIN `niigata`.`blog_type` AS `BlogType` ON (`Blog`.`blog_type_id` = `BlogType`.`id`) LEFT JOIN `niigata`.`blog_image` AS `FirstBlogImage` ON (`FirstBlogImage`.`blog_id` = `Blog`.`id`) inner JOIN (select blog_id, personal from blog_access_log where 1=1 group by blog_id, personal) AS `AccessLogHisTgt` inner JOIN (select attraction_id, personal from access_log where 1=1 and article = 'attraction' and attraction_id = 10604 group by attraction_id, personal) AS `AccessLogHis` WHERE `AccessLogHisTgt`.`personal` = `AccessLogHis`.`personal` AND `AccessLogHisTgt`.`blog_id` = `Blog`.`id` AND `Blog`.`is_public` = '1' GROUP BY `Blog`.`id` ORDER BY count(*) desc, `Blog`.`modified` desc LIMIT 20 | 20 | 20 | 49 | maybe slow |
| SELECT `Attraction`.*, `MainAttractionCategoryL`.* FROM `niigata`.`event_spot` AS `EventSpot` LEFT JOIN `niigata`.`attraction` AS `Event` ON (`EventSpot`.`attraction_id` = `Event`.`id`) LEFT JOIN `niigata`.`attraction` AS `Spot` ON (`EventSpot`.`spot_attraction_id` = `Spot`.`id`) left JOIN `niigata`.`attraction` AS `Attraction` ON (`Attraction`.`id` = `EventSpot`.`attraction_id`) inner JOIN `niigata`.`attraction_category` AS `MainAttractionCategory` ON (`MainAttractionCategory`.`attraction_id` = `Attraction`.`id` AND `MainAttractionCategory`.`is_main` = 1) inner JOIN `niigata`.`attraction_category_l` AS `MainAttractionCategoryL` ON (`MainAttractionCategoryL`.`id` = `MainAttractionCategory`.`attraction_category_l_id`) WHERE `EventSpot`.`spot_attraction_id` = 10604 AND `Attraction`.`is_public` = '1' AND (`Attraction`.`view_from` is null or date_format(`Attraction`.`view_from`, '%Y%m%d') <= date_format(now(), '%Y%m%d')) AND (`Attraction`.`view_to` is null or date_format(`Attraction`.`view_to`, '%Y%m%d') >= date_format(now(), '%Y%m%d')) | 0 | 0 | 1 | maybe slow |
| SELECT `AttractionPickupL`.*, `AttractionPickupL`.`id` FROM `niigata`.`attraction_pickup_l` AS `AttractionPickupL` inner JOIN `niigata`.`attraction_pickup` AS `AttractionPickup` ON (`AttractionPickupL`.`id` = `AttractionPickup`.`attraction_pickup_l_id`) WHERE `AttractionPickup`.`attraction_id` = 10604 AND `AttractionPickupL`.`lang_slug` = 'ja' AND `AttractionPickupL`.`is_public` = '1' AND (`AttractionPickupL`.`view_from` is null or date_format(`AttractionPickupL`.`view_from`, '%Y%m%d') <= date_format(now(), '%Y%m%d')) AND (`AttractionPickupL`.`view_to` is null or date_format(`AttractionPickupL`.`view_to`, '%Y%m%d') >= date_format(now(), '%Y%m%d')) | 0 | 0 | 0 | |
| SELECT `Feature`.*, `Feature`.`id` FROM `niigata`.`feature` AS `Feature` LEFT JOIN `niigata`.`feature_type` AS `FeatureType` ON (`Feature`.`feature_type_id` = `FeatureType`.`id`) inner JOIN `niigata`.`feature_paragraph` AS `FeatureParagraph` ON (`Feature`.`id` = `FeatureParagraph`.`feature_id`) inner JOIN `niigata`.`feature_paragraph_detail` AS `FeatureParagraphDetail` ON (`FeatureParagraph`.`id` = `FeatureParagraphDetail`.`feature_paragraph_id`) WHERE `FeatureParagraph`.`feature_paragraph_type_id` IN (1, 4) AND `FeatureParagraphDetail`.`reference_attraction` = '10604' AND `Feature`.`is_public` = '1' AND (`Feature`.`view_from` is null or date_format(`Feature`.`view_from`, '%Y%m%d') <= date_format(now(), '%Y%m%d')) AND (`Feature`.`view_to` is null or date_format(`Feature`.`view_to`, '%Y%m%d') >= date_format(now(), '%Y%m%d')) | 0 | 0 | 1 | maybe slow |
| SELECT DISTINCT Attraction.id, Attraction.name FROM `niigata`.`course_spot` AS `CourseSpot` LEFT JOIN `niigata`.`attraction` AS `Attraction` ON (`CourseSpot`.`attraction_id` = `Attraction`.`id`) LEFT JOIN `niigata`.`attraction` AS `Attraction2` ON (`CourseSpot`.`reference_attraction` = `Attraction2`.`id`) WHERE `CourseSpot`.`reference_attraction` = 10604 AND `Attraction`.`is_public` = '1' AND (`Attraction`.`view_from` is null or date_format(`Attraction`.`view_from`, '%Y%m%d') <= date_format(now(), '%Y%m%d')) AND (`Attraction`.`view_to` is null or date_format(`Attraction`.`view_to`, '%Y%m%d') >= date_format(now(), '%Y%m%d')) | 0 | 0 | 1 | maybe slow |
| SELECT `AsoviewArea`.* FROM `niigata`.`attraction_area` AS `AttractionArea` inner JOIN `niigata`.`attraction_area_m` AS `AttractionAreaM` ON (`AttractionAreaM`.`id` = `AttractionArea`.`attraction_area_m_id`) inner JOIN `niigata`.`asoview_area` AS `AsoviewArea` ON (`AsoviewArea`.`attraction_area_m_id` = `AttractionAreaM`.`id`) WHERE `AttractionArea`.`attraction_id` = 10604 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `TabikuraArea`.* FROM `niigata`.`attraction_area` AS `AttractionArea` inner JOIN `niigata`.`attraction_area_m` AS `AttractionAreaM` ON (`AttractionAreaM`.`id` = `AttractionArea`.`attraction_area_m_id`) inner JOIN `niigata`.`tabikura_area` AS `TabikuraArea` ON (`TabikuraArea`.`attraction_area_m_id` = `AttractionAreaM`.`id`) WHERE `AttractionArea`.`attraction_id` = 10604 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `AttractionExperienceLImage`.`id`, `AttractionExperienceLImage`.`attraction_experience_l_id`, `AttractionExperienceLImage`.`image`, `AttractionExperienceLImage`.`caption`, `AttractionExperienceLImage`.`url`, `AttractionExperienceLImage`.`is_view_blank_window`, `AttractionExperienceLImage`.`order_by`, `AttractionExperienceLImage`.`is_public`, `AttractionExperienceLImage`.`view_from`, `AttractionExperienceLImage`.`view_to`, `AttractionExperienceLImage`.`created`, `AttractionExperienceLImage`.`modified` FROM `niigata`.`attraction_experience_l_image` AS `AttractionExperienceLImage` inner JOIN `niigata`.`attraction_experience_l` AS `AttractionExperienceL` ON (`AttractionExperienceL`.`id` = `AttractionExperienceLImage`.`attraction_experience_l_id` AND ((`AttractionExperienceL`.`is_public` = '1') AND ((`AttractionExperienceL`.`view_from` is null or date_format(`AttractionExperienceL`.`view_from`, '%Y%m%d') <= date_format(now(), '%Y%m%d'))) AND ((`AttractionExperienceL`.`view_to` is null or date_format(`AttractionExperienceL`.`view_to`, '%Y%m%d') >= date_format(now(), '%Y%m%d'))))) inner JOIN `niigata`.`attraction_experience` AS `AttractionExperience` ON (`AttractionExperience`.`attraction_experience_l_id` = `AttractionExperienceL`.`id` AND `AttractionExperience`.`attraction_id` = '10604') WHERE ((`AttractionExperienceLImage`.`is_public` = '1') AND ((`AttractionExperienceLImage`.`view_from` is null or date_format(`AttractionExperienceLImage`.`view_from`, '%Y%m%d') <= date_format(now(), '%Y%m%d'))) AND ((`AttractionExperienceLImage`.`view_to` is null or date_format(`AttractionExperienceLImage`.`view_to`, '%Y%m%d') >= date_format(now(), '%Y%m%d')))) ORDER BY `AttractionExperienceL`.`order_by` ASC, `AttractionExperienceL`.`id` ASC, `AttractionExperienceLImage`.`order_by` ASC, `AttractionExperienceLImage`.`id` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `AttractionIconL`.`id`, `AttractionIconL`.`name`, `AttractionIconL`.`is_shown_all_off_icon`, `AttractionIconL`.`is_public`, `AttractionIconL`.`view_from`, `AttractionIconL`.`view_to`, `AttractionIconL`.`order_by`, `AttractionIconL`.`created`, `AttractionIconL`.`modified` FROM `niigata`.`attraction_icon_l` AS `AttractionIconL` WHERE coalesce(`AttractionIconL`.`is_public`, 1) = '1' AND (`AttractionIconL`.`view_from` is null or date_format(`AttractionIconL`.`view_from`, '%Y%m%d') <= date_format(now(), '%Y%m%d')) AND (`AttractionIconL`.`view_to` is null or date_format(`AttractionIconL`.`view_to`, '%Y%m%d') >= date_format(now(), '%Y%m%d')) ORDER BY `AttractionIconL`.`order_by` ASC | 0 | 0 | 0 | |
| SELECT `AttractionImage`.* FROM `niigata`.`attraction_image` AS `AttractionImage` WHERE `AttractionImage`.`attraction_id` = 10246 ORDER BY `AttractionImage`.`order_by` ASC, `AttractionImage`.`id` ASC LIMIT 10 | 10 | 10 | 0 | |
| SELECT `AttractionImage`.* FROM `niigata`.`attraction_image` AS `AttractionImage` WHERE `AttractionImage`.`attraction_id` = 10584 ORDER BY `AttractionImage`.`order_by` ASC, `AttractionImage`.`id` ASC LIMIT 10 | 10 | 10 | 0 | |
| SELECT `AttractionImage`.* FROM `niigata`.`attraction_image` AS `AttractionImage` WHERE `AttractionImage`.`attraction_id` = 5869 ORDER BY `AttractionImage`.`order_by` ASC, `AttractionImage`.`id` ASC LIMIT 10 | 10 | 10 | 0 | |
| SELECT `AttractionImage`.* FROM `niigata`.`attraction_image` AS `AttractionImage` WHERE `AttractionImage`.`attraction_id` = 10734 ORDER BY `AttractionImage`.`order_by` ASC, `AttractionImage`.`id` ASC LIMIT 10 | 1 | 1 | 0 | |
| SELECT `AttractionImage`.* FROM `niigata`.`attraction_image` AS `AttractionImage` WHERE `AttractionImage`.`attraction_id` = 44884 ORDER BY `AttractionImage`.`order_by` ASC, `AttractionImage`.`id` ASC LIMIT 10 | 4 | 4 | 0 | |
| SELECT `AttractionImage`.* FROM `niigata`.`attraction_image` AS `AttractionImage` WHERE `AttractionImage`.`attraction_id` = 10600 ORDER BY `AttractionImage`.`order_by` ASC, `AttractionImage`.`id` ASC LIMIT 10 | 10 | 10 | 0 | |
| SELECT `AttractionImage`.* FROM `niigata`.`attraction_image` AS `AttractionImage` WHERE `AttractionImage`.`attraction_id` = 10597 ORDER BY `AttractionImage`.`order_by` ASC, `AttractionImage`.`id` ASC LIMIT 10 | 10 | 10 | 0 | |
| SELECT `AttractionImage`.* FROM `niigata`.`attraction_image` AS `AttractionImage` WHERE `AttractionImage`.`attraction_id` = 7210 ORDER BY `AttractionImage`.`order_by` ASC, `AttractionImage`.`id` ASC LIMIT 10 | 5 | 5 | 0 | |
| SELECT `AttractionImage`.* FROM `niigata`.`attraction_image` AS `AttractionImage` WHERE `AttractionImage`.`attraction_id` = 7316 ORDER BY `AttractionImage`.`order_by` ASC, `AttractionImage`.`id` ASC LIMIT 10 | 10 | 10 | 0 | |
| SELECT `AttractionImage`.* FROM `niigata`.`attraction_image` AS `AttractionImage` WHERE `AttractionImage`.`attraction_id` = 13766 ORDER BY `AttractionImage`.`order_by` ASC, `AttractionImage`.`id` ASC LIMIT 10 | 10 | 10 | 0 | |
| SELECT `AttractionImage`.* FROM `niigata`.`attraction_image` AS `AttractionImage` WHERE `AttractionImage`.`attraction_id` = 10747 ORDER BY `AttractionImage`.`order_by` ASC, `AttractionImage`.`id` ASC LIMIT 10 | 1 | 1 | 0 | |
| SELECT `AttractionImage`.* FROM `niigata`.`attraction_image` AS `AttractionImage` WHERE `AttractionImage`.`attraction_id` = 10826 ORDER BY `AttractionImage`.`order_by` ASC, `AttractionImage`.`id` ASC LIMIT 10 | 7 | 7 | 0 | |
| SELECT `AttractionImage`.* FROM `niigata`.`attraction_image` AS `AttractionImage` WHERE `AttractionImage`.`attraction_id` = 9687 ORDER BY `AttractionImage`.`order_by` ASC, `AttractionImage`.`id` ASC LIMIT 10 | 2 | 2 | 0 | |
| SELECT `AttractionImage`.* FROM `niigata`.`attraction_image` AS `AttractionImage` WHERE `AttractionImage`.`attraction_id` = 42987 ORDER BY `AttractionImage`.`order_by` ASC, `AttractionImage`.`id` ASC LIMIT 10 | 10 | 10 | 0 | |
| SELECT `AttractionImage`.* FROM `niigata`.`attraction_image` AS `AttractionImage` WHERE `AttractionImage`.`attraction_id` = 10069 ORDER BY `AttractionImage`.`order_by` ASC, `AttractionImage`.`id` ASC LIMIT 10 | 10 | 10 | 0 | |
| SELECT `AttractionImage`.* FROM `niigata`.`attraction_image` AS `AttractionImage` WHERE `AttractionImage`.`attraction_id` = 44932 ORDER BY `AttractionImage`.`order_by` ASC, `AttractionImage`.`id` ASC LIMIT 10 | 7 | 7 | 0 | |
| SELECT `AttractionImage`.* FROM `niigata`.`attraction_image` AS `AttractionImage` WHERE `AttractionImage`.`attraction_id` = 7306 ORDER BY `AttractionImage`.`order_by` ASC, `AttractionImage`.`id` ASC LIMIT 10 | 10 | 10 | 0 | |
| SELECT `AttractionImage`.* FROM `niigata`.`attraction_image` AS `AttractionImage` WHERE `AttractionImage`.`attraction_id` = 41542 ORDER BY `AttractionImage`.`order_by` ASC, `AttractionImage`.`id` ASC LIMIT 10 | 4 | 4 | 0 | |
| SELECT `AttractionImage`.* FROM `niigata`.`attraction_image` AS `AttractionImage` WHERE `AttractionImage`.`attraction_id` = 2332 ORDER BY `AttractionImage`.`order_by` ASC, `AttractionImage`.`id` ASC LIMIT 10 | 10 | 10 | 0 | |
| SELECT `AttractionImage`.* FROM `niigata`.`attraction_image` AS `AttractionImage` WHERE `AttractionImage`.`attraction_id` = 1873 ORDER BY `AttractionImage`.`order_by` ASC, `AttractionImage`.`id` ASC LIMIT 10 | 2 | 2 | 0 | |
