Query | Error | Affected | Num. rows | Took (ms) | Actions |
---|
SHOW FULL COLUMNS FROM `courses` | | 10 | 10 | 2 | maybe slow |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | | 1 | 1 | 1 | |
SHOW FULL COLUMNS FROM `users` | | 21 | 21 | 2 | maybe slow |
SHOW FULL COLUMNS FROM `lessons` | | 12 | 12 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `lesson_questions` | | 12 | 12 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `pages` | | 27 | 27 | 1 | |
SHOW FULL COLUMNS FROM `page_contents` | | 16 | 16 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `question_answers` | | 6 | 6 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `question_rules` | | 8 | 8 | 2 | maybe slow |
SHOW FULL COLUMNS FROM `email_responses` | | 8 | 8 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `lessons_users` | | 11 | 11 | 2 | maybe slow |
SHOW FULL COLUMNS FROM `couples` | | 17 | 17 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `churches` | | 26 | 26 | 1 | |
SHOW FULL COLUMNS FROM `profiles` | | 19 | 19 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `details` | | 10 | 10 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `coupons` | | 14 | 14 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `gift_certificates` | | 6 | 6 | 2 | maybe slow |
SHOW FULL COLUMNS FROM `media` | | 18 | 18 | 3 | maybe slow |
SELECT `Course`.`id`, `Course`.`user_id`, `Course`.`title`, `Course`.`slug`, `Course`.`description`, `Course`.`lesson_count`, `Course`.`price`, `Course`.`active`, `Course`.`created`, `Course`.`modified` FROM `courses` AS `Course` WHERE 1 = 1 LIMIT 1 | | 1 | 1 | 0 | |
SHOW FULL COLUMNS FROM `carts` | | 8 | 8 | 2 | maybe slow |
SHOW FULL COLUMNS FROM `cart_orders` | | 23 | 23 | 2 | maybe slow |
SHOW FULL COLUMNS FROM `cart_shipping_addresses` | | 12 | 12 | 2 | maybe slow |
SHOW FULL COLUMNS FROM `cart_captures` | | 8 | 8 | 2 | maybe slow |
SHOW FULL COLUMNS FROM `carts_items` | | 20 | 20 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `cart_items_refunds` | | 7 | 7 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `cart_refunds` | | 12 | 12 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `cart_discounts` | | 9 | 9 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `cart_discounts_carts` | | 3 | 3 | 2 | maybe slow |
SELECT COUNT(*) AS `count` FROM `courses` AS `Course` WHERE `Course`.`active` = 1 | | 1 | 1 | 0 | |
SELECT `Course`.`id`, `Course`.`user_id`, `Course`.`title`, `Course`.`slug`, `Course`.`description`, `Course`.`lesson_count`, `Course`.`price`, `Course`.`active`, `Course`.`created`, `Course`.`modified` FROM `courses` AS `Course` WHERE `Course`.`active` = 1 LIMIT 20 | | 1 | 1 | 0 | |
SHOW FULL COLUMNS FROM `items` | | 16 | 16 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `categories` | | 13 | 13 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `categorized` | | 7 | 7 | 2 | maybe slow |
SHOW FULL COLUMNS FROM `tags` | | 7 | 7 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `tagged` | | 7 | 7 | 1 | maybe slow |
SELECT `ResourcePackage`.`id`, `ResourcePackage`.`media_id`, `ResourcePackage`.`name`, `ResourcePackage`.`slug`, `ResourcePackage`.`description`, `ResourcePackage`.`price`, `ResourcePackage`.`sku`, `ResourcePackage`.`views`, `ResourcePackage`.`active`, `ResourcePackage`.`sale_start`, `ResourcePackage`.`sale_end`, `ResourcePackage`.`info_url`, `ResourcePackage`.`created`, `ResourcePackage`.`modified`, `ResourcePackage`.`units`, `ResourcePackage`.`scope`, `Photo`.`id`, `Photo`.`user_id`, `Photo`.`foreign_key`, `Photo`.`model`, `Photo`.`title`, `Photo`.`slug`, `Photo`.`description`, `Photo`.`path`, `Photo`.`filename`, `Photo`.`filesize`, `Photo`.`hash`, `Photo`.`mime_type`, `Photo`.`views`, `Photo`.`downloads`, `Photo`.`created`, `Photo`.`modified`, `Photo`.`type`, `Photo`.`url` FROM `items` AS `ResourcePackage` LEFT JOIN `media` AS `Photo` ON (`Photo`.`foreign_key` = `ResourcePackage`.`id`) WHERE `ResourcePackage`.`scope` = 'resource_package' | | 0 | 0 | 0 | |
SHOW FULL COLUMNS FROM `seo_meta_tags` | | 7 | 7 | 2 | maybe slow |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | | 1 | 1 | 1 | |
SHOW FULL COLUMNS FROM `seo_uris` | | 5 | 5 | 2 | maybe slow |
SHOW FULL COLUMNS FROM `seo_redirects` | | 8 | 8 | 2 | maybe slow |
SHOW FULL COLUMNS FROM `seo_titles` | | 5 | 5 | 2 | maybe slow |
SHOW FULL COLUMNS FROM `seo_canonicals` | | 6 | 6 | 2 | maybe slow |
SHOW FULL COLUMNS FROM `seo_status_codes` | | 7 | 7 | 2 | maybe slow |
SELECT `SeoMetaTag`.`id`, `SeoMetaTag`.`seo_uri_id`, `SeoMetaTag`.`name`, `SeoMetaTag`.`content`, `SeoMetaTag`.`is_http_equiv`, `SeoMetaTag`.`created`, `SeoMetaTag`.`modified`, `SeoUri`.`uri` FROM `seo_meta_tags` AS `SeoMetaTag` LEFT JOIN `seo_uris` AS `SeoUri` ON (`SeoMetaTag`.`seo_uri_id` = `SeoUri`.`id`) WHERE `SeoUri`.`uri` = '/gift_certificates' AND `SeoUri`.`is_approved` = 1 | | 0 | 0 | 0 | |
SELECT `SeoUri`.`id`, `SeoUri`.`uri` FROM `seo_uris` AS `SeoUri` WHERE ((`SeoUri`.`uri` LIKE '#%') OR (`SeoUri`.`uri` LIKE '%*')) AND `SeoUri`.`is_approved` = 1 | | 1 | 1 | 0 | |
SELECT `SeoMetaTag`.`id`, `SeoMetaTag`.`seo_uri_id`, `SeoMetaTag`.`name`, `SeoMetaTag`.`content`, `SeoMetaTag`.`is_http_equiv`, `SeoMetaTag`.`created`, `SeoMetaTag`.`modified` FROM `seo_meta_tags` AS `SeoMetaTag` WHERE `SeoMetaTag`.`seo_uri_id` = (1) | | 5 | 5 | 0 | |