| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `videos` | 98 | 98 | 11 | |
| 2 | DESCRIBE `categories` | 2 | 2 | 1 | |
| 3 | DESCRIBE `i18n` | 6 | 6 | 2 | |
| 4 | DESCRIBE `comments` | 5 | 5 | 2 | |
| 5 | DESCRIBE `tags` | 4 | 4 | 1 | |
| 6 | DESCRIBE `tags_videos` | 2 | 2 | 1 | |
| 7 | DESCRIBE `brieves` | 44 | 44 | 5 | |
| 8 | DESCRIBE `lists` | 146 | 146 | 16 | |
| 9 | DESCRIBE `subadmin_users` | 5 | 5 | 2 | |
| 10 | DESCRIBE `subadmin_categories` | 2 | 2 | 1 | |
| 11 | DESCRIBE `subadmin2_users` | 5 | 5 | 1 | |
| 12 | DESCRIBE `subadmin2_categories` | 2 | 2 | 1 | |
| 13 | DESCRIBE `subadmin3_users` | 5 | 5 | 1 | |
| 14 | DESCRIBE `subadmin3_categories` | 2 | 2 | 1 | |
| 15 | DESCRIBE `partners` | 8 | 8 | 2 | |
| 16 | DESCRIBE `correspondents` | 12 | 12 | 2 | |
| 17 | SELECT `Correspondent`.`id`, `Correspondent`.`name`, `Correspondent`.`blog`, `Correspondent`.`profile`, `Correspondent`.`website`, `Correspondent`.`front_photo`, `Correspondent`.`profile_photo`, `Correspondent`.`other_photo`, `Correspondent`.`small_desc`, `Correspondent`.`full_desc`, `Correspondent`.`is_active`, `Correspondent`.`position_in_page` FROM `correspondents` AS `Correspondent` WHERE 1 = 1 ORDER BY RAND() ASC LIMIT 1 | 1 | 1 | 2 | |
| 18 | SELECT `UPDATE videos SET num_week = 0 WHERE 1=1;`, `Video`.`id`, `Video`.`title`, `Video`.`subtitle_50_chr`, `Video`.`summary_100_chr`, `Video`.`year`, `Video`.`description`, `Video`.`keywords`, `Video`.`file`, `Video`.`thumbnail`, `Video`.`duration`, `Video`.`author`, `Video`.`productor`, `Video`.`languages`, `Video`.`num_viewer`, `Video`.`num_month`, `Video`.`num_week`, `Video`.`is_ecology`, `Video`.`is_eu_affairs`, `Video`.`is_w_conflicts`, `Video`.`is_polemics`, `Video`.`is_history`, `Video`.`is_social_issues`, `Video`.`is_economy`, `Video`.`is_science`, `Video`.`is_media`, `Video`.`is_movies`, `Video`.`is_culture`, `Video`.`is_education`, `Video`.`is_living_style`, `Video`.`is_health`, `Video`.`is_defence`, `Video`.`is_agro_fish`, `Video`.`is_jai`, `Video`.`is_trans_e_tel`, `Video`.`is_politics`, `Video`.`is_institutions`, `Video`.`is_cooperation`, `Video`.`is_people`, `Video`.`is_security`, `Video`.`is_int_relations`, `Video`.`is_migrations`, `Video`.`is_catast_acc`, `Video`.`is_violence_terror`, `Video`.`is_events`, `Video`.`is_associations`, `Video`.`is_nature`, `Video`.`is_employment`, `Video`.`is_trade`, `Video`.`is_industry`, `Video`.`is_e_regions`, `Video`.`is_religions`, `Video`.`is_literature`, `Video`.`is_music`, `Video`.`is_theater_d`, `Video`.`is_arts`, `Video`.`is_sports`, `Video`.`is_ourchoice`, `Video`.`is_other_times`, `Video`.`is_beyond`, `Video`.`is_panorama`, `Video`.`is_homepage`, `Video`.`is_frontpage`, `Video`.`is_ereport`, `Video`.`is_ihd`, `Video`.`is_now`, `Video`.`is_street`, `Video`.`is_guest`, `Video`.`is_lastpage`, `Video`.`is_featured`, `Video`.`is_horizon`, `Video`.`is_live`, `Video`.`is_special`, `Video`.`is_homepage2`, `Video`.`is_frontpage2`, `Video`.`is_lastpage2`, `Video`.`is_ereport2`, `Video`.`is_guest2`, `Video`.`is_live2`, `Video`.`is_street2`, `Video`.`is_now2`, `Video`.`is_panorama2`, `Video`.`is_other_times2`, `Video`.`is_ihd2`, `Video`.`is_featured2`, `Video`.`is_special2`, `Video`.`is_horizon2`, `Video`.`is_ourchoice2`, `Video`.`is_beyond2`, `Video`.`is_disabled`, `Video`.`last_view`, `Video`.`category_id`, `Video`.`subadmin_user_id`, `Video`.`subadmin2_user_id`, `Video`.`subadmin3_user_id`, `Video`.`url`, `Video`.`urlname`, `Video`.`is_fullscreening`, `Category`.`id`, `Category`.`position_in_menu` FROM `videos` AS `Video` LEFT JOIN `categories` AS `Category` ON (`Video`.`category_id` = `Category`.`id`) WHERE `Video`.`id` = 499 LIMIT 1 | 1 | 1 | 2 | |
| 19 | UPDATE `videos` AS `Video` LEFT JOIN `categories` AS `Category` ON (`Video`.`category_id` = `Category`.`id`) SET `Video`.`num_viewer` = 9267, `Video`.`last_view` = NOW() WHERE `Video`.`id`=499 | 1 | 1 | ||
| 20 | UPDATE `videos` AS `Video` LEFT JOIN `categories` AS `Category` ON (`Video`.`category_id` = `Category`.`id`) SET `Video`.`num_week` = 64, `Video`.`last_view` = NOW() WHERE `Video`.`id`=499 | 1 | 1 | ||
| 21 | UPDATE `videos` AS `Video` LEFT JOIN `categories` AS `Category` ON (`Video`.`category_id` = `Category`.`id`) SET `Video`.`num_month` = 255, `Video`.`last_view` = NOW() WHERE `Video`.`id`=499 | 1 | 1 | ||
| 22 | SELECT `Video`.`id`, `Video`.`thumbnail`, `Video`.`title`, `Video`.`subtitle_50_chr`, `Video`.`summary_100_chr`, `Video`.`duration`, `Video`.`num_week`, `Video`.`num_viewer` FROM `videos` AS `Video` LEFT JOIN `categories` AS `Category` ON (`Video`.`category_id` = `Category`.`id`) WHERE `Video`.`is_panorama` = 1 AND `Video`.`is_disabled` = 0 ORDER BY `Video`.`num_week` DESC LIMIT 33 | 33 | 33 | 18 | |
| 23 | SELECT `Video`.`id`, `Video`.`thumbnail`, `Video`.`subtitle_50_chr`, `Video`.`summary_100_chr`, `Video`.`title`, `Video`.`num_viewer`, `Video`.`duration`, `Video`.`num_week` FROM `videos` AS `Video` LEFT JOIN `categories` AS `Category` ON (`Video`.`category_id` = `Category`.`id`) WHERE `Video`.`is_disabled` = 0 ORDER BY `Video`.`num_viewer` DESC LIMIT 66 | 66 | 66 | 8 | |
| 24 | SELECT `Video`.`id`, `Video`.`thumbnail`, `Video`.`subtitle_50_chr`, `Video`.`summary_100_chr`, `Video`.`title`, `Video`.`num_viewer`, `Video`.`duration`, `Video`.`num_week` FROM `videos` AS `Video` LEFT JOIN `categories` AS `Category` ON (`Video`.`category_id` = `Category`.`id`) WHERE `Video`.`is_disabled` = 0 ORDER BY `Video`.`num_week` DESC LIMIT 19 | 19 | 19 | 3 | |
| 25 | SELECT `Video`.`id`, `Video`.`thumbnail`, `Video`.`subtitle_50_chr`, `Video`.`summary_100_chr`, `Video`.`title`, `Video`.`num_viewer`, `Video`.`duration`, `Video`.`num_week` FROM `videos` AS `Video` LEFT JOIN `categories` AS `Category` ON (`Video`.`category_id` = `Category`.`id`) WHERE `Video`.`is_disabled` = 0 ORDER BY `Video`.`last_view` DESC LIMIT 66 | 66 | 66 | 6 |