Query | Error | Affected | Num. rows | Took (ms) | Actions |
---|
SHOW FULL COLUMNS FROM `jlg_cases` | | 25 | 25 | 11 | maybe slow |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | | 1 | 1 | 11 | maybe slow |
SHOW FULL COLUMNS FROM `practice_areas` | | 6 | 6 | 11 | maybe slow |
SHOW FULL COLUMNS FROM `configuration` | | 3 | 3 | 11 | maybe slow |
SHOW FULL COLUMNS FROM `user_groups` | | 3 | 3 | 11 | maybe slow |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | | 1 | 1 | 11 | maybe slow |
SHOW FULL COLUMNS FROM `users` | | 15 | 15 | 11 | maybe slow |
SHOW FULL COLUMNS FROM `companies` | | 6 | 6 | 12 | maybe slow |
SHOW FULL COLUMNS FROM `login_tokens` | | 7 | 7 | 11 | maybe slow |
SHOW FULL COLUMNS FROM `user_group_permissions` | | 6 | 6 | 11 | maybe slow |
SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`value` FROM `configuration` AS `Configuration` WHERE 1 = 1 | | 14 | 14 | 11 | maybe slow |
SELECT `JlgCase`.`id` FROM `jlg_cases` AS `JlgCase` WHERE `JlgCase`.`featured_video_link` > '0' ORDER BY `JlgCase`.`disposition_date` DESC | | 43 | 43 | 14 | maybe slow |
SELECT `JlgCase`.`id`, `JlgCase`.`caption`, `JlgCase`.`sort_order`, `JlgCase`.`practice_area_id`, `JlgCase`.`citation`, `JlgCase`.`subsequent_history`, `JlgCase`.`disposition_date`, `JlgCase`.`status`, `JlgCase`.`win_lose`, `JlgCase`.`reported`, `JlgCase`.`oral_argument`, `JlgCase`.`noa_link`, `JlgCase`.`brief_link`, `JlgCase`.`reply_brief_link`, `JlgCase`.`decision_link`, `JlgCase`.`other1_link`, `JlgCase`.`other2_link`, `JlgCase`.`other3_link`, `JlgCase`.`audio_link`, `JlgCase`.`video_link`, `JlgCase`.`featured_video_link`, `JlgCase`.`short_description`, `JlgCase`.`featured_video_text`, `JlgCase`.`featured_win_text`, `JlgCase`.`notes`, `PracticeArea`.`id`, `PracticeArea`.`name`, `PracticeArea`.`sort_order`, `PracticeArea`.`anchor_name`, `PracticeArea`.`class`, `PracticeArea`.`description` FROM `jlg_cases` AS `JlgCase` LEFT JOIN `practice_areas` AS `PracticeArea` ON (`JlgCase`.`practice_area_id` = `PracticeArea`.`id`) WHERE `JlgCase`.`id` = 163 LIMIT 1 | | 1 | 1 | 12 | maybe slow |
SELECT `JlgCase`.`id`, `JlgCase`.`caption`, `JlgCase`.`sort_order`, `JlgCase`.`practice_area_id`, `JlgCase`.`citation`, `JlgCase`.`subsequent_history`, `JlgCase`.`disposition_date`, `JlgCase`.`status`, `JlgCase`.`win_lose`, `JlgCase`.`reported`, `JlgCase`.`oral_argument`, `JlgCase`.`noa_link`, `JlgCase`.`brief_link`, `JlgCase`.`reply_brief_link`, `JlgCase`.`decision_link`, `JlgCase`.`other1_link`, `JlgCase`.`other2_link`, `JlgCase`.`other3_link`, `JlgCase`.`audio_link`, `JlgCase`.`video_link`, `JlgCase`.`featured_video_link`, `JlgCase`.`short_description`, `JlgCase`.`featured_video_text`, `JlgCase`.`featured_win_text`, `JlgCase`.`notes`, `PracticeArea`.`id`, `PracticeArea`.`name`, `PracticeArea`.`sort_order`, `PracticeArea`.`anchor_name`, `PracticeArea`.`class`, `PracticeArea`.`description` FROM `jlg_cases` AS `JlgCase` LEFT JOIN `practice_areas` AS `PracticeArea` ON (`JlgCase`.`practice_area_id` = `PracticeArea`.`id`) WHERE `JlgCase`.`featured_video_link` > '0' AND `JlgCase`.`id` <> 163 ORDER BY `JlgCase`.`disposition_date` DESC | | 42 | 42 | 22 | maybe slow |