Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `MenuItem`.`id`, `MenuItem`.`title`, `MenuItem`.`type`, `MenuItem`.`link`, `MenuItem`.`layout`, `MenuItem`.`enabled` FROM `fom_site`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`enabled` = '1' | 5 | 5 | 0 | |
SELECT `MenuSubItem`.`id`, `MenuSubItem`.`menu_item_id`, `MenuSubItem`.`title`, `MenuSubItem`.`layout_position`, `MenuSubItem`.`enabled` FROM `fom_site`.`menu_sub_items` AS `MenuSubItem` WHERE `MenuSubItem`.`enabled` = '1' AND `MenuSubItem`.`menu_item_id` IN (1, 2, 3, 4, 5) | 9 | 9 | 0 | |
SELECT `MenuLink`.`id`, `MenuLink`.`menu_sub_item_id`, `MenuLink`.`title`, `MenuLink`.`url`, `MenuLink`.`link_type`, `MenuLink`.`internal_compo_id`, `MenuLink`.`internal_newspost_id`, `MenuLink`.`internal_content_id`, `MenuLink`.`target`, `MenuLink`.`image`, `MenuLink`.`position`, `MenuLink`.`enabled` FROM `fom_site`.`menu_links` AS `MenuLink` WHERE `MenuLink`.`enabled` = '1' AND `MenuLink`.`menu_sub_item_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9) | 35 | 35 | 0 | |
SELECT `Config`.`id`, `Config`.`currentEvent`, `Config`.`contactEmail`, `Config`.`technicalContactEmail`, `Config`.`organisationStreet`, `Config`.`organisationNr`, `Config`.`organisationZip`, `Config`.`organisationCity`, `Config`.`organisationCountry`, `Config`.`organisationWebsite`, `Config`.`organisationName`, `Config`.`vatNr`, `Config`.`bankAccount`, `Config`.`bic`, `Config`.`iban`, `Config`.`paypal`, `Config`.`cartLifeTime`, `Config`.`orderLifeTime`, `Config`.`orderWarningTime`, `Config`.`defaultNoProductImage`, `Config`.`defaultNoProductOutImage`, `Config`.`defaultNoUserImage`, `Config`.`ticketsCounterFrontpageOffset`, `Config`.`ticketsCounterFrontpageFixed`, `Config`.`ticketsCounterFrontpageOption`, `Config`.`compoWarTracker`, `Config`.`maxTicketInCart`, `Event`.`id`, `Event`.`name`, `Event`.`description`, `Event`.`starttime`, `Event`.`endtime`, `Event`.`location`, `Event`.`street`, `Event`.`nr`, `Event`.`bus`, `Event`.`zip`, `Event`.`city`, `Event`.`country`, `Event`.`slug`, `Event`.`oldId`, `Event`.`nrParticipants`, `Event`.`bbq`, `Event`.`usedHal` FROM `fom_site`.`configs` AS `Config` LEFT JOIN `fom_site`.`events` AS `Event` ON (`Config`.`currentEvent` = `Event`.`id`) WHERE `Config`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Config`.`id`, `Config`.`currentEvent`, `Config`.`contactEmail`, `Config`.`technicalContactEmail`, `Config`.`organisationStreet`, `Config`.`organisationNr`, `Config`.`organisationZip`, `Config`.`organisationCity`, `Config`.`organisationCountry`, `Config`.`organisationWebsite`, `Config`.`organisationName`, `Config`.`vatNr`, `Config`.`bankAccount`, `Config`.`bic`, `Config`.`iban`, `Config`.`paypal`, `Config`.`cartLifeTime`, `Config`.`orderLifeTime`, `Config`.`orderWarningTime`, `Config`.`defaultNoProductImage`, `Config`.`defaultNoProductOutImage`, `Config`.`defaultNoUserImage`, `Config`.`ticketsCounterFrontpageOffset`, `Config`.`ticketsCounterFrontpageFixed`, `Config`.`ticketsCounterFrontpageOption`, `Config`.`compoWarTracker`, `Config`.`maxTicketInCart`, `Event`.`id`, `Event`.`name`, `Event`.`description`, `Event`.`starttime`, `Event`.`endtime`, `Event`.`location`, `Event`.`street`, `Event`.`nr`, `Event`.`bus`, `Event`.`zip`, `Event`.`city`, `Event`.`country`, `Event`.`slug`, `Event`.`oldId`, `Event`.`nrParticipants`, `Event`.`bbq`, `Event`.`usedHal` FROM `fom_site`.`configs` AS `Config` LEFT JOIN `fom_site`.`events` AS `Event` ON (`Config`.`currentEvent` = `Event`.`id`) WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Event`.`id`, `Event`.`name`, `Event`.`description`, `Event`.`starttime`, `Event`.`endtime`, `Event`.`location`, `Event`.`street`, `Event`.`nr`, `Event`.`bus`, `Event`.`zip`, `Event`.`city`, `Event`.`country`, `Event`.`slug`, `Event`.`oldId`, `Event`.`nrParticipants`, `Event`.`bbq`, `Event`.`usedHal` FROM `fom_site`.`events` AS `Event` WHERE `Event`.`id` = 49 LIMIT 1 | 1 | 1 | 0 | |
SELECT count(Ticket.id) AS amount
FROM `tickets` AS Ticket
LEFT JOIN `products` AS `Product` ON Product.id = Ticket.productId
WHERE Ticket.eventId=49 AND (Product.productTypeId = 1 OR Product.productTypeId = 4)
AND Ticket.statusId != 4
AND Ticket.`typeId` IN (1,3,4,6,7,8)
| 1 | 1 | 1 | |
SELECT Orderline.quantity
FROM orderlines AS Orderline
LEFT JOIN products AS Product ON (Product.id = Orderline.productId)
LEFT JOIN orders AS Orders ON (Orders.id = Orderline.orderId)
WHERE Product.eventId = 49
AND Orders.orderstateId IN (2,3,5,6)
AND Product.productTypeId IN (1, 4)
AND Product.productCategory = 1 | 177 | 177 | 1 | |
SELECT count(Ticket.id) AS amount
FROM `tickets` AS Ticket
LEFT JOIN `products` AS `Product` ON Product.id = Ticket.productId
WHERE Ticket.eventId=49 AND (Product.productTypeId = 1 OR Product.productTypeId = 4)
AND Ticket.statusId != 4
AND Ticket.`typeId` = (8)
| 1 | 1 | 0 | |
SELECT `Order`.`id`, `Order`.`defaultPaymentProviderId`, `Order`.`orderStateId`, `Order`.`refundable`, `Order`.`memberId`, `Order`.`orderDate`, `Order`.`orderDueDate`, `Order`.`totalPriceIncVat`, `Order`.`orderNumber`, `Order`.`notes`, `Order`.`orderWarningSent`, `Order`.`orderWarningDate`, `Order`.`paypal_verification`, `Order`.`transactionFee`, `Orderstate`.`id`, `Orderstate`.`name`, `Customer`.`id`, `Customer`.`facebook_id`, `Customer`.`username`, `Customer`.`new_username`, `Customer`.`nickname`, `Customer`.`password`, `Customer`.`firstname`, `Customer`.`lastname`, `Customer`.`active`, `Customer`.`validationCode`, `Customer`.`mailValidationCode`, `Customer`.`group_id`, `Customer`.`created`, `Customer`.`modified`, `Customer`.`last_login`, `Customer`.`street`, `Customer`.`nr`, `Customer`.`bus`, `Customer`.`zip`, `Customer`.`city`, `Customer`.`country`, `Customer`.`phone`, `Customer`.`gsm`, `Customer`.`gender`, `Customer`.`birthdate`, `Customer`.`clanId`, `Customer`.`clantrust`, `Customer`.`clanjoinId`, `Customer`.`hwbudget`, `Customer`.`education`, `Customer`.`profession`, `Customer`.`hoursaweek`, `Customer`.`language`, `Customer`.`oldId`, `Customer`.`receive_newsletter`, `Customer`.`imageUrl`, `Customer`.`slug`, `Customer`.`fb_link`, `Customer`.`fb_location`, `Customer`.`CPU`, `Customer`.`MOBO`, `Customer`.`GFX`, `Customer`.`RAM`, `Customer`.`steamName`, `Customer`.`steamId`, `Customer`.`originName`, `Customer`.`lolSummonerName`, `Customer`.`Other`, `Customer`.`comment`, `Customer`.`seat_id`, `Customer`.`msg_notifications`, `Customer`.`mouseHand`, `Customer`.`deviceId`, `Customer`.`alternative_login`, `DefaultProvider`.`id`, `DefaultProvider`.`name`, `DefaultProvider`.`description`, `DefaultProvider`.`transactionFeeFixed`, `DefaultProvider`.`transactionFeeVariable` FROM `fom_site`.`orders` AS `Order` LEFT JOIN `fom_site`.`orderstates` AS `Orderstate` ON (`Order`.`orderStateId` = `Orderstate`.`id`) LEFT JOIN `fom_site`.`users` AS `Customer` ON (`Order`.`memberId` = `Customer`.`id`) LEFT JOIN `fom_site`.`payment_providers` AS `DefaultProvider` ON (`Order`.`defaultPaymentProviderId` = `DefaultProvider`.`id`) WHERE `memberId` IS NULL AND `orderStateId` = 1 LIMIT 1 | 0 | 0 | 0 | |
SELECT Newspost.id, Newspost.title_en, Newspost.title_nl, Newspost.imageUrl, Newspost.spotlightImgUrl, Newspost.slug, Newspost.startDate, Newspost.spotlight, Maintag.bannerUrl
FROM newsposts AS Newspost
LEFT JOIN tags AS Maintag ON (Newspost.newsTagId = Maintag.id)
INNER JOIN newsxgroup AS Newsxgroup ON (Newspost.id = Newsxgroup.newsId)
INNER JOIN newsgroups As Newsgroup ON (Newsxgroup.newsgroupId = Newsgroup.Id)
WHERE Newspost.startDate < '2025-08-10 21:54:41'
AND Newspost.finished = 1
AND Newspost.spotlight = 1
AND Newsgroup.slug = 'frontpage'
ORDER BY Newspost.startdate DESC
LIMIT 4 | 4 | 4 | 4 | |
SELECT Newspost.id, Newspost.title_en, Newspost.title_nl, Newspost.imageUrl, Newspost.spotlightImgUrl, Newspost.slug, Newspost.startDate, Newspost.spotlight, Maintag.bannerUrl, Maintag.tagName, Maintag.slug, Maintag.color
FROM newsposts AS Newspost
LEFT JOIN tags AS Maintag ON (Newspost.newsTagId = Maintag.id)
INNER JOIN newsxgroup AS Newsxgroup ON (Newspost.id = Newsxgroup.newsId)
INNER JOIN newsgroups As Newsgroup ON (Newsxgroup.newsgroupId = Newsgroup.Id)
WHERE Newspost.startDate < '2025-08-10 21:54:41'
AND Newspost.finished = 1
AND Newspost.spotlight = 1
AND Newsgroup.slug = 'tournaments'
ORDER BY Newspost.startdate DESC
LIMIT 4 | 4 | 4 | 1 | maybe slow |
SELECT `Newspost`.`authorId`, `Newspost`.`id`, `Newspost`.`startdate`, `Newspost`.`enddate`, `Newspost`.`title_nl`, `Newspost`.`title_en`, `Newspost`.`article_nl`, `Newspost`.`article_en`, `Newspost`.`imageUrl`, `Newspost`.`finished`, `Newspost`.`reactions`, `Newspost`.`newsTagId`, `Newspost`.`slug`, `Newspost`.`spotlight`, `Newspost`.`spotlightImgUrl`, `Newspost`.`views`, `Author`.`id`, `Author`.`facebook_id`, `Author`.`username`, `Author`.`new_username`, `Author`.`nickname`, `Author`.`password`, `Author`.`firstname`, `Author`.`lastname`, `Author`.`active`, `Author`.`validationCode`, `Author`.`mailValidationCode`, `Author`.`group_id`, `Author`.`created`, `Author`.`modified`, `Author`.`last_login`, `Author`.`street`, `Author`.`nr`, `Author`.`bus`, `Author`.`zip`, `Author`.`city`, `Author`.`country`, `Author`.`phone`, `Author`.`gsm`, `Author`.`gender`, `Author`.`birthdate`, `Author`.`clanId`, `Author`.`clantrust`, `Author`.`clanjoinId`, `Author`.`hwbudget`, `Author`.`education`, `Author`.`profession`, `Author`.`hoursaweek`, `Author`.`language`, `Author`.`oldId`, `Author`.`receive_newsletter`, `Author`.`imageUrl`, `Author`.`slug`, `Author`.`fb_link`, `Author`.`fb_location`, `Author`.`CPU`, `Author`.`MOBO`, `Author`.`GFX`, `Author`.`RAM`, `Author`.`steamName`, `Author`.`steamId`, `Author`.`originName`, `Author`.`lolSummonerName`, `Author`.`Other`, `Author`.`comment`, `Author`.`seat_id`, `Author`.`msg_notifications`, `Author`.`mouseHand`, `Author`.`deviceId`, `Author`.`alternative_login`, `Maintag`.`id`, `Maintag`.`tagName`, `Maintag`.`bannerUrl`, `Maintag`.`parentId`, `Maintag`.`slug`, `Maintag`.`color` FROM `fom_site`.`newsposts` AS `Newspost` LEFT JOIN `fom_site`.`users` AS `Author` ON (`Newspost`.`authorId` = `Author`.`id`) LEFT JOIN `fom_site`.`tags` AS `Maintag` ON (`Newspost`.`newsTagId` = `Maintag`.`id`) WHERE `Newspost`.`slug` = 'tetris-attack-download-link-change' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Reactions`.`id`, `Reactions`.`newsId`, `Reactions`.`memberId`, `Reactions`.`reaction`, `Reactions`.`enabled`, `Reactions`.`date` FROM `fom_site`.`newsreactions` AS `Reactions` WHERE `Reactions`.`enabled` = '1' AND `Reactions`.`newsId` = (968) | 1 | 1 | 0 | |
SELECT `Tags`.`id`, `Tags`.`tagName`, `Tags`.`bannerUrl`, `Tags`.`parentId`, `Tags`.`slug`, `Tags`.`color`, `Newstag`.`id`, `Newstag`.`newsId`, `Newstag`.`tagId` FROM `fom_site`.`tags` AS `Tags` JOIN `fom_site`.`newstags` AS `Newstag` ON (`Newstag`.`newsId` = 968 AND `Newstag`.`tagId` = `Tags`.`id`) | 3 | 3 | 0 | |
SELECT `Newsgroups`.`id`, `Newsgroups`.`newsgroupName`, `Newsgroups`.`slug`, `Newsxgroup`.`id`, `Newsxgroup`.`newsId`, `Newsxgroup`.`newsgroupId` FROM `fom_site`.`newsgroups` AS `Newsgroups` JOIN `fom_site`.`newsxgroup` AS `Newsxgroup` ON (`Newsxgroup`.`newsId` = 968 AND `Newsxgroup`.`newsgroupId` = `Newsgroups`.`id`) | 1 | 1 | 0 | |
SELECT `User`.`id`, `User`.`facebook_id`, `User`.`username`, `User`.`new_username`, `User`.`nickname`, `User`.`password`, `User`.`firstname`, `User`.`lastname`, `User`.`active`, `User`.`validationCode`, `User`.`mailValidationCode`, `User`.`group_id`, `User`.`created`, `User`.`modified`, `User`.`last_login`, `User`.`street`, `User`.`nr`, `User`.`bus`, `User`.`zip`, `User`.`city`, `User`.`country`, `User`.`phone`, `User`.`gsm`, `User`.`gender`, `User`.`birthdate`, `User`.`clanId`, `User`.`clantrust`, `User`.`clanjoinId`, `User`.`hwbudget`, `User`.`education`, `User`.`profession`, `User`.`hoursaweek`, `User`.`language`, `User`.`oldId`, `User`.`receive_newsletter`, `User`.`imageUrl`, `User`.`slug`, `User`.`fb_link`, `User`.`fb_location`, `User`.`CPU`, `User`.`MOBO`, `User`.`GFX`, `User`.`RAM`, `User`.`steamName`, `User`.`steamId`, `User`.`originName`, `User`.`lolSummonerName`, `User`.`Other`, `User`.`comment`, `User`.`seat_id`, `User`.`msg_notifications`, `User`.`mouseHand`, `User`.`deviceId`, `User`.`alternative_login`, `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Clan`.`id`, `Clan`.`leaderId`, `Clan`.`name`, `Clan`.`tag`, `Clan`.`website`, `Clan`.`logo`, `Clan`.`game_id`, `Clan`.`mem_id`, `Clan`.`game_name`, `Clan`.`preference`, `Clan`.`inactive` FROM `fom_site`.`users` AS `User` LEFT JOIN `fom_site`.`groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) LEFT JOIN `fom_site`.`clans` AS `Clan` ON (`User`.`clanId` = `Clan`.`id`) WHERE `User`.`id` = 7468 LIMIT 1 | 1 | 1 | 0 | |
SELECT `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `fom_site`.`social_profiles` AS `SocialProfile` WHERE `SocialProfile`.`user_id` = (7468) | 3 | 3 | 1 | maybe slow |
SELECT COUNT(*) AS `count` FROM `fom_site`.`newsposts` AS `Newspost` WHERE `Newspost`.`id` = 968 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `fom_site`.`newsposts` AS `Newspost` WHERE `Newspost`.`id` = 968 | 1 | 1 | 0 | |
UPDATE `fom_site`.`newsposts` SET `views` = 1748 WHERE `fom_site`.`newsposts`.`id` = '968' | 1 | 1 | 1 | |
SELECT `Ticket`.`id` FROM `fom_site`.`tickets` AS `Ticket` WHERE `ownerId` = 7468 AND `eventId` = 49 ORDER BY `id` DESC | 0 | 0 | 1 | maybe slow |
SELECT `Clan`.`id`, `Clan`.`leaderId`, `Clan`.`name`, `Clan`.`tag`, `Clan`.`website`, `Clan`.`logo`, `Clan`.`game_id`, `Clan`.`mem_id`, `Clan`.`game_name`, `Clan`.`preference`, `Clan`.`inactive`, `Leader`.`id`, `Leader`.`facebook_id`, `Leader`.`username`, `Leader`.`new_username`, `Leader`.`nickname`, `Leader`.`password`, `Leader`.`firstname`, `Leader`.`lastname`, `Leader`.`active`, `Leader`.`validationCode`, `Leader`.`mailValidationCode`, `Leader`.`group_id`, `Leader`.`created`, `Leader`.`modified`, `Leader`.`last_login`, `Leader`.`street`, `Leader`.`nr`, `Leader`.`bus`, `Leader`.`zip`, `Leader`.`city`, `Leader`.`country`, `Leader`.`phone`, `Leader`.`gsm`, `Leader`.`gender`, `Leader`.`birthdate`, `Leader`.`clanId`, `Leader`.`clantrust`, `Leader`.`clanjoinId`, `Leader`.`hwbudget`, `Leader`.`education`, `Leader`.`profession`, `Leader`.`hoursaweek`, `Leader`.`language`, `Leader`.`oldId`, `Leader`.`receive_newsletter`, `Leader`.`imageUrl`, `Leader`.`slug`, `Leader`.`fb_link`, `Leader`.`fb_location`, `Leader`.`CPU`, `Leader`.`MOBO`, `Leader`.`GFX`, `Leader`.`RAM`, `Leader`.`steamName`, `Leader`.`steamId`, `Leader`.`originName`, `Leader`.`lolSummonerName`, `Leader`.`Other`, `Leader`.`comment`, `Leader`.`seat_id`, `Leader`.`msg_notifications`, `Leader`.`mouseHand`, `Leader`.`deviceId`, `Leader`.`alternative_login` FROM `fom_site`.`clans` AS `Clan` LEFT JOIN `fom_site`.`users` AS `Leader` ON (`Clan`.`leaderId` = `Leader`.`id`) WHERE `Clan`.`id` = 4957 LIMIT 1 | 1 | 1 | 0 | |