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 | 4 | maybe slow |
SELECT `MembershipFee`.`user_id` FROM `quebecelan_LIVE_H`.`membership_fees` AS `MembershipFee` WHERE `MembershipFee`.`date_paid` < '2018-04-22 00:00:01' AND `MembershipFee`.`renewal_date` > '2018-04-22 23:59:59' | 165 | 165 | 0 | |
SELECT `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`, `Region`.`id`, `Region`.`name`, `Region`.`lat`, `Region`.`long`, `Region`.`zoomlvl`, `Province`.`id`, `Province`.`iso_code`, `Province`.`name`, `Stature`.`id`, `Stature`.`name`, `Stature`.`name_fr`, `LearnedAboutSource`.`id`, `LearnedAboutSource`.`name` FROM `quebecelan_LIVE_H`.`users` AS `User` LEFT JOIN `quebecelan_LIVE_H`.`regions` AS `Region` ON (`User`.`region_id` = `Region`.`id`) LEFT JOIN `quebecelan_LIVE_H`.`provinces` AS `Province` ON (`User`.`province_id` = `Province`.`id`) LEFT JOIN `quebecelan_LIVE_H`.`statures` AS `Stature` ON (`User`.`stature_id` = `Stature`.`id`) LEFT JOIN `quebecelan_LIVE_H`.`learned_about_sources` AS `LearnedAboutSource` ON (`User`.`learned_about_source_id` = `LearnedAboutSource`.`id`) WHERE `User`.`id` = 4383 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Event`.`id`, `Event`.`created`, `Event`.`modified`, `Event`.`visible`, `Event`.`enabled`, `Event`.`user_id`, `Event`.`event_type_id`, `Event`.`title`, `Event`.`description`, `Event`.`description_fr`, `Event`.`date_from`, `Event`.`date_to`, `Event`.`admission`, `Event`.`location`, `Event`.`region_id`, `Event`.`contact_name`, `Event`.`contact_email`, `Event`.`contact_telephone`, `Event`.`contact_website`, `Event`.`Mon`, `Event`.`Tue`, `Event`.`Wed`, `Event`.`Thu`, `Event`.`Fri`, `Event`.`Sat`, `Event`.`Sun`, `Event`.`venue_id` FROM `quebecelan_LIVE_H`.`events` AS `Event` WHERE `Event`.`user_id` = (4383) ORDER BY `Event`.`created` DESC | 0 | 0 | 1 | maybe slow |
SELECT `Expansion`.`id`, `Expansion`.`history_id`, `Expansion`.`user_id`, `Expansion`.`comment`, `Expansion`.`expansiontype_id`, `Expansion`.`selection` FROM `quebecelan_LIVE_H`.`expansions` AS `Expansion` WHERE `Expansion`.`user_id` = (4383) | 0 | 0 | 0 | |
SELECT `MembershipFee`.`id`, `MembershipFee`.`user_id`, `MembershipFee`.`membership_fee_type_id`, `MembershipFee`.`amount`, `MembershipFee`.`date_paid`, `MembershipFee`.`renewal_date`, `MembershipFee`.`notes`, `MembershipFee`.`date_mailed`, `MembershipFee`.`txn_id` FROM `quebecelan_LIVE_H`.`membership_fees` AS `MembershipFee` WHERE `MembershipFee`.`user_id` = (4383) ORDER BY `MembershipFee`.`renewal_date` desc | 2 | 2 | 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` FROM `quebecelan_LIVE_H`.`posts` AS `Post` WHERE `Post`.`user_id` = (4383) ORDER BY `Post`.`created` DESC | 0 | 0 | 1 | maybe slow |
SELECT `Showcase`.`id`, `Showcase`.`created`, `Showcase`.`modified`, `Showcase`.`visible`, `Showcase`.`enabled`, `Showcase`.`user_id`, `Showcase`.`date_work_created`, `Showcase`.`lang`, `Showcase`.`media_type_id`, `Showcase`.`video_embed`, `Showcase`.`title`, `Showcase`.`slug`, `Showcase`.`tags`, `Showcase`.`summary`, `Showcase`.`description`, `Showcase`.`publisher`, `Showcase`.`contributor`, `Showcase`.`website`, `Showcase`.`copyright`, `Showcase`.`checksum`, `Showcase`.`directory`, `Showcase`.`location`, `Showcase`.`basename`, `Showcase`.`embed`, `Showcase`.`thumbnail`, `Showcase`.`width`, `Showcase`.`height`, `Showcase`.`mimetype`, `Showcase`.`filesize`, `Showcase`.`duration`, `Showcase`.`address`, `Showcase`.`city`, `Showcase`.`postal_code`, `Showcase`.`venue_id`, `Showcase`.`lng`, `Showcase`.`lat` FROM `quebecelan_LIVE_H`.`showcases` AS `Showcase` WHERE `Showcase`.`user_id` = (4383) ORDER BY `Showcase`.`created` DESC | 0 | 0 | 2 | maybe slow |
SELECT `ComExcerpt`.`id`, `ComExcerpt`.`name`, `ComExcerpt`.`user_id`, `ComExcerpt`.`com_excerpt_type_id`, `ComExcerpt`.`com_media_source_id`, `ComExcerpt`.`in_home_page`, `ComExcerpt`.`in_discipline_page`, `ComExcerpt`.`publish_live`, `ComExcerpt`.`url_preview`, `ComExcerpt`.`audio`, `ComExcerpt`.`audio-url`, `ComExcerpt`.`link`, `ComExcerpt`.`created`, `ComExcerpt`.`modified`, `ComExcerpt`.`com_discipline_id`, `ComExcerpt`.`title_en`, `ComExcerpt`.`title_fr`, `ComExcerpt`.`intro_en`, `ComExcerpt`.`intro_fr`, `ComExcerpt`.`video`, `ComExcerpt`.`video-url`, `ComExcerpt`.`photos` FROM `quebecelan_LIVE_H`.`com_excerpts` AS `ComExcerpt` WHERE `ComExcerpt`.`user_id` = (4383) | 0 | 0 | 1 | maybe slow |
SELECT `ComMediaArticle`.`id`, `ComMediaArticle`.`com_media_source_id`, `ComMediaArticle`.`user_id`, `ComMediaArticle`.`publication_date`, `ComMediaArticle`.`publish_live`, `ComMediaArticle`.`intro_en`, `ComMediaArticle`.`intro_fr`, `ComMediaArticle`.`url`, `ComMediaArticle`.`url_preview`, `ComMediaArticle`.`created`, `ComMediaArticle`.`modified`, `ComMediaArticle`.`com_discipline_id`, `ComMediaArticle`.`title_en`, `ComMediaArticle`.`title_fr`, `ComMediaArticle`.`in_home_page`, `ComMediaArticle`.`in_discipline_page` FROM `quebecelan_LIVE_H`.`com_media_articles` AS `ComMediaArticle` WHERE `ComMediaArticle`.`user_id` = (4383) | 0 | 0 | 3 | maybe slow |
SELECT `Ticket`.`id`, `Ticket`.`hash`, `Ticket`.`user_id`, `Ticket`.`created`, `Ticket`.`modified` FROM `quebecelan_LIVE_H`.`tickets` AS `Ticket` WHERE `Ticket`.`user_id` = (4383) | 0 | 0 | 0 | |
SELECT `Discipline`.`id`, `Discipline`.`name`, `Discipline`.`fr`, `Discipline`.`slug`, `DisciplinesUser`.`id`, `DisciplinesUser`.`discipline_id`, `DisciplinesUser`.`user_id` FROM `quebecelan_LIVE_H`.`disciplines` AS `Discipline` JOIN `quebecelan_LIVE_H`.`disciplines_users` AS `DisciplinesUser` ON (`DisciplinesUser`.`user_id` = 4383 AND `DisciplinesUser`.`discipline_id` = `Discipline`.`id`) | 1 | 1 | 1 | |
SELECT `UserType`.`id`, `UserType`.`model`, `UserType`.`controller`, `UserType`.`price`, `UserTypesUser`.`id`, `UserTypesUser`.`user_type_id`, `UserTypesUser`.`user_id` FROM `quebecelan_LIVE_H`.`user_types` AS `UserType` JOIN `quebecelan_LIVE_H`.`user_types_users` AS `UserTypesUser` ON (`UserTypesUser`.`user_id` = 4383 AND `UserTypesUser`.`user_type_id` = `UserType`.`id`) | 1 | 1 | 1 | |