| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Setting`.`value` FROM `dev_comtestmed`.`settings` AS `Setting` WHERE `key` = 'Recurring.paypal' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `SeoMeta`.`id`, `SeoMeta`.`url`, `SeoMeta`.`title`, `SeoMeta`.`description`, `SeoMeta`.`keywords`, `SeoMeta`.`nodes_id` FROM `dev_comtestmed`.`seo_metas` AS `SeoMeta` WHERE 1 = 1 | 17 | 17 | 0 | |
| SELECT `Block`.`id`, `Block`.`region_id`, `Block`.`title`, `Block`.`alias`, `Block`.`body`, `Block`.`show_title`, `Block`.`class`, `Block`.`status`, `Block`.`weight`, `Block`.`element`, `Block`.`visibility_roles`, `Block`.`visibility_paths`, `Block`.`visibility_php`, `Block`.`params`, `Block`.`updated`, `Block`.`created` FROM `dev_comtestmed`.`blocks` AS `Block` WHERE `Block`.`status` = '1' AND `Block`.`region_id` = 8 AND ((((`Block`.`visibility_roles` = '') OR (`Block`.`visibility_roles` LIKE '%\"3\"%'))) AND (((`Block`.`visibility_paths` = '') OR (`Block`.`visibility_paths` LIKE '%\"/blog\"%')))) ORDER BY `Block`.`weight` ASC | 1 | 1 | 0 | |
| SELECT `Block`.`id`, `Block`.`region_id`, `Block`.`title`, `Block`.`alias`, `Block`.`body`, `Block`.`show_title`, `Block`.`class`, `Block`.`status`, `Block`.`weight`, `Block`.`element`, `Block`.`visibility_roles`, `Block`.`visibility_paths`, `Block`.`visibility_php`, `Block`.`params`, `Block`.`updated`, `Block`.`created` FROM `dev_comtestmed`.`blocks` AS `Block` WHERE `Block`.`status` = '1' AND `Block`.`region_id` = 19 AND ((((`Block`.`visibility_roles` = '') OR (`Block`.`visibility_roles` LIKE '%\"3\"%'))) AND (((`Block`.`visibility_paths` = '') OR (`Block`.`visibility_paths` LIKE '%\"/blog\"%')))) ORDER BY `Block`.`weight` ASC | 4 | 4 | 0 | |
| SELECT `Link`.`id`, `Link`.`parent_id`, `Link`.`menu_id`, `Link`.`title`, `Link`.`class`, `Link`.`description`, `Link`.`link`, `Link`.`target`, `Link`.`rel`, `Link`.`status`, `Link`.`lft`, `Link`.`rght`, `Link`.`visibility_roles`, `Link`.`params`, `Link`.`updated`, `Link`.`created` FROM `dev_comtestmed`.`links` AS `Link` WHERE `Link`.`menu_id` = 3 AND `Link`.`status` = '1' AND ((`Link`.`visibility_roles` = '') OR (`Link`.`visibility_roles` LIKE '%\"3\"%')) ORDER BY `Link`.`lft` ASC | 0 | 0 | 0 | |
| SELECT `Link`.`id`, `Link`.`parent_id`, `Link`.`menu_id`, `Link`.`title`, `Link`.`class`, `Link`.`description`, `Link`.`link`, `Link`.`target`, `Link`.`rel`, `Link`.`status`, `Link`.`lft`, `Link`.`rght`, `Link`.`visibility_roles`, `Link`.`params`, `Link`.`updated`, `Link`.`created` FROM `dev_comtestmed`.`links` AS `Link` WHERE `Link`.`menu_id` = 4 AND `Link`.`status` = '1' AND ((`Link`.`visibility_roles` = '') OR (`Link`.`visibility_roles` LIKE '%\"3\"%')) ORDER BY `Link`.`lft` ASC | 0 | 0 | 0 | |
| SELECT `Type`.`id`, `Type`.`title`, `Type`.`alias`, `Type`.`description`, `Type`.`format_show_author`, `Type`.`format_show_date`, `Type`.`comment_status`, `Type`.`comment_approve`, `Type`.`comment_spam_protection`, `Type`.`comment_captcha`, `Type`.`params`, `Type`.`plugin`, `Type`.`updated`, `Type`.`created` FROM `dev_comtestmed`.`types` AS `Type` WHERE `Type`.`alias` = 'blog' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Vocabulary`.`id`, `Vocabulary`.`title`, `Vocabulary`.`alias`, `Vocabulary`.`description`, `Vocabulary`.`required`, `Vocabulary`.`multiple`, `Vocabulary`.`tags`, `Vocabulary`.`plugin`, `Vocabulary`.`weight`, `Vocabulary`.`updated`, `Vocabulary`.`created`, `TypesVocabulary`.`id`, `TypesVocabulary`.`type_id`, `TypesVocabulary`.`vocabulary_id`, `TypesVocabulary`.`weight` FROM `dev_comtestmed`.`vocabularies` AS `Vocabulary` JOIN `dev_comtestmed`.`types_vocabularies` AS `TypesVocabulary` ON (`TypesVocabulary`.`type_id` = 2 AND `TypesVocabulary`.`vocabulary_id` = `Vocabulary`.`id`) ORDER BY `Vocabulary`.`weight` ASC | 2 | 2 | 0 | |
| SELECT `Node`.`id`, `Node`.`parent_id`, `Node`.`user_id`, `Node`.`title`, `Node`.`slug`, `Node`.`body`, `Node`.`excerpt`, `Node`.`status`, `Node`.`mime_type`, `Node`.`comment_status`, `Node`.`comment_count`, `Node`.`promote`, `Node`.`path`, `Node`.`image`, `Node`.`terms`, `Node`.`sticky`, `Node`.`lft`, `Node`.`rght`, `Node`.`visibility_roles`, `Node`.`type`, `Node`.`template`, `Node`.`updated`, `Node`.`created`, `User`.`id`, `User`.`fname`, `User`.`lname`, `User`.`role_id`, `User`.`default`, `User`.`question_bank_database_id`, `User`.`active_bank`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`notes`, `User`.`website`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`street`, `User`.`stat`, `User`.`zip`, `User`.`phone`, `User`.`school`, `User`.`heard`, `User`.`additional`, `User`.`activation_key`, `User`.`folder`, `User`.`image`, `User`.`bio`, `User`.`timezone`, `User`.`status`, `User`.`fmodal_tr`, `User`.`fmodal_fi`, `User`.`fmodal_to`, `User`.`fmodal_sc`, `User`.`cd_date`, `User`.`cd_flag`, `User`.`show_avatar`, `User`.`signup_from`, `User`.`updated`, `User`.`created`, `User`.`lastLogin`, `User`.`comlex1`, `User`.`comlex2`, `User`.`comlex3`, `User`.`trial`, `User`.`comlex1_start`, `User`.`comlex1_end`, `User`.`comlex2_start`, `User`.`comlex2_end`, `User`.`comlex3_start`, `User`.`comlex3_end`, `User`.`comlex1_startflag`, `User`.`comlex2_startflag`, `User`.`comlex3_startflag`, `User`.`ipaddress`, `User`.`lastactive_date`, (CASE comlex1_startflag WHEN 0 THEN DATEDIFF(comlex1_end,comlex1_start) WHEN 1 THEN DATEDIFF(comlex1_end,current_timestamp) END) AS `User__comlex1_days`, (CASE comlex2_startflag WHEN 0 THEN DATEDIFF(comlex2_end,comlex2_start) WHEN 1 THEN DATEDIFF(comlex2_end,current_timestamp) END) AS `User__comlex2_days`, (CASE comlex3_startflag WHEN 0 THEN DATEDIFF(comlex3_end,comlex3_start) WHEN 1 THEN DATEDIFF(comlex3_end,current_timestamp) END) AS `User__comlex3_days`, (DATEDIFF(cd_date, current_timestamp)) AS `User__days_until_exam`, (CONCAT(`User`.`fname`, " ", `User`.`lname`)) AS `User__name` FROM `dev_comtestmed`.`nodes` AS `Node` LEFT JOIN `dev_comtestmed`.`users` AS `User` ON (`Node`.`user_id` = `User`.`id`) WHERE `Node`.`status` = '1' AND ((`Node`.`visibility_roles` = '') OR (`Node`.`visibility_roles` LIKE '%\"3\"%')) AND `Node`.`type` = 'blog' ORDER BY `Node`.`created` DESC LIMIT 5 | 2 | 2 | 0 | |
| SELECT `Meta`.`id`, `Meta`.`model`, `Meta`.`foreign_key`, `Meta`.`key`, `Meta`.`value`, `Meta`.`weight` FROM `dev_comtestmed`.`meta` AS `Meta` WHERE `Meta`.`model` = 'Node' AND `Meta`.`foreign_key` IN (152, 22) ORDER BY `Meta`.`key` ASC | 0 | 0 | 0 | |
| SELECT `Taxonomy`.`id`, `Taxonomy`.`parent_id`, `Taxonomy`.`term_id`, `Taxonomy`.`vocabulary_id`, `Taxonomy`.`lft`, `Taxonomy`.`rght`, `NodesTaxonomy`.`id`, `NodesTaxonomy`.`node_id`, `NodesTaxonomy`.`taxonomy_id` FROM `dev_comtestmed`.`taxonomies` AS `Taxonomy` JOIN `dev_comtestmed`.`nodes_taxonomies` AS `NodesTaxonomy` ON (`NodesTaxonomy`.`node_id` IN (152, 22) AND `NodesTaxonomy`.`taxonomy_id` = `Taxonomy`.`id`) | 0 | 0 | 0 | |
| SELECT COUNT(*) AS `count` FROM `dev_comtestmed`.`nodes` AS `Node` LEFT JOIN `dev_comtestmed`.`users` AS `User` ON (`Node`.`user_id` = `User`.`id`) WHERE `Node`.`status` = '1' AND ((`Node`.`visibility_roles` = '') OR (`Node`.`visibility_roles` LIKE '%\"3\"%')) AND `Node`.`type` = 'blog' | 1 | 1 | 0 | |
| SELECT `Role`.`id`, `Role`.`title` FROM `dev_comtestmed`.`roles` AS `Role` WHERE `id` IS NULL | 0 | 0 | 0 | |
| SELECT `Setting`.`value` FROM `dev_comtestmed`.`settings` AS `Setting` WHERE `key` = 'Recurring.paypal' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `SeoMeta`.`id`, `SeoMeta`.`url`, `SeoMeta`.`title`, `SeoMeta`.`description`, `SeoMeta`.`keywords`, `SeoMeta`.`nodes_id` FROM `dev_comtestmed`.`seo_metas` AS `SeoMeta` WHERE 1 = 1 | 17 | 17 | 1 | maybe slow |
| SELECT `Menu`.`id`, `Menu`.`title`, `Menu`.`alias`, `Menu`.`class`, `Menu`.`description`, `Menu`.`status`, `Menu`.`weight`, `Menu`.`link_count`, `Menu`.`params`, `Menu`.`updated`, `Menu`.`created` FROM `dev_comtestmed`.`menus` AS `Menu` WHERE 1 = 1 ORDER BY `Menu`.`id` ASC | 3 | 3 | 0 | |
| SELECT `Type`.`id`, `Type`.`title`, `Type`.`alias`, `Type`.`description`, `Type`.`format_show_author`, `Type`.`format_show_date`, `Type`.`comment_status`, `Type`.`comment_approve`, `Type`.`comment_spam_protection`, `Type`.`comment_captcha`, `Type`.`params`, `Type`.`plugin`, `Type`.`updated`, `Type`.`created` FROM `dev_comtestmed`.`types` AS `Type` WHERE ((`Type`.`plugin` LIKE '') OR (`Type`.`plugin` IS NULL)) ORDER BY `Type`.`alias` ASC | 3 | 3 | 0 | |
| SELECT `Vocabulary`.`id`, `Vocabulary`.`title`, `Vocabulary`.`alias`, `Vocabulary`.`description`, `Vocabulary`.`required`, `Vocabulary`.`multiple`, `Vocabulary`.`tags`, `Vocabulary`.`plugin`, `Vocabulary`.`weight`, `Vocabulary`.`updated`, `Vocabulary`.`created`, `TypesVocabulary`.`id`, `TypesVocabulary`.`type_id`, `TypesVocabulary`.`vocabulary_id`, `TypesVocabulary`.`weight` FROM `dev_comtestmed`.`vocabularies` AS `Vocabulary` JOIN `dev_comtestmed`.`types_vocabularies` AS `TypesVocabulary` ON (`TypesVocabulary`.`type_id` IN (2, 4, 1) AND `TypesVocabulary`.`vocabulary_id` = `Vocabulary`.`id`) ORDER BY `Vocabulary`.`weight` ASC | 4 | 4 | 0 | |
| SELECT `Vocabulary`.`id`, `Vocabulary`.`title`, `Vocabulary`.`alias`, `Vocabulary`.`description`, `Vocabulary`.`required`, `Vocabulary`.`multiple`, `Vocabulary`.`tags`, `Vocabulary`.`plugin`, `Vocabulary`.`weight`, `Vocabulary`.`updated`, `Vocabulary`.`created` FROM `dev_comtestmed`.`vocabularies` AS `Vocabulary` WHERE ((`Vocabulary`.`plugin` LIKE '') OR (`Vocabulary`.`plugin` IS NULL)) ORDER BY `Vocabulary`.`alias` ASC | 2 | 2 | 0 | |
| SELECT `Broadcast`.`id`, `Broadcast`.`link`, `Broadcast`.`replaceLink`, `Broadcast`.`status`, `Broadcast`.`created`, `Broadcast`.`modified` FROM `dev_comtestmed`.`broadcasts` AS `Broadcast` WHERE 1 = 1 ORDER BY `Broadcast`.`id` ASC | 15 | 15 | 0 | |
| SELECT `Setting`.`value` FROM `dev_comtestmed`.`settings` AS `Setting` WHERE `key` = 'Recurring.paypal' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `SeoMeta`.`id`, `SeoMeta`.`url`, `SeoMeta`.`title`, `SeoMeta`.`description`, `SeoMeta`.`keywords`, `SeoMeta`.`nodes_id` FROM `dev_comtestmed`.`seo_metas` AS `SeoMeta` WHERE 1 = 1 | 17 | 17 | 0 | |
| SELECT `Menu`.`id`, `Menu`.`title`, `Menu`.`alias`, `Menu`.`class`, `Menu`.`description`, `Menu`.`status`, `Menu`.`weight`, `Menu`.`link_count`, `Menu`.`params`, `Menu`.`updated`, `Menu`.`created` FROM `dev_comtestmed`.`menus` AS `Menu` WHERE 1 = 1 ORDER BY `Menu`.`id` ASC | 3 | 3 | 0 | |
| SELECT `Type`.`id`, `Type`.`title`, `Type`.`alias`, `Type`.`description`, `Type`.`format_show_author`, `Type`.`format_show_date`, `Type`.`comment_status`, `Type`.`comment_approve`, `Type`.`comment_spam_protection`, `Type`.`comment_captcha`, `Type`.`params`, `Type`.`plugin`, `Type`.`updated`, `Type`.`created` FROM `dev_comtestmed`.`types` AS `Type` WHERE ((`Type`.`plugin` LIKE '') OR (`Type`.`plugin` IS NULL)) ORDER BY `Type`.`alias` ASC | 3 | 3 | 0 | |
| SELECT `Vocabulary`.`id`, `Vocabulary`.`title`, `Vocabulary`.`alias`, `Vocabulary`.`description`, `Vocabulary`.`required`, `Vocabulary`.`multiple`, `Vocabulary`.`tags`, `Vocabulary`.`plugin`, `Vocabulary`.`weight`, `Vocabulary`.`updated`, `Vocabulary`.`created`, `TypesVocabulary`.`id`, `TypesVocabulary`.`type_id`, `TypesVocabulary`.`vocabulary_id`, `TypesVocabulary`.`weight` FROM `dev_comtestmed`.`vocabularies` AS `Vocabulary` JOIN `dev_comtestmed`.`types_vocabularies` AS `TypesVocabulary` ON (`TypesVocabulary`.`type_id` IN (2, 4, 1) AND `TypesVocabulary`.`vocabulary_id` = `Vocabulary`.`id`) ORDER BY `Vocabulary`.`weight` ASC | 4 | 4 | 0 | |
| SELECT `Vocabulary`.`id`, `Vocabulary`.`title`, `Vocabulary`.`alias`, `Vocabulary`.`description`, `Vocabulary`.`required`, `Vocabulary`.`multiple`, `Vocabulary`.`tags`, `Vocabulary`.`plugin`, `Vocabulary`.`weight`, `Vocabulary`.`updated`, `Vocabulary`.`created` FROM `dev_comtestmed`.`vocabularies` AS `Vocabulary` WHERE ((`Vocabulary`.`plugin` LIKE '') OR (`Vocabulary`.`plugin` IS NULL)) ORDER BY `Vocabulary`.`alias` ASC | 2 | 2 | 0 | |
| SELECT DATE_FORMAT(Node.created, '%M %Y') AS dd, count(`Node`.`id`) AS numblogs FROM `dev_comtestmed`.`nodes` AS `Node` WHERE `Node`.`type` = 'blog' AND `Node`.`status` = '1' GROUP BY dd ORDER BY `dd` DESC | 2 | 2 | 1 | maybe slow |
8 duplicate queries run.