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 | 2 | maybe slow |
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 | 7 | maybe slow |
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 | 3 | maybe slow |
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 | 2 | maybe slow |
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-05 09:12:17'
AND Newspost.finished = 1
AND Newspost.spotlight = 1
AND Newsgroup.slug = 'frontpage'
ORDER BY Newspost.startdate DESC
LIMIT 4 | 4 | 4 | 7 | maybe slow |
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-05 09:12:17'
AND Newspost.finished = 1
AND Newspost.spotlight = 1
AND Newsgroup.slug = 'tournaments'
ORDER BY Newspost.startdate DESC
LIMIT 4 | 4 | 4 | 14 | maybe slow |
SELECT `Compo`.`id`, `Compo`.`name`, `Compo`.`steamGameId`, `Compo`.`nrPlayersTeam`, `Compo`.`maxTeams`, `Compo`.`compoTypeId`, `Compo`.`nrPoules`, `Compo`.`nrWinnersPoule`, `Compo`.`compoStateId`, `Compo`.`eventId`, `Compo`.`roundDE`, `Compo`.`addSecondaryFinal`, `Compo`.`adminId`, `Compo`.`adminId2`, `Compo`.`bannerUrl`, `Compo`.`description`, `Compo`.`tagId`, `Compo`.`allowDrawInPoule`, `Compo`.`nrLosersToBrackets`, `Compo`.`pauzed`, `Compo`.`rulebook`, `Compo`.`showsponsor`, `Compo`.`sponsorcontent`, `Compo`.`showfiles`, `Compo`.`filescontent`, `Compo`.`prizescontent`, `Compo`.`precompo`, `Compo`.`donations`, `Compo`.`donationAmount`, `Compo`.`schedule`, `Compo`.`faq`, `Compo`.`sponsorUrl`, `Compo`.`sponsorImg`, `Compo`.`sortTimeLabel`, `Admin`.`id`, `Admin`.`facebook_id`, `Admin`.`username`, `Admin`.`new_username`, `Admin`.`nickname`, `Admin`.`password`, `Admin`.`firstname`, `Admin`.`lastname`, `Admin`.`active`, `Admin`.`validationCode`, `Admin`.`mailValidationCode`, `Admin`.`group_id`, `Admin`.`created`, `Admin`.`modified`, `Admin`.`last_login`, `Admin`.`street`, `Admin`.`nr`, `Admin`.`bus`, `Admin`.`zip`, `Admin`.`city`, `Admin`.`country`, `Admin`.`phone`, `Admin`.`gsm`, `Admin`.`gender`, `Admin`.`birthdate`, `Admin`.`clanId`, `Admin`.`clantrust`, `Admin`.`clanjoinId`, `Admin`.`hwbudget`, `Admin`.`education`, `Admin`.`profession`, `Admin`.`hoursaweek`, `Admin`.`language`, `Admin`.`oldId`, `Admin`.`receive_newsletter`, `Admin`.`imageUrl`, `Admin`.`slug`, `Admin`.`fb_link`, `Admin`.`fb_location`, `Admin`.`CPU`, `Admin`.`MOBO`, `Admin`.`GFX`, `Admin`.`RAM`, `Admin`.`steamName`, `Admin`.`steamId`, `Admin`.`originName`, `Admin`.`lolSummonerName`, `Admin`.`Other`, `Admin`.`comment`, `Admin`.`seat_id`, `Admin`.`msg_notifications`, `Admin`.`mouseHand`, `Admin`.`deviceId`, `Admin`.`alternative_login`, `CompoState`.`id`, `CompoState`.`name` FROM `fom_site`.`compos` AS `Compo` LEFT JOIN `fom_site`.`users` AS `Admin` ON (`Compo`.`adminId` = `Admin`.`id`) LEFT JOIN `fom_site`.`compo_states` AS `CompoState` ON (`Compo`.`compoStateId` = `CompoState`.`id`) WHERE `Compo`.`id` = 377 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Teams`.`id`, `Teams`.`name`, `Teams`.`leaderId`, `Teams`.`compoId`, `Teams`.`pouleId`, `Teams`.`notes`, `Teams`.`withdrew` FROM `fom_site`.`teams` AS `Teams` WHERE `Teams`.`compoId` = (377) | 12 | 12 | 1 | maybe slow |
SELECT `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`.`users` AS `Leader` WHERE `Leader`.`id` = 6875 | 1 | 1 | 6 | maybe slow |
SELECT `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`.`users` AS `Leader` WHERE `Leader`.`id` = 9477 | 1 | 1 | 13 | maybe slow |
SELECT `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`.`users` AS `Leader` WHERE `Leader`.`id` = 5094 | 1 | 1 | 1 | |
SELECT `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`.`users` AS `Leader` WHERE `Leader`.`id` = 7594 | 1 | 1 | 1 | |
SELECT `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`.`users` AS `Leader` WHERE `Leader`.`id` = 9394 | 1 | 1 | 2 | maybe slow |
SELECT `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`.`users` AS `Leader` WHERE `Leader`.`id` = 8173 | 1 | 1 | 1 | |
SELECT `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`.`users` AS `Leader` WHERE `Leader`.`id` = 193 | 1 | 1 | 1 | |
SELECT `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`.`users` AS `Leader` WHERE `Leader`.`id` = 3216 | 1 | 1 | 0 | |
SELECT `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`.`users` AS `Leader` WHERE `Leader`.`id` = 2970 | 1 | 1 | 2 | maybe slow |
SELECT `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`.`users` AS `Leader` WHERE `Leader`.`id` = 6410 | 1 | 1 | 1 | |
SELECT `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`.`users` AS `Leader` WHERE `Leader`.`id` = 1295 | 1 | 1 | 3 | maybe slow |
SELECT `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`.`users` AS `Leader` WHERE `Leader`.`id` = 10181 | 1 | 1 | 1 | |
SELECT `Wars`.`id`, `Wars`.`screen1B`, `Wars`.`screen2B`, `Wars`.`screen3B`, `Wars`.`screen4B`, `Wars`.`bracketType`, `Wars`.`compoId`, `Wars`.`teamA`, `Wars`.`teamB`, `Wars`.`scoreAByA`, `Wars`.`scoreBByA`, `Wars`.`scoreAByB`, `Wars`.`scoreBByB`, `Wars`.`finalScoreA`, `Wars`.`finalScoreB`, `Wars`.`winnerWarId`, `Wars`.`loserWarId`, `Wars`.`pouleId`, `Wars`.`level`, `Wars`.`playable`, `Wars`.`mapname`, `Wars`.`time`, `Wars`.`screen1A`, `Wars`.`screen2A`, `Wars`.`screen3A`, `Wars`.`screen4A`, `Wars`.`prevTeamA`, `Wars`.`prevTeamB`, `Wars`.`screen1Admin`, `Wars`.`screen2Admin`, `Wars`.`adminEditID`, `Wars`.`adminEditDate`, `Wars`.`finalScoreDate` FROM `fom_site`.`wars` AS `Wars` WHERE `Wars`.`compoId` = (377) | 16 | 16 | 9 | maybe slow |
SELECT `Poule`.`id`, `Poule`.`compoId`, `Poule`.`name`, `Compo`.`id`, `Compo`.`name`, `Compo`.`steamGameId`, `Compo`.`nrPlayersTeam`, `Compo`.`maxTeams`, `Compo`.`compoTypeId`, `Compo`.`nrPoules`, `Compo`.`nrWinnersPoule`, `Compo`.`compoStateId`, `Compo`.`eventId`, `Compo`.`roundDE`, `Compo`.`addSecondaryFinal`, `Compo`.`adminId`, `Compo`.`adminId2`, `Compo`.`bannerUrl`, `Compo`.`description`, `Compo`.`tagId`, `Compo`.`allowDrawInPoule`, `Compo`.`nrLosersToBrackets`, `Compo`.`pauzed`, `Compo`.`rulebook`, `Compo`.`showsponsor`, `Compo`.`sponsorcontent`, `Compo`.`showfiles`, `Compo`.`filescontent`, `Compo`.`prizescontent`, `Compo`.`precompo`, `Compo`.`donations`, `Compo`.`donationAmount`, `Compo`.`schedule`, `Compo`.`faq`, `Compo`.`sponsorUrl`, `Compo`.`sponsorImg`, `Compo`.`sortTimeLabel` FROM `fom_site`.`poules` AS `Poule` LEFT JOIN `fom_site`.`compos` AS `Compo` ON (`Poule`.`compoId` = `Compo`.`id`) WHERE `Poule`.`compoId` = 377 ORDER BY `Poule`.`name` ASC | 0 | 0 | 5 | maybe slow |
SELECT COUNT(userId) as memberCount FROM `team_users` WHERE `teamId` = 10260 | 1 | 1 | 3 | maybe slow |
SELECT COUNT(userId) as memberCount FROM `team_users` WHERE `teamId` = 10372 | 1 | 1 | 2 | maybe slow |
SELECT COUNT(userId) as memberCount FROM `team_users` WHERE `teamId` = 10448 | 1 | 1 | 0 | |
SELECT COUNT(userId) as memberCount FROM `team_users` WHERE `teamId` = 10462 | 1 | 1 | 2 | maybe slow |
SELECT COUNT(userId) as memberCount FROM `team_users` WHERE `teamId` = 10476 | 1 | 1 | 0 | |
SELECT COUNT(userId) as memberCount FROM `team_users` WHERE `teamId` = 10505 | 1 | 1 | 0 | |
SELECT COUNT(userId) as memberCount FROM `team_users` WHERE `teamId` = 10510 | 1 | 1 | 0 | |
SELECT COUNT(userId) as memberCount FROM `team_users` WHERE `teamId` = 10515 | 1 | 1 | 0 | |
SELECT COUNT(userId) as memberCount FROM `team_users` WHERE `teamId` = 10517 | 1 | 1 | 2 | maybe slow |
SELECT COUNT(userId) as memberCount FROM `team_users` WHERE `teamId` = 10520 | 1 | 1 | 0 | |
SELECT COUNT(userId) as memberCount FROM `team_users` WHERE `teamId` = 10546 | 1 | 1 | 0 | |
SELECT COUNT(userId) as memberCount FROM `team_users` WHERE `teamId` = 10551 | 1 | 1 | 0 | |
SELECT `Ticket`.`id`, `Ticket`.`typeId`, `Ticket`.`refundable`, `Ticket`.`eventId`, `Ticket`.`buyerId`, `Ticket`.`ownerId`, `Ticket`.`productId`, `Ticket`.`orderId`, `Ticket`.`statusId`, `Ticket`.`ticketNumber`, `Ticket`.`checkindate`, `Ticket`.`createDate`, `Ticket`.`voucher`, `Ticket`.`checkInOperator`, `Ticket`.`wristbandCodeId`, `Ticket`.`voucherOperator`, `Ticket`.`voucherReason`, `Ticket`.`bbq`, `TicketState`.`id`, `TicketState`.`name`, `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`, `Buyer`.`id`, `Buyer`.`facebook_id`, `Buyer`.`username`, `Buyer`.`new_username`, `Buyer`.`nickname`, `Buyer`.`password`, `Buyer`.`firstname`, `Buyer`.`lastname`, `Buyer`.`active`, `Buyer`.`validationCode`, `Buyer`.`mailValidationCode`, `Buyer`.`group_id`, `Buyer`.`created`, `Buyer`.`modified`, `Buyer`.`last_login`, `Buyer`.`street`, `Buyer`.`nr`, `Buyer`.`bus`, `Buyer`.`zip`, `Buyer`.`city`, `Buyer`.`country`, `Buyer`.`phone`, `Buyer`.`gsm`, `Buyer`.`gender`, `Buyer`.`birthdate`, `Buyer`.`clanId`, `Buyer`.`clantrust`, `Buyer`.`clanjoinId`, `Buyer`.`hwbudget`, `Buyer`.`education`, `Buyer`.`profession`, `Buyer`.`hoursaweek`, `Buyer`.`language`, `Buyer`.`oldId`, `Buyer`.`receive_newsletter`, `Buyer`.`imageUrl`, `Buyer`.`slug`, `Buyer`.`fb_link`, `Buyer`.`fb_location`, `Buyer`.`CPU`, `Buyer`.`MOBO`, `Buyer`.`GFX`, `Buyer`.`RAM`, `Buyer`.`steamName`, `Buyer`.`steamId`, `Buyer`.`originName`, `Buyer`.`lolSummonerName`, `Buyer`.`Other`, `Buyer`.`comment`, `Buyer`.`seat_id`, `Buyer`.`msg_notifications`, `Buyer`.`mouseHand`, `Buyer`.`deviceId`, `Buyer`.`alternative_login`, `Owner`.`id`, `Owner`.`facebook_id`, `Owner`.`username`, `Owner`.`new_username`, `Owner`.`nickname`, `Owner`.`password`, `Owner`.`firstname`, `Owner`.`lastname`, `Owner`.`active`, `Owner`.`validationCode`, `Owner`.`mailValidationCode`, `Owner`.`group_id`, `Owner`.`created`, `Owner`.`modified`, `Owner`.`last_login`, `Owner`.`street`, `Owner`.`nr`, `Owner`.`bus`, `Owner`.`zip`, `Owner`.`city`, `Owner`.`country`, `Owner`.`phone`, `Owner`.`gsm`, `Owner`.`gender`, `Owner`.`birthdate`, `Owner`.`clanId`, `Owner`.`clantrust`, `Owner`.`clanjoinId`, `Owner`.`hwbudget`, `Owner`.`education`, `Owner`.`profession`, `Owner`.`hoursaweek`, `Owner`.`language`, `Owner`.`oldId`, `Owner`.`receive_newsletter`, `Owner`.`imageUrl`, `Owner`.`slug`, `Owner`.`fb_link`, `Owner`.`fb_location`, `Owner`.`CPU`, `Owner`.`MOBO`, `Owner`.`GFX`, `Owner`.`RAM`, `Owner`.`steamName`, `Owner`.`steamId`, `Owner`.`originName`, `Owner`.`lolSummonerName`, `Owner`.`Other`, `Owner`.`comment`, `Owner`.`seat_id`, `Owner`.`msg_notifications`, `Owner`.`mouseHand`, `Owner`.`deviceId`, `Owner`.`alternative_login`, `Operator`.`id`, `Operator`.`facebook_id`, `Operator`.`username`, `Operator`.`new_username`, `Operator`.`nickname`, `Operator`.`password`, `Operator`.`firstname`, `Operator`.`lastname`, `Operator`.`active`, `Operator`.`validationCode`, `Operator`.`mailValidationCode`, `Operator`.`group_id`, `Operator`.`created`, `Operator`.`modified`, `Operator`.`last_login`, `Operator`.`street`, `Operator`.`nr`, `Operator`.`bus`, `Operator`.`zip`, `Operator`.`city`, `Operator`.`country`, `Operator`.`phone`, `Operator`.`gsm`, `Operator`.`gender`, `Operator`.`birthdate`, `Operator`.`clanId`, `Operator`.`clantrust`, `Operator`.`clanjoinId`, `Operator`.`hwbudget`, `Operator`.`education`, `Operator`.`profession`, `Operator`.`hoursaweek`, `Operator`.`language`, `Operator`.`oldId`, `Operator`.`receive_newsletter`, `Operator`.`imageUrl`, `Operator`.`slug`, `Operator`.`fb_link`, `Operator`.`fb_location`, `Operator`.`CPU`, `Operator`.`MOBO`, `Operator`.`GFX`, `Operator`.`RAM`, `Operator`.`steamName`, `Operator`.`steamId`, `Operator`.`originName`, `Operator`.`lolSummonerName`, `Operator`.`Other`, `Operator`.`comment`, `Operator`.`seat_id`, `Operator`.`msg_notifications`, `Operator`.`mouseHand`, `Operator`.`deviceId`, `Operator`.`alternative_login`, `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`description`, `Product`.`imageUrl`, `Product`.`priceExclVat`, `Product`.`priceInclVat`, `Product`.`vatId`, `Product`.`offeredFrom`, `Product`.`offeredUntil`, `Product`.`stock`, `Product`.`totalItems`, `Product`.`productTypeId`, `Product`.`productCategory`, `Product`.`eventId`, `Product`.`active`, `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`, `Type`.`id`, `Type`.`name` FROM `fom_site`.`tickets` AS `Ticket` LEFT JOIN `fom_site`.`ticket_states` AS `TicketState` ON (`Ticket`.`statusId` = `TicketState`.`id`) LEFT JOIN `fom_site`.`events` AS `Event` ON (`Ticket`.`eventId` = `Event`.`id`) LEFT JOIN `fom_site`.`users` AS `Buyer` ON (`Ticket`.`buyerId` = `Buyer`.`id`) LEFT JOIN `fom_site`.`users` AS `Owner` ON (`Ticket`.`ownerId` = `Owner`.`id`) LEFT JOIN `fom_site`.`users` AS `Operator` ON (`Ticket`.`voucherOperator` = `Operator`.`id`) LEFT JOIN `fom_site`.`products` AS `Product` ON (`Ticket`.`productId` = `Product`.`id`) LEFT JOIN `fom_site`.`orders` AS `Order` ON (`Ticket`.`orderId` = `Order`.`id`) LEFT JOIN `fom_site`.`ticket_types` AS `Type` ON (`Ticket`.`typeId` = `Type`.`id`) WHERE `Ticket`.`ownerId` IS NULL AND `Ticket`.`eventId` = 49 AND NOT (`Ticket`.`statusId` = 4) AND `Ticket`.`typeId` IN (1, 4, 7, 8) ORDER BY `Ticket`.`id` ASC LIMIT 1 | 1 | 1 | 14 | maybe slow |
SELECT roundDE from compos where id = 377 | 1 | 1 | 0 | |
SELECT War.*, TeamA.*, TeamB.*
FROM wars AS War
LEFT JOIN teams AS TeamA ON (War.teamA = TeamA.id)
LEFT JOIN teams AS TeamB ON (War.teamB = TeamB.id)
WHERE War.compoId = 377
AND War.pouleId IS NULL
ORDER BY War.bracketType ASC, War.level, War.id | 16 | 16 | 0 | |
SELECT MAX(level) AS MaxLevel FROM wars where compoId = 377 | 1 | 1 | 3 | maybe slow |