Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `ComMediaSetting`.`id`, `ComMediaSetting`.`key`, `ComMediaSetting`.`value`, `ComMediaSetting`.`en`, `ComMediaSetting`.`fr` FROM `quebecelan_LIVE_H`.`com_media_settings` AS `ComMediaSetting` WHERE 1 = 1 | 32 | 32 | 0 | |
SELECT `Raev`.`id`, `Raev`.`discipline_id`, `Raev`.`status`, `Raev`.`firstName`, `Raev`.`lastName`, `Raev`.`image`, `Raev`.`image_large`, `Raev`.`content`, `Raev`.`content_fr`, `Raev`.`video`, `Raev`.`video_fr` FROM `quebecelan_LIVE_H`.`raevs` AS `Raev` WHERE 1 = 1 ORDER BY rand() ASC LIMIT 1 | 1 | 1 | 6 | maybe slow |
SELECT `PostCategory`.`id` FROM `quebecelan_LIVE_H`.`post_categories` AS `PostCategory` WHERE `PostCategory`.`section` = 'links' | 0 | 0 | 0 | |
SELECT `Post`.`id`, `Post`.`created`, `Post`.`modified`, `Post`.`start_date`, `Post`.`end_date`, `Post`.`user_id`, `Post`.`enabled`, `Post`.`featured`, `Post`.`nextEvent`, `Post`.`post_category_id`, `Post`.`newsletter_id`, `Post`.`comments_enabled`, `Post`.`sticky`, `Post`.`title`, `Post`.`title_fr`, `Post`.`intro`, `Post`.`intro_fr`, `Post`.`body`, `Post`.`body_fr`, `Post`.`author`, `Post`.`sourceUrl`, `Post`.`tags`, `User`.`id`, `User`.`membership_number`, `User`.`created`, `User`.`modified`, `User`.`edited`, `User`.`visible`, `User`.`hide`, `User`.`enabled`, `User`.`last_login`, `User`.`user_type_id`, `User`.`email`, `User`.`password`, `User`.`slug`, `User`.`first_name`, `User`.`last_name`, `User`.`organisation_name`, `User`.`contact_name`, `User`.`contact_title`, `User`.`contact_telephone`, `User`.`contact_email`, `User`.`about_us`, `User`.`institution`, `User`.`label`, `User`.`sort_label`, `User`.`street`, `User`.`city`, `User`.`region_id`, `User`.`province_id`, `User`.`postal_code`, `User`.`telephone`, `User`.`fax`, `User`.`display_email`, `User`.`website`, `User`.`bio`, `User`.`notes`, `User`.`stature_id`, `User`.`learned_about_source_id`, `User`.`headshot_location`, `User`.`headshot`, `User`.`headshot_width`, `User`.`headshot_height`, `User`.`headshot_mimetype`, `User`.`mentor`, `User`.`mentee`, `User`.`p_a_d`, `User`.`public`, `User`.`lng`, `User`.`lat`, `User`.`doNotEmail`, `User`.`optin`, `User`.`optin_ip`, `User`.`optin_date`, `User`.`unsubscribed_date`, `PostCategory`.`id`, `PostCategory`.`name`, `PostCategory`.`fr`, `PostCategory`.`slug`, `PostCategory`.`section` FROM `quebecelan_LIVE_H`.`posts` AS `Post` LEFT JOIN `quebecelan_LIVE_H`.`users` AS `User` ON (`Post`.`user_id` = `User`.`id`) LEFT JOIN `quebecelan_LIVE_H`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE ((`Post`.`featured` = '1') AND (`Post`.`enabled` = '1') AND (`Post`.`post_category_id` IS NULL)) ORDER BY `Post`.`created` desc LIMIT 1 | 0 | 0 | 0 | |
SELECT `PostCategory`.`id` FROM `quebecelan_LIVE_H`.`post_categories` AS `PostCategory` WHERE `PostCategory`.`section` = 'links' | 0 | 0 | 0 | |
SELECT `Post`.`id`, `Post`.`created`, `Post`.`modified`, `Post`.`start_date`, `Post`.`end_date`, `Post`.`user_id`, `Post`.`enabled`, `Post`.`featured`, `Post`.`nextEvent`, `Post`.`post_category_id`, `Post`.`newsletter_id`, `Post`.`comments_enabled`, `Post`.`sticky`, `Post`.`title`, `Post`.`title_fr`, `Post`.`intro`, `Post`.`intro_fr`, `Post`.`body`, `Post`.`body_fr`, `Post`.`author`, `Post`.`sourceUrl`, `Post`.`tags`, `User`.`id`, `User`.`membership_number`, `User`.`created`, `User`.`modified`, `User`.`edited`, `User`.`visible`, `User`.`hide`, `User`.`enabled`, `User`.`last_login`, `User`.`user_type_id`, `User`.`email`, `User`.`password`, `User`.`slug`, `User`.`first_name`, `User`.`last_name`, `User`.`organisation_name`, `User`.`contact_name`, `User`.`contact_title`, `User`.`contact_telephone`, `User`.`contact_email`, `User`.`about_us`, `User`.`institution`, `User`.`label`, `User`.`sort_label`, `User`.`street`, `User`.`city`, `User`.`region_id`, `User`.`province_id`, `User`.`postal_code`, `User`.`telephone`, `User`.`fax`, `User`.`display_email`, `User`.`website`, `User`.`bio`, `User`.`notes`, `User`.`stature_id`, `User`.`learned_about_source_id`, `User`.`headshot_location`, `User`.`headshot`, `User`.`headshot_width`, `User`.`headshot_height`, `User`.`headshot_mimetype`, `User`.`mentor`, `User`.`mentee`, `User`.`p_a_d`, `User`.`public`, `User`.`lng`, `User`.`lat`, `User`.`doNotEmail`, `User`.`optin`, `User`.`optin_ip`, `User`.`optin_date`, `User`.`unsubscribed_date`, `PostCategory`.`id`, `PostCategory`.`name`, `PostCategory`.`fr`, `PostCategory`.`slug`, `PostCategory`.`section` FROM `quebecelan_LIVE_H`.`posts` AS `Post` LEFT JOIN `quebecelan_LIVE_H`.`users` AS `User` ON (`Post`.`user_id` = `User`.`id`) LEFT JOIN `quebecelan_LIVE_H`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE ((NOT (`Post`.`featured` = '1')) AND (`Post`.`post_category_id` IS NULL) AND (`Post`.`enabled` = '1')) ORDER BY `Post`.`created` desc LIMIT 5 | 0 | 0 | 0 | |
SELECT `PostCategory`.`id` FROM `quebecelan_LIVE_H`.`post_categories` AS `PostCategory` WHERE `PostCategory`.`section` = 'links' | 0 | 0 | 0 | |
SELECT `Post`.`id`, `Post`.`created`, `Post`.`modified`, `Post`.`start_date`, `Post`.`end_date`, `Post`.`user_id`, `Post`.`enabled`, `Post`.`featured`, `Post`.`nextEvent`, `Post`.`post_category_id`, `Post`.`newsletter_id`, `Post`.`comments_enabled`, `Post`.`sticky`, `Post`.`title`, `Post`.`title_fr`, `Post`.`intro`, `Post`.`intro_fr`, `Post`.`body`, `Post`.`body_fr`, `Post`.`author`, `Post`.`sourceUrl`, `Post`.`tags`, `User`.`id`, `User`.`membership_number`, `User`.`created`, `User`.`modified`, `User`.`edited`, `User`.`visible`, `User`.`hide`, `User`.`enabled`, `User`.`last_login`, `User`.`user_type_id`, `User`.`email`, `User`.`password`, `User`.`slug`, `User`.`first_name`, `User`.`last_name`, `User`.`organisation_name`, `User`.`contact_name`, `User`.`contact_title`, `User`.`contact_telephone`, `User`.`contact_email`, `User`.`about_us`, `User`.`institution`, `User`.`label`, `User`.`sort_label`, `User`.`street`, `User`.`city`, `User`.`region_id`, `User`.`province_id`, `User`.`postal_code`, `User`.`telephone`, `User`.`fax`, `User`.`display_email`, `User`.`website`, `User`.`bio`, `User`.`notes`, `User`.`stature_id`, `User`.`learned_about_source_id`, `User`.`headshot_location`, `User`.`headshot`, `User`.`headshot_width`, `User`.`headshot_height`, `User`.`headshot_mimetype`, `User`.`mentor`, `User`.`mentee`, `User`.`p_a_d`, `User`.`public`, `User`.`lng`, `User`.`lat`, `User`.`doNotEmail`, `User`.`optin`, `User`.`optin_ip`, `User`.`optin_date`, `User`.`unsubscribed_date`, `PostCategory`.`id`, `PostCategory`.`name`, `PostCategory`.`fr`, `PostCategory`.`slug`, `PostCategory`.`section` FROM `quebecelan_LIVE_H`.`posts` AS `Post` LEFT JOIN `quebecelan_LIVE_H`.`users` AS `User` ON (`Post`.`user_id` = `User`.`id`) LEFT JOIN `quebecelan_LIVE_H`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE ((`Post`.`id` = 4630) AND (`Post`.`post_category_id` IS NULL)) | 0 | 0 | 1 | maybe slow |
SELECT `Post`.`id`, `Post`.`created`, `Post`.`modified`, `Post`.`start_date`, `Post`.`end_date`, `Post`.`user_id`, `Post`.`enabled`, `Post`.`featured`, `Post`.`nextEvent`, `Post`.`post_category_id`, `Post`.`newsletter_id`, `Post`.`comments_enabled`, `Post`.`sticky`, `Post`.`title`, `Post`.`title_fr`, `Post`.`intro`, `Post`.`intro_fr`, `Post`.`body`, `Post`.`body_fr`, `Post`.`author`, `Post`.`sourceUrl`, `Post`.`tags`, `User`.`id`, `User`.`membership_number`, `User`.`created`, `User`.`modified`, `User`.`edited`, `User`.`visible`, `User`.`hide`, `User`.`enabled`, `User`.`last_login`, `User`.`user_type_id`, `User`.`email`, `User`.`password`, `User`.`slug`, `User`.`first_name`, `User`.`last_name`, `User`.`organisation_name`, `User`.`contact_name`, `User`.`contact_title`, `User`.`contact_telephone`, `User`.`contact_email`, `User`.`about_us`, `User`.`institution`, `User`.`label`, `User`.`sort_label`, `User`.`street`, `User`.`city`, `User`.`region_id`, `User`.`province_id`, `User`.`postal_code`, `User`.`telephone`, `User`.`fax`, `User`.`display_email`, `User`.`website`, `User`.`bio`, `User`.`notes`, `User`.`stature_id`, `User`.`learned_about_source_id`, `User`.`headshot_location`, `User`.`headshot`, `User`.`headshot_width`, `User`.`headshot_height`, `User`.`headshot_mimetype`, `User`.`mentor`, `User`.`mentee`, `User`.`p_a_d`, `User`.`public`, `User`.`lng`, `User`.`lat`, `User`.`doNotEmail`, `User`.`optin`, `User`.`optin_ip`, `User`.`optin_date`, `User`.`unsubscribed_date`, `PostCategory`.`id`, `PostCategory`.`name`, `PostCategory`.`fr`, `PostCategory`.`slug`, `PostCategory`.`section` FROM `quebecelan_LIVE_H`.`posts` AS `Post` LEFT JOIN `quebecelan_LIVE_H`.`users` AS `User` ON (`Post`.`user_id` = `User`.`id`) LEFT JOIN `quebecelan_LIVE_H`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `Post`.`id` = 4630 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Discipline`.`id`, `Discipline`.`name`, `Discipline`.`fr`, `Discipline`.`slug`, `DisciplinesPost`.`id`, `DisciplinesPost`.`post_id`, `DisciplinesPost`.`discipline_id` FROM `quebecelan_LIVE_H`.`disciplines` AS `Discipline` JOIN `quebecelan_LIVE_H`.`disciplines_posts` AS `DisciplinesPost` ON (`DisciplinesPost`.`post_id` = 4630 AND `DisciplinesPost`.`discipline_id` = `Discipline`.`id`) | 0 | 0 | 2 | maybe slow |
SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`slug`, `Tag`.`created`, `Tag`.`modified`, `TagsPost`.`id`, `TagsPost`.`tag_id`, `TagsPost`.`post_id` FROM `quebecelan_LIVE_H`.`tags` AS `Tag` JOIN `quebecelan_LIVE_H`.`tags_posts` AS `TagsPost` ON (`TagsPost`.`post_id` = 4630 AND `TagsPost`.`tag_id` = `Tag`.`id`) | 2 | 2 | 1 | maybe slow |