| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `User`.`id`, `User`.`slug`, `User`.`nickname`, `User`.`firstname`, `User`.`surname`, `User`.`fb_id`, `User`.`email`, `User`.`password`, `User`.`reset_key`, `User`.`getemails`, `User`.`getnewsletter`, `User`.`sex`, `User`.`dob`, `User`.`dobvisible`, `User`.`city`, `User`.`country_id`, `User`.`provider_id`, `User`.`mobile`, `User`.`favdj`, `User`.`favartist`, `User`.`favclub`, `User`.`occupation`, `User`.`twitter`, `User`.`meet`, `User`.`bio`, `User`.`cool`, `User`.`sitename`, `User`.`status`, `User`.`lastfeed`, `User`.`created`, `User`.`modified`, `User`.`vip`, `User`.`verified`, `User`.`hasThumb`, `User`.`promoter_seen`, (CONCAT(`User`.`surname`,", ", `User`.`firstname`)) AS `User__name`, (CONCAT(`User`.`firstname`," ", `User`.`surname`)) AS `User__fullname`, `Country`.`id`, `Country`.`iso2`, `Country`.`short_name`, `Country`.`long_name`, `Country`.`iso3`, `Country`.`numcode`, `Country`.`un_member`, `Country`.`calling_code`, `Country`.`cctld`, `Country`.`active` FROM `guestlist`.`guestlist_users` AS `User` LEFT JOIN `guestlist`.`guestlist_countries` AS `Country` ON (`User`.`country_id` = `Country`.`id`) WHERE `User`.`id` = 57399 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Relationship`.`id`, `Relationship`.`user_from`, `Relationship`.`user_to`, `Relationship`.`status`, `Relationship`.`relationship_type_id`, `Relationship`.`created`, `Relationship`.`modified` FROM `guestlist`.`guestlist_relationships` AS `Relationship` WHERE `Relationship`.`user_to` = (57399) | 0 | 0 | 0 | |
| SELECT `Article`.`approved`, `Article`.`user_id`, `Article`.`id`, `Article`.`title`, `Article`.`slug`, `Article`.`summary`, `Article`.`content`, `Article`.`created`, `Article`.`modified`, `User`.`firstname`, `User`.`surname`, `User`.`id` FROM `guestlist`.`guestlist_articles` AS `Article` LEFT JOIN `guestlist`.`guestlist_users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`user_id` = 57399 AND `Article`.`approved` = '1' AND `Article`.`alwaysvisible` = '1' ORDER BY `Article`.`created` DESC LIMIT 10 | 0 | 0 | 0 | |
| SELECT `Event`.`id`, `Event`.`name`, `Event`.`slug`, `Event`.`start`, `Event`.`end`, `Event`.`weekly`, `Event`.`live`, `Event`.`maindjs`, `Event`.`created`, `Venue`.`id`, `Venue`.`slug`, `Venue`.`name`, `Country`.`short_name`, `Country`.`id` FROM `guestlist`.`guestlist_events` AS `Event` LEFT JOIN `guestlist`.`guestlist_countries` AS `Country` ON (`Event`.`country_id` = `Country`.`id`) LEFT JOIN `guestlist`.`guestlist_venues` AS `Venue` ON (`Event`.`venue_id` = `Venue`.`id`) WHERE `Event`.`disabled` = 0 AND `Event`.`privacy` = '0' AND ((`Event`.`start` BETWEEN '2025-07-24 06:00:00' AND '2025-07-25 06:00:00') OR (`Event`.`weekly` = 4)) AND `Event`.`country_id` = 235 ORDER BY `Event`.`featured` DESC, `Event`.`weekly` ASC, `Event`.`start` ASC, `Event`.`end` ASC | 7 | 7 | 14 | maybe slow |
| SELECT `Genre`.`name`, `Genre`.`slug`, `EventsGenre`.`id`, `EventsGenre`.`event_id`, `EventsGenre`.`genre_id` FROM `guestlist`.`guestlist_genres` AS `Genre` JOIN `guestlist`.`guestlist_events_genres` AS `EventsGenre` ON (`EventsGenre`.`event_id` IN (9209, 9262, 8149, 10423, 10670, 8431, 5784) AND `EventsGenre`.`genre_id` = `Genre`.`id`) | 7 | 7 | 0 | |
| SELECT `Event`.`id`, `Event`.`name`, `Event`.`slug`, `Event`.`maindjs`, `Event`.`doorprice`, `Event`.`guestlistprice`, `Event`.`start`, `Event`.`end`, `Event`.`created`, `Venue`.`name`, `Venue`.`slug`, `Venue`.`id`, `EventBrand`.`id` FROM `guestlist`.`guestlist_events` AS `Event` LEFT JOIN `guestlist`.`guestlist_venues` AS `Venue` ON (`Event`.`venue_id` = `Venue`.`id`) LEFT JOIN `guestlist`.`guestlist_event_brands` AS `EventBrand` ON (`Event`.`event_brand_id` = `EventBrand`.`id`) WHERE `Event`.`user_id` = 57399 AND ((DATE(`Event`.`start`) = CURDATE()) OR (`Event`.`weekly` = 5)) ORDER BY `Event`.`featured` DESC, `Event`.`start` DESC, `Event`.`name` DESC LIMIT 10 | 0 | 0 | 11 | maybe slow |
| SELECT `Article`.`id`, `Article`.`created` FROM `guestlist`.`guestlist_article_views` AS `ArticleView` LEFT JOIN `guestlist`.`guestlist_articles` AS `Article` ON (`ArticleView`.`article_id` = `Article`.`id`) INNER JOIN `guestlist`.`guestlist_articles_countries` AS `ArticlesCountry` ON (`ArticleView`.`article_id` = `ArticlesCountry`.`article_id` AND `ArticlesCountry`.`country_id` = '235') INNER JOIN `guestlist`.`guestlist_users` AS `ShitPeople` ON (`Article`.`user_id` = `ShitPeople`.`id` AND NOT (`Article`.`user_id` = (88838))) WHERE `Article`.`alwaysvisible` = '1' AND `Article`.`approved` = '1' AND `ArticleView`.`created` between NOW() - INTERVAL 24 HOUR and NOW() AND `Article`.`user_id` = 57399 GROUP BY `ArticleView`.`article_id` ORDER BY count(*) DESC LIMIT 6 | 0 | 0 | 0 | |
| SELECT `Article`.`id`, `Article`.`created` FROM `guestlist`.`guestlist_article_views` AS `ArticleView` LEFT JOIN `guestlist`.`guestlist_articles` AS `Article` ON (`ArticleView`.`article_id` = `Article`.`id`) INNER JOIN `guestlist`.`guestlist_articles_countries` AS `ArticlesCountry` ON (`ArticleView`.`article_id` = `ArticlesCountry`.`article_id` AND `ArticlesCountry`.`country_id` = '235') INNER JOIN `guestlist`.`guestlist_users` AS `ShitPeople` ON (`Article`.`user_id` = `ShitPeople`.`id` AND NOT (`Article`.`user_id` = (88838))) LEFT JOIN `guestlist`.`guestlist_articles` AS `Arti` ON (`Arti`.`id` = `ArticleView`.`article_id`) INNER JOIN `guestlist`.`guestlist_articles_channels` AS `ArticlesChannel` ON (`ArticlesChannel`.`article_id` = `Arti`.`id`) INNER JOIN `guestlist`.`guestlist_channels` AS `Chan` ON (`Chan`.`id` = `ArticlesChannel`.`channel_id` AND `Chan`.`slug` = 'interviews') WHERE `Article`.`alwaysvisible` = '1' AND `Article`.`approved` = '1' AND `ArticleView`.`created` between NOW() - INTERVAL 24 HOUR and NOW() AND `Article`.`user_id` = 57399 GROUP BY `ArticleView`.`article_id` ORDER BY count(*) DESC LIMIT 6 | 0 | 0 | 0 | |
NEWS
EVENTS
