(default) 22 queries took 329 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `news`16161
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';111
3SHOW FULL COLUMNS FROM `news_details`24241
4SHOW FULL COLUMNS FROM `blogs`26261
5SHOW FULL COLUMNS FROM `blog_details`23231
6SHOW FULL COLUMNS FROM `blog_prefs`991
7SHOW FULL COLUMNS FROM `comments`13131
8SHOW FULL COLUMNS FROM `master_languages`881
9SHOW FULL COLUMNS FROM `master_ages`13131
10SHOW FULL COLUMNS FROM `master_genders`13131
11SHOW FULL COLUMNS FROM `master_prefs`13131
12SHOW FULL COLUMNS FROM `admin_users`17172
13SELECT `Comment`.`id`, `Comment`.`master_language_id`, `Comment`.`title`, `Comment`.`sequence`, `Comment`.`published`, `Comment`.`public_flg`, `Comment`.`text`, `Comment`.`created`, `Comment`.`created_id`, `Comment`.`modified`, `Comment`.`modified_id`, `Comment`.`deleted`, `Comment`.`deleted_id`, ( DATE_FORMAT( DATE_SUB( `Comment`.`published`, INTERVAL 3 MONTH), '%Y') ) AS `Comment__yearth` FROM `comments` AS `Comment` WHERE `Comment`.`deleted` IS NULL AND `Comment`.`public_flg` = 1 AND `Comment`.`master_language_id` = 4 ORDER BY `Comment`.`sequence` ASC, `Comment`.`created` DESC, `Comment`.`id` DESC LIMIT 500020
14SELECT `News`.`id`, `News`.`type_id`, `News`.`master_language_id`, `News`.`title`, `News`.`sequence`, `News`.`published`, `News`.`public_flg`, `News`.`open_date`, `News`.`close_date`, `News`.`note`, `News`.`created`, `News`.`created_id`, `News`.`modified`, `News`.`modified_id`, `News`.`deleted`, `News`.`deleted_id`, ( DATE_FORMAT( DATE_SUB( `News`.`published`, INTERVAL 3 MONTH), '%Y') ) AS `News__yearth` FROM `news` AS `News` WHERE `News`.`deleted` IS NULL AND `News`.`public_flg` = 1 AND ((`News`.`open_date` <= '2016-07-26 02:49:22') OR (`News`.`open_date` IS NULL)) AND ((`News`.`close_date` >= '2016-07-26 02:49:22') OR (`News`.`close_date` IS NULL)) AND `News`.`master_language_id` = 4 ORDER BY `News`.`sequence` ASC, `News`.`published` DESC, `News`.`id` DESC LIMIT 4331
15SELECT `NewsDetail`.`id`, `NewsDetail`.`news_id`, `NewsDetail`.`title`, `NewsDetail`.`image`, `NewsDetail`.`image_position`, `NewsDetail`.`image_size`, `NewsDetail`.`image_alt`, `NewsDetail`.`text`, `NewsDetail`.`link_title`, `NewsDetail`.`link_url`, `NewsDetail`.`link_target`, `NewsDetail`.`file_title`, `NewsDetail`.`file`, `NewsDetail`.`published`, `NewsDetail`.`public_flg`, `NewsDetail`.`open_date`, `NewsDetail`.`close_date`, `NewsDetail`.`note`, `NewsDetail`.`created`, `NewsDetail`.`created_id`, `NewsDetail`.`modified`, `NewsDetail`.`modified_id`, `NewsDetail`.`deleted`, `NewsDetail`.`deleted_id` FROM `news_details` AS `NewsDetail` WHERE `NewsDetail`.`news_id` IN (40, 36, 31) ORDER BY `NewsDetail`.`id` ASC 6611
16SELECT COUNT(*) AS `count` FROM `blogs` AS `Blog` WHERE `Blog`.`deleted` IS NULL AND `Blog`.`public_flg` = 1 AND ((`Blog`.`open_date` <= '2016-07-26 02:49:22') OR (`Blog`.`open_date` IS NULL)) AND ((`Blog`.`close_date` >= '2016-07-26 02:49:22') OR (`Blog`.`close_date` IS NULL)) AND `Blog`.`master_language_id` = 4 1113
17SELECT `Blog`.`id`, `Blog`.`master_language_id`, `Blog`.`title`, `Blog`.`email`, `Blog`.`name`, `Blog`.`nickname`, `Blog`.`country`, `Blog`.`master_gender_id`, `Blog`.`master_age_id`, `Blog`.`master_country_id`, `Blog`.`birthday`, `Blog`.`address`, `Blog`.`movie`, `Blog`.`nice`, `Blog`.`sequence`, `Blog`.`published`, `Blog`.`public_flg`, `Blog`.`open_date`, `Blog`.`close_date`, `Blog`.`note`, `Blog`.`created`, `Blog`.`created_id`, `Blog`.`modified`, `Blog`.`modified_id`, `Blog`.`deleted`, `Blog`.`deleted_id`, ( DATE_FORMAT( DATE_SUB( `Blog`.`published`, INTERVAL 3 MONTH), '%Y') ) AS `Blog__yearth` FROM `blogs` AS `Blog` WHERE `Blog`.`deleted` IS NULL AND `Blog`.`public_flg` = 1 AND ((`Blog`.`open_date` <= '2016-07-26 02:49:22') OR (`Blog`.`open_date` IS NULL)) AND ((`Blog`.`close_date` >= '2016-07-26 02:49:22') OR (`Blog`.`close_date` IS NULL)) AND `Blog`.`master_language_id` = 4 ORDER BY `Blog`.`sequence` ASC, `Blog`.`published` DESC, `Blog`.`id` DESC LIMIT 2020202
18SELECT `BlogDetail`.`id`, `BlogDetail`.`blog_id`, `BlogDetail`.`image`, `BlogDetail`.`image_position`, `BlogDetail`.`image_size`, `BlogDetail`.`image_alt`, `BlogDetail`.`text`, `BlogDetail`.`link_title`, `BlogDetail`.`link_url`, `BlogDetail`.`link_target`, `BlogDetail`.`file_title`, `BlogDetail`.`file`, `BlogDetail`.`published`, `BlogDetail`.`public_flg`, `BlogDetail`.`open_date`, `BlogDetail`.`close_date`, `BlogDetail`.`note`, `BlogDetail`.`created`, `BlogDetail`.`created_id`, `BlogDetail`.`modified`, `BlogDetail`.`modified_id`, `BlogDetail`.`deleted`, `BlogDetail`.`deleted_id` FROM `blog_details` AS `BlogDetail` WHERE `BlogDetail`.`blog_id` IN (529, 525, 524, 513, 512, 511, 510, 509, 508, 507, 506, 504, 501, 499, 498, 497, 494, 493, 491, 480) ORDER BY `BlogDetail`.`id` ASC 235235266
19SELECT `BlogPref`.`id`, `BlogPref`.`blog_id`, `BlogPref`.`master_pref_id`, `BlogPref`.`created_id`, `BlogPref`.`created`, `BlogPref`.`modified_id`, `BlogPref`.`modified`, `BlogPref`.`deleted_id`, `BlogPref`.`deleted` FROM `blog_prefs` AS `BlogPref` WHERE `BlogPref`.`blog_id` IN (529, 525, 524, 513, 512, 511, 510, 509, 508, 507, 506, 504, 501, 499, 498, 497, 494, 493, 491, 480) ORDER BY `BlogPref`.`id` ASC 22223
20SELECT `MasterAge`.`id`, `MasterAge`.`name_kr` FROM `master_ages` AS `MasterAge` WHERE `MasterAge`.`deleted` IS NULL 770
21SELECT `MasterPref`.`id`, `MasterPref`.`name` FROM `master_prefs` AS `MasterPref` WHERE `MasterPref`.`deleted` IS NULL 770
22SELECT `MasterGender`.`id`, `MasterGender`.`name_kr` FROM `master_genders` AS `MasterGender` WHERE `MasterGender`.`deleted` IS NULL 220