(default) 124 queries took 3983 ms
	

		
Nr
Query
Error
Affected
Num. rows
Took (ms)
	
	

	
1
SELECT `Writer`.`id`, `Writer`.`username`, `Writer`.`password`, `Writer`.`name`, `Writer`.`name_kana`, `Writer`.`nickname`, `Writer`.`phone`, `Writer`.`profile`, `Writer`.`profile_image`, `Writer`.`postal_code`, `Writer`.`prefecture_id`, `Writer`.`address2`, `Writer`.`address3`, `Writer`.`person_in_charge1`, `Writer`.`person_in_charge2`, `Writer`.`contact`, `Writer`.`department`, `Writer`.`email1`, `Writer`.`email2`, `Writer`.`homepage`, `Writer`.`contractor_name`, `Writer`.`contract_plan_type`, `Writer`.`company_logo`, `Writer`.`fan_program_note`, `Writer`.`last_login_date`, `Writer`.`type`, `Writer`.`external_link`, `Writer`.`tags`, `Writer`.`main_visual`, `Writer`.`contact_email`, `Writer`.`agency_code`, `Writer`.`initial_fee`, `Writer`.`monthly_fee_1`, `Writer`.`monthly_fee_2`, `Writer`.`directory`, `Writer`.`display_matching_personal_information`, `Writer`.`display_top`, `Writer`.`status`, `Writer`.`created`, `Writer`.`modified` FROM `repohappy_web`.`writers` AS `Writer`   WHERE NOT (COALESCE(`Writer`.`status`, 0) = 'delete') AND `Writer`.`type` = 'fan' AND `Writer`.`id` = 46    LIMIT 1
1
1
1
2
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`fans` AS `Fan` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Fan`.`user_id` = `User`.`id`)  WHERE `Fan`.`address` LIKE '%/46'
1
1
3
3
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`articles` AS `Article` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Article`.`external_id` = `Shop`.`id` AND model = 'shop') LEFT JOIN `repohappy_web`.`shops` AS `Owners` ON (`Article`.`external_id` = `Owners`.`id` AND model = 'shop') LEFT JOIN `repohappy_web`.`writers` AS `Writer` ON (`Article`.`external_id` = `Writer`.`id` AND model = 'writer') LEFT JOIN `repohappy_web`.`writers` AS `Author` ON (`Article`.`writer_id` = `Author`.`id`) LEFT JOIN `repohappy_web`.`shops` AS `OwnersAuthor` ON (`Article`.`external_id` = `OwnersAuthor`.`id` AND model = 'shop') LEFT JOIN `repohappy_web`.`writers` AS `FanAuthor` ON (`Article`.`external_id` = `FanAuthor`.`id` AND model = 'writer')  WHERE `Article`.`status` = 'published' AND `Article`.`external_id` = 46 AND ((`Article`.`type` IN ('press', 'fan'))  AND  (`Article`.`model` = 'writer'))  GROUP BY `Article`.`id`
18
18
1
4
SELECT `Article`.`id`, `Article`.`title`, `Article`.`main_image`, `Article`.`created`, `Article`.`modified`, `Article`.`category_id`, `Article`.`model`, `Article`.`type`, `Article`.`fan_type`, `Article`.`approval_date`, `Article`.`published_date`, `Writer`.`id`, `Writer`.`username`, `Writer`.`nickname`, `Writer`.`name`, `Writer`.`prefecture_id`, `Writer`.`address2`, `Author`.`profile_image`, `Author`.`nickname`, `FanAuthor`.`directory`, `Shop`.`id`, `Shop`.`city_id`, `Shop`.`shop_category`, `Shop`.`shop_name`, `Shop`.`shop_area`, `Shop`.`shop_area2`, `Shop`.`article_thumbnail`, `Shop`.`state`, `Shop`.`status`, (SELECT name FROM areas WHERE Shop.shop_area = areas.id) as area, (18) AS  `Article__total_count` FROM `repohappy_web`.`articles` AS `Article` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Article`.`external_id` = `Shop`.`id` AND model = 'shop') LEFT JOIN `repohappy_web`.`shops` AS `Owners` ON (`Article`.`external_id` = `Owners`.`id` AND model = 'shop') LEFT JOIN `repohappy_web`.`writers` AS `Writer` ON (`Article`.`external_id` = `Writer`.`id` AND model = 'writer') LEFT JOIN `repohappy_web`.`writers` AS `Author` ON (`Article`.`writer_id` = `Author`.`id`) LEFT JOIN `repohappy_web`.`shops` AS `OwnersAuthor` ON (`Article`.`external_id` = `OwnersAuthor`.`id` AND model = 'shop') LEFT JOIN `repohappy_web`.`writers` AS `FanAuthor` ON (`Article`.`external_id` = `FanAuthor`.`id` AND model = 'writer')  WHERE `Article`.`status` = 'published' AND `Article`.`external_id` = 46 AND ((`Article`.`type` IN ('press', 'fan'))  AND  (`Article`.`model` = 'writer'))  GROUP BY `Article`.`id`  ORDER BY `Article`.`page_view_count` desc  LIMIT 10
10
10
1
5
SELECT `ArticleItem`.`id`, `ArticleItem`.`article_id`, `ArticleItem`.`title`, `ArticleItem`.`text`, `ArticleItem`.`media`, `ArticleItem`.`type`, `ArticleItem`.`sort`, `ArticleItem`.`created`, `ArticleItem`.`modified` FROM `repohappy_web`.`article_items` AS `ArticleItem`   WHERE `ArticleItem`.`article_id` IN (589, 717, 419, 690, 471, 418, 746, 492, 776, 807)   ORDER BY `ArticleItem`.`sort` ASC
160
160
1
6
SELECT `ArticleTag`.`id`, `ArticleTag`.`article_id`, `ArticleTag`.`tag_id`, `ArticleTag`.`created`, `ArticleTag`.`modified` FROM `repohappy_web`.`article_tags` AS `ArticleTag`   WHERE `ArticleTag`.`article_id` IN (589, 717, 419, 690, 471, 418, 746, 492, 776, 807)
45
45
1
7
SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite`   WHERE `Favorite`.`external_id` IN (589, 717, 419, 690, 471, 418, 746, 492, 776, 807)
142
142
1
8
SELECT `Comment`.`id`, `Comment`.`article_id`, `Comment`.`user_id`, `Comment`.`icon`, `Comment`.`comment`, `Comment`.`status`, `Comment`.`created`, `Comment`.`modified` FROM `repohappy_web`.`comments` AS `Comment`   WHERE `Comment`.`article_id` IN (589, 717, 419, 690, 471, 418, 746, 492, 776, 807)
0
0
0
9
SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite`   WHERE `Favorite`.`external_id` = 589 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL    LIMIT 1
0
0
0
10
SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS  `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS  `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/589' AND `Interest`.`cookie` = ''    LIMIT 1
0
0
1
11
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`)  WHERE `Favorite`.`external_id` = 589 AND `Favorite`.`model` = 'article'
1
1
1
12
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/589'
1
1
0
13
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment`   WHERE `Comment`.`article_id` = 589 AND NOT (`Comment`.`status` = 'delete')
1
1
0
14
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint`   WHERE `UserTagPoint`.`entity_id` = '589' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')
1
1
27
15
SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite`   WHERE `Favorite`.`external_id` = 717 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL    LIMIT 1
0
0
0
16
SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS  `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS  `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/717' AND `Interest`.`cookie` = ''    LIMIT 1
0
0
1
17
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`)  WHERE `Favorite`.`external_id` = 717 AND `Favorite`.`model` = 'article'
1
1
1
18
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/717'
1
1
0
19
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment`   WHERE `Comment`.`article_id` = 717 AND NOT (`Comment`.`status` = 'delete')
1
1
0
20
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint`   WHERE `UserTagPoint`.`entity_id` = '717' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')
1
1
7
21
SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite`   WHERE `Favorite`.`external_id` = 419 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL    LIMIT 1
0
0
0
22
SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS  `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS  `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/419' AND `Interest`.`cookie` = ''    LIMIT 1
0
0
1
23
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`)  WHERE `Favorite`.`external_id` = 419 AND `Favorite`.`model` = 'article'
1
1
1
24
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/419'
1
1
0
25
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment`   WHERE `Comment`.`article_id` = 419 AND NOT (`Comment`.`status` = 'delete')
1
1
0
26
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint`   WHERE `UserTagPoint`.`entity_id` = '419' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')
1
1
8
27
SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite`   WHERE `Favorite`.`external_id` = 690 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL    LIMIT 1
0
0
0
28
SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS  `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS  `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/690' AND `Interest`.`cookie` = ''    LIMIT 1
0
0
1
29
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`)  WHERE `Favorite`.`external_id` = 690 AND `Favorite`.`model` = 'article'
1
1
1
30
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/690'
1
1
0
31
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment`   WHERE `Comment`.`article_id` = 690 AND NOT (`Comment`.`status` = 'delete')
1
1
0
32
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint`   WHERE `UserTagPoint`.`entity_id` = '690' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')
1
1
5
33
SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite`   WHERE `Favorite`.`external_id` = 471 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL    LIMIT 1
0
0
0
34
SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS  `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS  `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/471' AND `Interest`.`cookie` = ''    LIMIT 1
0
0
1
35
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`)  WHERE `Favorite`.`external_id` = 471 AND `Favorite`.`model` = 'article'
1
1
0
36
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/471'
1
1
0
37
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment`   WHERE `Comment`.`article_id` = 471 AND NOT (`Comment`.`status` = 'delete')
1
1
0
38
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint`   WHERE `UserTagPoint`.`entity_id` = '471' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')
1
1
3
39
SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite`   WHERE `Favorite`.`external_id` = 418 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL    LIMIT 1
0
0
0
40
SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS  `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS  `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/418' AND `Interest`.`cookie` = ''    LIMIT 1
0
0
1
41
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`)  WHERE `Favorite`.`external_id` = 418 AND `Favorite`.`model` = 'article'
1
1
1
42
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/418'
1
1
0
43
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment`   WHERE `Comment`.`article_id` = 418 AND NOT (`Comment`.`status` = 'delete')
1
1
0
44
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint`   WHERE `UserTagPoint`.`entity_id` = '418' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')
1
1
4
45
SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite`   WHERE `Favorite`.`external_id` = 746 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL    LIMIT 1
0
0
0
46
SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS  `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS  `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/746' AND `Interest`.`cookie` = ''    LIMIT 1
0
0
1
47
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`)  WHERE `Favorite`.`external_id` = 746 AND `Favorite`.`model` = 'article'
1
1
1
48
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/746'
1
1
0
49
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment`   WHERE `Comment`.`article_id` = 746 AND NOT (`Comment`.`status` = 'delete')
1
1
0
50
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint`   WHERE `UserTagPoint`.`entity_id` = '746' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')
1
1
3
51
SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite`   WHERE `Favorite`.`external_id` = 492 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL    LIMIT 1
0
0
0
52
SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS  `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS  `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/492' AND `Interest`.`cookie` = ''    LIMIT 1
0
0
1
53
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`)  WHERE `Favorite`.`external_id` = 492 AND `Favorite`.`model` = 'article'
1
1
0
54
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/492'
1
1
0
55
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment`   WHERE `Comment`.`article_id` = 492 AND NOT (`Comment`.`status` = 'delete')
1
1
0
56
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint`   WHERE `UserTagPoint`.`entity_id` = '492' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')
1
1
3
57
SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite`   WHERE `Favorite`.`external_id` = 776 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL    LIMIT 1
0
0
0
58
SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS  `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS  `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/776' AND `Interest`.`cookie` = ''    LIMIT 1
0
0
1
59
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`)  WHERE `Favorite`.`external_id` = 776 AND `Favorite`.`model` = 'article'
1
1
0
60
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/776'
1
1
0
61
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment`   WHERE `Comment`.`article_id` = 776 AND NOT (`Comment`.`status` = 'delete')
1
1
0
62
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint`   WHERE `UserTagPoint`.`entity_id` = '776' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')
1
1
4
63
SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite`   WHERE `Favorite`.`external_id` = 807 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL    LIMIT 1
0
0
0
64
SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS  `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS  `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/807' AND `Interest`.`cookie` = ''    LIMIT 1
0
0
1
65
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`)  WHERE `Favorite`.`external_id` = 807 AND `Favorite`.`model` = 'article'
1
1
0
66
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/807'
1
1
2
67
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment`   WHERE `Comment`.`article_id` = 807 AND NOT (`Comment`.`status` = 'delete')
1
1
9
68
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint`   WHERE `UserTagPoint`.`entity_id` = '807' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')
1
1
3
69
SELECT `Article`.`id`, `Article`.`title` FROM `repohappy_web`.`articles` AS `Article`   WHERE `Article`.`external_id` = 46 AND `Article`.`Type` IN ('press', 'fan')
20
20
0
70
SELECT `ArticleTag`.`id`, `ArticleTag`.`article_id`, `ArticleTag`.`tag_id`, `ArticleTag`.`created`, `ArticleTag`.`modified`, `Tag`.`id`, `Tag`.`external_id`, `Tag`.`name`, `Tag`.`type`, `Tag`.`level`, `Tag`.`status`, `Tag`.`created`, `Tag`.`modified` FROM `repohappy_web`.`article_tags` AS `ArticleTag` LEFT JOIN `repohappy_web`.`tags` AS `Tag` ON (`ArticleTag`.`tag_id` = `Tag`.`id`)  WHERE `ArticleTag`.`article_id` IN (415, 416, 417, 418, 419, 471, 492, 505, 589, 664, 690, 717, 726, 746, 774, 776, 807, 870, 909, 964)  GROUP BY `ArticleTag`.`article_id`
19
19
1
71
SELECT `Tag`.`id`, `Tag`.`name` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`UserTagPoint`.`user_id` = `User`.`id`) LEFT JOIN `repohappy_web`.`tags` AS `Tag` ON (`UserTagPoint`.`tag_id` = `Tag`.`id`)  WHERE `UserTagPoint`.`tag_id` IN (21, 21, 21, 21, 21, NULL, 21, 21, 21, NULL, 20, 21, 21, NULL, 21, 21, 21, NULL, 21) AND `UserTagPoint`.`action` = 'page_view_fan'  GROUP BY `UserTagPoint`.`tag_id`
0
0
0
72
SELECT `Article`.`id`, `Article`.`writer_id`, `Article`.`shop_id`, `Article`.`external_id`, `Article`.`category_id`, `Article`.`title`, `Article`.`main_image`, `Article`.`url`, `Article`.`recommendation`, `Article`.`main_visual`, `Article`.`featured`, `Article`.`fan_type`, `Article`.`type`, `Article`.`model`, `Article`.`keywords1`, `Article`.`keywords2`, `Article`.`status`, `Article`.`display_comment_button`, `Article`.`page_view_count`, `Article`.`interview_date`, `Article`.`approval_date`, `Article`.`published_date`, `Article`.`created`, `Article`.`modified`, (SELECT count(`user_tag_points`.`id`) FROM user_tag_points WHERE `user_tag_points`.`entity_id` = `Article`.`id` AND `user_tag_points`.`action` IN ("page_view_gourmet", "page_view_fan")) AS  `Article__views`, (18) AS  `Article__total_count`, `Shop`.`id`, `Shop`.`login_id`, `Shop`.`password`, `Shop`.`shop_kind`, `Shop`.`shop_category`, `Shop`.`shop_name`, `Shop`.`shop_name_kana`, `Shop`.`shop_tel`, `Shop`.`officer_name`, `Shop`.`officer_name_kana`, `Shop`.`supervisor_name`, `Shop`.`staff_name`, `Shop`.`staff_name_kana`, `Shop`.`staff_tel`, `Shop`.`staff_mail`, `Shop`.`mail2`, `Shop`.`monthly_basic_price`, `Shop`.`monthly_uu_unit_price`, `Shop`.`initial_fee`, `Shop`.`main_visual_1`, `Shop`.`main_visual_2`, `Shop`.`main_visual_3`, `Shop`.`main_visual_4`, `Shop`.`article_thumbnail`, `Shop`.`shop_url`, `Shop`.`external_url`, `Shop`.`postal_code`, `Shop`.`state`, `Shop`.`city_id`, `Shop`.`street`, `Shop`.`shop_open_start`, `Shop`.`shop_open_end`, `Shop`.`shop_area`, `Shop`.`shop_area2`, `Shop`.`offer_total`, `Shop`.`offer_person`, `Shop`.`matching_total`, `Shop`.`agreement_date`, `Shop`.`cancel_date`, `Shop`.`agreement_plan`, `Shop`.`picture1`, `Shop`.`picture1_ext`, `Shop`.`picture2`, `Shop`.`picture2_ext`, `Shop`.`matching_menu`, `Shop`.`is_suspension_service`, `Shop`.`shop_pr1`, `Shop`.`shop_pr2`, `Shop`.`holiday`, `Shop`.`special_gift`, `Shop`.`gift_period`, `Shop`.`agency_code`, `Shop`.`payment_method`, `Shop`.`credit_card_status`, `Shop`.`business_hours`, `Shop`.`average_budget`, `Shop`.`available_days_before_reservation`, `Shop`.`phone`, `Shop`.`seats`, `Shop`.`nearest_station`, `Shop`.`reward`, `Shop`.`miruden`, `Shop`.`promotion_banner_image`, `Shop`.`promotion_banner_url`, `Shop`.`type`, `Shop`.`job_use_flg`, `Shop`.`test`, `Shop`.`token`, `Shop`.`status`, `Shop`.`delete_flg`, `Shop`.`created`, `Shop`.`modified`, `Owners`.`id`, `Owners`.`login_id`, `Owners`.`password`, `Owners`.`shop_kind`, `Owners`.`shop_category`, `Owners`.`shop_name`, `Owners`.`shop_name_kana`, `Owners`.`shop_tel`, `Owners`.`officer_name`, `Owners`.`officer_name_kana`, `Owners`.`supervisor_name`, `Owners`.`staff_name`, `Owners`.`staff_name_kana`, `Owners`.`staff_tel`, `Owners`.`staff_mail`, `Owners`.`mail2`, `Owners`.`monthly_basic_price`, `Owners`.`monthly_uu_unit_price`, `Owners`.`initial_fee`, `Owners`.`main_visual_1`, `Owners`.`main_visual_2`, `Owners`.`main_visual_3`, `Owners`.`main_visual_4`, `Owners`.`article_thumbnail`, `Owners`.`shop_url`, `Owners`.`external_url`, `Owners`.`postal_code`, `Owners`.`state`, `Owners`.`city_id`, `Owners`.`street`, `Owners`.`shop_open_start`, `Owners`.`shop_open_end`, `Owners`.`shop_area`, `Owners`.`shop_area2`, `Owners`.`offer_total`, `Owners`.`offer_person`, `Owners`.`matching_total`, `Owners`.`agreement_date`, `Owners`.`cancel_date`, `Owners`.`agreement_plan`, `Owners`.`picture1`, `Owners`.`picture1_ext`, `Owners`.`picture2`, `Owners`.`picture2_ext`, `Owners`.`matching_menu`, `Owners`.`is_suspension_service`, `Owners`.`shop_pr1`, `Owners`.`shop_pr2`, `Owners`.`holiday`, `Owners`.`special_gift`, `Owners`.`gift_period`, `Owners`.`agency_code`, `Owners`.`payment_method`, `Owners`.`credit_card_status`, `Owners`.`business_hours`, `Owners`.`average_budget`, `Owners`.`available_days_before_reservation`, `Owners`.`phone`, `Owners`.`seats`, `Owners`.`nearest_station`, `Owners`.`reward`, `Owners`.`miruden`, `Owners`.`promotion_banner_image`, `Owners`.`promotion_banner_url`, `Owners`.`type`, `Owners`.`job_use_flg`, `Owners`.`test`, `Owners`.`token`, `Owners`.`status`, `Owners`.`delete_flg`, `Owners`.`created`, `Owners`.`modified`, `Writer`.`id`, `Writer`.`username`, `Writer`.`password`, `Writer`.`name`, `Writer`.`name_kana`, `Writer`.`nickname`, `Writer`.`phone`, `Writer`.`profile`, `Writer`.`profile_image`, `Writer`.`postal_code`, `Writer`.`prefecture_id`, `Writer`.`address2`, `Writer`.`address3`, `Writer`.`person_in_charge1`, `Writer`.`person_in_charge2`, `Writer`.`contact`, `Writer`.`department`, `Writer`.`email1`, `Writer`.`email2`, `Writer`.`homepage`, `Writer`.`contractor_name`, `Writer`.`contract_plan_type`, `Writer`.`company_logo`, `Writer`.`fan_program_note`, `Writer`.`last_login_date`, `Writer`.`type`, `Writer`.`external_link`, `Writer`.`tags`, `Writer`.`main_visual`, `Writer`.`contact_email`, `Writer`.`agency_code`, `Writer`.`initial_fee`, `Writer`.`monthly_fee_1`, `Writer`.`monthly_fee_2`, `Writer`.`directory`, `Writer`.`display_matching_personal_information`, `Writer`.`display_top`, `Writer`.`status`, `Writer`.`created`, `Writer`.`modified`, `Author`.`id`, `Author`.`username`, `Author`.`password`, `Author`.`name`, `Author`.`name_kana`, `Author`.`nickname`, `Author`.`phone`, `Author`.`profile`, `Author`.`profile_image`, `Author`.`postal_code`, `Author`.`prefecture_id`, `Author`.`address2`, `Author`.`address3`, `Author`.`person_in_charge1`, `Author`.`person_in_charge2`, `Author`.`contact`, `Author`.`department`, `Author`.`email1`, `Author`.`email2`, `Author`.`homepage`, `Author`.`contractor_name`, `Author`.`contract_plan_type`, `Author`.`company_logo`, `Author`.`fan_program_note`, `Author`.`last_login_date`, `Author`.`type`, `Author`.`external_link`, `Author`.`tags`, `Author`.`main_visual`, `Author`.`contact_email`, `Author`.`agency_code`, `Author`.`initial_fee`, `Author`.`monthly_fee_1`, `Author`.`monthly_fee_2`, `Author`.`directory`, `Author`.`display_matching_personal_information`, `Author`.`display_top`, `Author`.`status`, `Author`.`created`, `Author`.`modified`, `OwnersAuthor`.`id`, `OwnersAuthor`.`login_id`, `OwnersAuthor`.`password`, `OwnersAuthor`.`shop_kind`, `OwnersAuthor`.`shop_category`, `OwnersAuthor`.`shop_name`, `OwnersAuthor`.`shop_name_kana`, `OwnersAuthor`.`shop_tel`, `OwnersAuthor`.`officer_name`, `OwnersAuthor`.`officer_name_kana`, `OwnersAuthor`.`supervisor_name`, `OwnersAuthor`.`staff_name`, `OwnersAuthor`.`staff_name_kana`, `OwnersAuthor`.`staff_tel`, `OwnersAuthor`.`staff_mail`, `OwnersAuthor`.`mail2`, `OwnersAuthor`.`monthly_basic_price`, `OwnersAuthor`.`monthly_uu_unit_price`, `OwnersAuthor`.`initial_fee`, `OwnersAuthor`.`main_visual_1`, `OwnersAuthor`.`main_visual_2`, `OwnersAuthor`.`main_visual_3`, `OwnersAuthor`.`main_visual_4`, `OwnersAuthor`.`article_thumbnail`, `OwnersAuthor`.`shop_url`, `OwnersAuthor`.`external_url`, `OwnersAuthor`.`postal_code`, `OwnersAuthor`.`state`, `OwnersAuthor`.`city_id`, `OwnersAuthor`.`street`, `OwnersAuthor`.`shop_open_start`, `OwnersAuthor`.`shop_open_end`, `OwnersAuthor`.`shop_area`, `OwnersAuthor`.`shop_area2`, `OwnersAuthor`.`offer_total`, `OwnersAuthor`.`offer_person`, `OwnersAuthor`.`matching_total`, `OwnersAuthor`.`agreement_date`, `OwnersAuthor`.`cancel_date`, `OwnersAuthor`.`agreement_plan`, `OwnersAuthor`.`picture1`, `OwnersAuthor`.`picture1_ext`, `OwnersAuthor`.`picture2`, `OwnersAuthor`.`picture2_ext`, `OwnersAuthor`.`matching_menu`, `OwnersAuthor`.`is_suspension_service`, `OwnersAuthor`.`shop_pr1`, `OwnersAuthor`.`shop_pr2`, `OwnersAuthor`.`holiday`, `OwnersAuthor`.`special_gift`, `OwnersAuthor`.`gift_period`, `OwnersAuthor`.`agency_code`, `OwnersAuthor`.`payment_method`, `OwnersAuthor`.`credit_card_status`, `OwnersAuthor`.`business_hours`, `OwnersAuthor`.`average_budget`, `OwnersAuthor`.`available_days_before_reservation`, `OwnersAuthor`.`phone`, `OwnersAuthor`.`seats`, `OwnersAuthor`.`nearest_station`, `OwnersAuthor`.`reward`, `OwnersAuthor`.`miruden`, `OwnersAuthor`.`promotion_banner_image`, `OwnersAuthor`.`promotion_banner_url`, `OwnersAuthor`.`type`, `OwnersAuthor`.`job_use_flg`, `OwnersAuthor`.`test`, `OwnersAuthor`.`token`, `OwnersAuthor`.`status`, `OwnersAuthor`.`delete_flg`, `OwnersAuthor`.`created`, `OwnersAuthor`.`modified`, `FanAuthor`.`id`, `FanAuthor`.`username`, `FanAuthor`.`password`, `FanAuthor`.`name`, `FanAuthor`.`name_kana`, `FanAuthor`.`nickname`, `FanAuthor`.`phone`, `FanAuthor`.`profile`, `FanAuthor`.`profile_image`, `FanAuthor`.`postal_code`, `FanAuthor`.`prefecture_id`, `FanAuthor`.`address2`, `FanAuthor`.`address3`, `FanAuthor`.`person_in_charge1`, `FanAuthor`.`person_in_charge2`, `FanAuthor`.`contact`, `FanAuthor`.`department`, `FanAuthor`.`email1`, `FanAuthor`.`email2`, `FanAuthor`.`homepage`, `FanAuthor`.`contractor_name`, `FanAuthor`.`contract_plan_type`, `FanAuthor`.`company_logo`, `FanAuthor`.`fan_program_note`, `FanAuthor`.`last_login_date`, `FanAuthor`.`type`, `FanAuthor`.`external_link`, `FanAuthor`.`tags`, `FanAuthor`.`main_visual`, `FanAuthor`.`contact_email`, `FanAuthor`.`agency_code`, `FanAuthor`.`initial_fee`, `FanAuthor`.`monthly_fee_1`, `FanAuthor`.`monthly_fee_2`, `FanAuthor`.`directory`, `FanAuthor`.`display_matching_personal_information`, `FanAuthor`.`display_top`, `FanAuthor`.`status`, `FanAuthor`.`created`, `FanAuthor`.`modified` FROM `repohappy_web`.`articles` AS `Article` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Article`.`external_id` = `Shop`.`id` AND model = 'shop') LEFT JOIN `repohappy_web`.`shops` AS `Owners` ON (`Article`.`external_id` = `Owners`.`id` AND model = 'shop') LEFT JOIN `repohappy_web`.`writers` AS `Writer` ON (`Article`.`external_id` = `Writer`.`id` AND model = 'writer') LEFT JOIN `repohappy_web`.`writers` AS `Author` ON (`Article`.`writer_id` = `Author`.`id`) LEFT JOIN `repohappy_web`.`shops` AS `OwnersAuthor` ON (`Article`.`external_id` = `OwnersAuthor`.`id` AND model = 'shop') LEFT JOIN `repohappy_web`.`writers` AS `FanAuthor` ON (`Article`.`external_id` = `FanAuthor`.`id` AND model = 'writer')  WHERE `Article`.`external_id` = 46 AND `Article`.`Type` IN ('press', 'fan') AND `Article`.`status` = 'published'   ORDER BY `Article`.`published_date` desc  LIMIT 8
8
8
3845
73
SELECT `ArticleItem`.`id`, `ArticleItem`.`article_id`, `ArticleItem`.`title`, `ArticleItem`.`text`, `ArticleItem`.`media`, `ArticleItem`.`type`, `ArticleItem`.`sort`, `ArticleItem`.`created`, `ArticleItem`.`modified` FROM `repohappy_web`.`article_items` AS `ArticleItem`   WHERE `ArticleItem`.`article_id` IN (964, 909, 870, 807, 776, 774, 746, 717)   ORDER BY `ArticleItem`.`sort` ASC
130
130
1
74
SELECT `ArticleTag`.`id`, `ArticleTag`.`article_id`, `ArticleTag`.`tag_id`, `ArticleTag`.`created`, `ArticleTag`.`modified` FROM `repohappy_web`.`article_tags` AS `ArticleTag`   WHERE `ArticleTag`.`article_id` IN (964, 909, 870, 807, 776, 774, 746, 717)
20
20
0
75
SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite`   WHERE `Favorite`.`external_id` IN (964, 909, 870, 807, 776, 774, 746, 717)
55
55
1
76
SELECT `Comment`.`id`, `Comment`.`article_id`, `Comment`.`user_id`, `Comment`.`icon`, `Comment`.`comment`, `Comment`.`status`, `Comment`.`created`, `Comment`.`modified` FROM `repohappy_web`.`comments` AS `Comment`   WHERE `Comment`.`article_id` IN (964, 909, 870, 807, 776, 774, 746, 717)
0
0
0
77
SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite`   WHERE `Favorite`.`external_id` = 964 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL    LIMIT 1
0
0
0
78
SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS  `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS  `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/964' AND `Interest`.`cookie` = ''    LIMIT 1
0
0
1
79
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`)  WHERE `Favorite`.`external_id` = 964 AND `Favorite`.`model` = 'article'
1
1
0
80
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/964'
1
1
0
81
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment`   WHERE `Comment`.`article_id` = 964 AND NOT (`Comment`.`status` = 'delete')
1
1
0
82
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint`   WHERE `UserTagPoint`.`entity_id` = '964' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')
1
1
1
83
SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite`   WHERE `Favorite`.`external_id` = 909 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL    LIMIT 1
0
0
0
84
SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS  `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS  `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/909' AND `Interest`.`cookie` = ''    LIMIT 1
0
0
1
85
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`)  WHERE `Favorite`.`external_id` = 909 AND `Favorite`.`model` = 'article'
1
1
0
86
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/909'
1
1
0
87
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment`   WHERE `Comment`.`article_id` = 909 AND NOT (`Comment`.`status` = 'delete')
1
1
0
88
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint`   WHERE `UserTagPoint`.`entity_id` = '909' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')
1
1
2
89
SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite`   WHERE `Favorite`.`external_id` = 870 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL    LIMIT 1
0
0
0
90
SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS  `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS  `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/870' AND `Interest`.`cookie` = ''    LIMIT 1
0
0
1
91
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`)  WHERE `Favorite`.`external_id` = 870 AND `Favorite`.`model` = 'article'
1
1
0
92
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/870'
1
1
0
93
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment`   WHERE `Comment`.`article_id` = 870 AND NOT (`Comment`.`status` = 'delete')
1
1
0
94
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint`   WHERE `UserTagPoint`.`entity_id` = '870' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')
1
1
1
95
SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite`   WHERE `Favorite`.`external_id` = 807 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL    LIMIT 1
0
0
0
96
SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS  `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS  `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/807' AND `Interest`.`cookie` = ''    LIMIT 1
0
0
1
97
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`)  WHERE `Favorite`.`external_id` = 807 AND `Favorite`.`model` = 'article'
1
1
0
98
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/807'
1
1
0
99
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment`   WHERE `Comment`.`article_id` = 807 AND NOT (`Comment`.`status` = 'delete')
1
1
0
100
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint`   WHERE `UserTagPoint`.`entity_id` = '807' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')
1
1
2
101
SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite`   WHERE `Favorite`.`external_id` = 776 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL    LIMIT 1
0
0
0
102
SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS  `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS  `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/776' AND `Interest`.`cookie` = ''    LIMIT 1
0
0
1
103
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`)  WHERE `Favorite`.`external_id` = 776 AND `Favorite`.`model` = 'article'
1
1
0
104
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/776'
1
1
0
105
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment`   WHERE `Comment`.`article_id` = 776 AND NOT (`Comment`.`status` = 'delete')
1
1
0
106
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint`   WHERE `UserTagPoint`.`entity_id` = '776' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')
1
1
3
107
SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite`   WHERE `Favorite`.`external_id` = 774 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL    LIMIT 1
0
0
0
108
SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS  `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS  `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/774' AND `Interest`.`cookie` = ''    LIMIT 1
0
0
1
109
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`)  WHERE `Favorite`.`external_id` = 774 AND `Favorite`.`model` = 'article'
1
1
0
110
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/774'
1
1
0
111
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment`   WHERE `Comment`.`article_id` = 774 AND NOT (`Comment`.`status` = 'delete')
1
1
0
112
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint`   WHERE `UserTagPoint`.`entity_id` = '774' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')
1
1
3
113
SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite`   WHERE `Favorite`.`external_id` = 746 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL    LIMIT 1
0
0
0
114
SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS  `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS  `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/746' AND `Interest`.`cookie` = ''    LIMIT 1
0
0
1
115
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`)  WHERE `Favorite`.`external_id` = 746 AND `Favorite`.`model` = 'article'
1
1
1
116
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/746'
1
1
0
117
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment`   WHERE `Comment`.`article_id` = 746 AND NOT (`Comment`.`status` = 'delete')
1
1
0
118
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint`   WHERE `UserTagPoint`.`entity_id` = '746' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')
1
1
3
119
SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite`   WHERE `Favorite`.`external_id` = 717 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL    LIMIT 1
0
0
0
120
SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS  `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS  `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/717' AND `Interest`.`cookie` = ''    LIMIT 1
0
0
1
121
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`)  WHERE `Favorite`.`external_id` = 717 AND `Favorite`.`model` = 'article'
1
1
1
122
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`)  WHERE `Interest`.`address` = '/press/articles/view/717'
1
1
0
123
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment`   WHERE `Comment`.`article_id` = 717 AND NOT (`Comment`.`status` = 'delete')
1
1
0
124
SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint`   WHERE `UserTagPoint`.`entity_id` = '717' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')
1
1
7