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-05 16:58:44'
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-05 16:58:44'
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 `Team`.`id`, `Team`.`name`, `Team`.`leaderId`, `Team`.`compoId`, `Team`.`pouleId`, `Team`.`notes`, `Team`.`withdrew`, `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`, `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`, `Poule`.`id`, `Poule`.`compoId`, `Poule`.`name` FROM `fom_site`.`teams` AS `Team` LEFT JOIN `fom_site`.`compos` AS `Compo` ON (`Team`.`compoId` = `Compo`.`id`) LEFT JOIN `fom_site`.`users` AS `Leader` ON (`Team`.`leaderId` = `Leader`.`id`) LEFT JOIN `fom_site`.`poules` AS `Poule` ON (`Team`.`pouleId` = `Poule`.`id`) WHERE `Team`.`id` = 10439 ORDER BY `Team`.`id` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Members`.`id`, `Members`.`facebook_id`, `Members`.`username`, `Members`.`new_username`, `Members`.`nickname`, `Members`.`password`, `Members`.`firstname`, `Members`.`lastname`, `Members`.`active`, `Members`.`validationCode`, `Members`.`mailValidationCode`, `Members`.`group_id`, `Members`.`created`, `Members`.`modified`, `Members`.`last_login`, `Members`.`street`, `Members`.`nr`, `Members`.`bus`, `Members`.`zip`, `Members`.`city`, `Members`.`country`, `Members`.`phone`, `Members`.`gsm`, `Members`.`gender`, `Members`.`birthdate`, `Members`.`clanId`, `Members`.`clantrust`, `Members`.`clanjoinId`, `Members`.`hwbudget`, `Members`.`education`, `Members`.`profession`, `Members`.`hoursaweek`, `Members`.`language`, `Members`.`oldId`, `Members`.`receive_newsletter`, `Members`.`imageUrl`, `Members`.`slug`, `Members`.`fb_link`, `Members`.`fb_location`, `Members`.`CPU`, `Members`.`MOBO`, `Members`.`GFX`, `Members`.`RAM`, `Members`.`steamName`, `Members`.`steamId`, `Members`.`originName`, `Members`.`lolSummonerName`, `Members`.`Other`, `Members`.`comment`, `Members`.`seat_id`, `Members`.`msg_notifications`, `Members`.`mouseHand`, `Members`.`deviceId`, `Members`.`alternative_login`, `TeamUser`.`id`, `TeamUser`.`teamId`, `TeamUser`.`userId`, `TeamUser`.`date` FROM `fom_site`.`users` AS `Members` JOIN `fom_site`.`team_users` AS `TeamUser` ON (`TeamUser`.`teamId` = 10439 AND `TeamUser`.`userId` = `Members`.`id`) | 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`.`eventId` = 46 AND `Ticket`.`ownerId` = 10085 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Seat`.`id`, `Seat`.`seatmapId`, `Seat`.`ticketId`, `Seat`.`seatNumber`, `Seat`.`row`, `Seat`.`enabled`, `Seat`.`vip`, `Seat`.`date`, `Seat`.`reservedBy`, `Seatmap`.`id`, `Seatmap`.`eventId`, `Seatmap`.`enabled`, `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` FROM `fom_site`.`seats` AS `Seat` LEFT JOIN `fom_site`.`seatmaps` AS `Seatmap` ON (`Seat`.`seatmapId` = `Seatmap`.`id`) LEFT JOIN `fom_site`.`tickets` AS `Ticket` ON (`Seat`.`ticketId` = `Ticket`.`id`) WHERE `Seat`.`ticketId` = 19761 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Ticket`.`id`, `Ticket`.`statusId` 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` = 10085 AND `Ticket`.`eventId` = 46 ORDER BY `id` DESC LIMIT 1 | 1 | 1 | 0 | |
SELECT `War`.`id`, `War`.`screen1B`, `War`.`screen2B`, `War`.`screen3B`, `War`.`screen4B`, `War`.`bracketType`, `War`.`compoId`, `War`.`teamA`, `War`.`teamB`, `War`.`scoreAByA`, `War`.`scoreBByA`, `War`.`scoreAByB`, `War`.`scoreBByB`, `War`.`finalScoreA`, `War`.`finalScoreB`, `War`.`winnerWarId`, `War`.`loserWarId`, `War`.`pouleId`, `War`.`level`, `War`.`playable`, `War`.`mapname`, `War`.`time`, `War`.`screen1A`, `War`.`screen2A`, `War`.`screen3A`, `War`.`screen4A`, `War`.`prevTeamA`, `War`.`prevTeamB`, `War`.`screen1Admin`, `War`.`screen2Admin`, `War`.`adminEditID`, `War`.`adminEditDate`, `War`.`finalScoreDate`, `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`, `TeamA`.`id`, `TeamA`.`name`, `TeamA`.`leaderId`, `TeamA`.`compoId`, `TeamA`.`pouleId`, `TeamA`.`notes`, `TeamA`.`withdrew`, `TeamB`.`id`, `TeamB`.`name`, `TeamB`.`leaderId`, `TeamB`.`compoId`, `TeamB`.`pouleId`, `TeamB`.`notes`, `TeamB`.`withdrew`, `AdminEdit`.`id`, `AdminEdit`.`facebook_id`, `AdminEdit`.`username`, `AdminEdit`.`new_username`, `AdminEdit`.`nickname`, `AdminEdit`.`password`, `AdminEdit`.`firstname`, `AdminEdit`.`lastname`, `AdminEdit`.`active`, `AdminEdit`.`validationCode`, `AdminEdit`.`mailValidationCode`, `AdminEdit`.`group_id`, `AdminEdit`.`created`, `AdminEdit`.`modified`, `AdminEdit`.`last_login`, `AdminEdit`.`street`, `AdminEdit`.`nr`, `AdminEdit`.`bus`, `AdminEdit`.`zip`, `AdminEdit`.`city`, `AdminEdit`.`country`, `AdminEdit`.`phone`, `AdminEdit`.`gsm`, `AdminEdit`.`gender`, `AdminEdit`.`birthdate`, `AdminEdit`.`clanId`, `AdminEdit`.`clantrust`, `AdminEdit`.`clanjoinId`, `AdminEdit`.`hwbudget`, `AdminEdit`.`education`, `AdminEdit`.`profession`, `AdminEdit`.`hoursaweek`, `AdminEdit`.`language`, `AdminEdit`.`oldId`, `AdminEdit`.`receive_newsletter`, `AdminEdit`.`imageUrl`, `AdminEdit`.`slug`, `AdminEdit`.`fb_link`, `AdminEdit`.`fb_location`, `AdminEdit`.`CPU`, `AdminEdit`.`MOBO`, `AdminEdit`.`GFX`, `AdminEdit`.`RAM`, `AdminEdit`.`steamName`, `AdminEdit`.`steamId`, `AdminEdit`.`originName`, `AdminEdit`.`lolSummonerName`, `AdminEdit`.`Other`, `AdminEdit`.`comment`, `AdminEdit`.`seat_id`, `AdminEdit`.`msg_notifications`, `AdminEdit`.`mouseHand`, `AdminEdit`.`deviceId`, `AdminEdit`.`alternative_login` FROM `fom_site`.`wars` AS `War` LEFT JOIN `fom_site`.`compos` AS `Compo` ON (`War`.`compoId` = `Compo`.`id`) LEFT JOIN `fom_site`.`teams` AS `TeamA` ON (`War`.`teamA` = `TeamA`.`id`) LEFT JOIN `fom_site`.`teams` AS `TeamB` ON (`War`.`teamB` = `TeamB`.`id`) LEFT JOIN `fom_site`.`users` AS `AdminEdit` ON (`War`.`adminEditID` = `AdminEdit`.`id`) WHERE NOT (`War`.`finalScoreA` IS NULL) AND ((`War`.`teamA` = 10439) OR (`War`.`teamB` = 10439)) ORDER BY `War`.`compoId` DESC | 6 | 6 | 1 | 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`, `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`, `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`, `Admin2`.`id`, `Admin2`.`facebook_id`, `Admin2`.`username`, `Admin2`.`new_username`, `Admin2`.`nickname`, `Admin2`.`password`, `Admin2`.`firstname`, `Admin2`.`lastname`, `Admin2`.`active`, `Admin2`.`validationCode`, `Admin2`.`mailValidationCode`, `Admin2`.`group_id`, `Admin2`.`created`, `Admin2`.`modified`, `Admin2`.`last_login`, `Admin2`.`street`, `Admin2`.`nr`, `Admin2`.`bus`, `Admin2`.`zip`, `Admin2`.`city`, `Admin2`.`country`, `Admin2`.`phone`, `Admin2`.`gsm`, `Admin2`.`gender`, `Admin2`.`birthdate`, `Admin2`.`clanId`, `Admin2`.`clantrust`, `Admin2`.`clanjoinId`, `Admin2`.`hwbudget`, `Admin2`.`education`, `Admin2`.`profession`, `Admin2`.`hoursaweek`, `Admin2`.`language`, `Admin2`.`oldId`, `Admin2`.`receive_newsletter`, `Admin2`.`imageUrl`, `Admin2`.`slug`, `Admin2`.`fb_link`, `Admin2`.`fb_location`, `Admin2`.`CPU`, `Admin2`.`MOBO`, `Admin2`.`GFX`, `Admin2`.`RAM`, `Admin2`.`steamName`, `Admin2`.`steamId`, `Admin2`.`originName`, `Admin2`.`lolSummonerName`, `Admin2`.`Other`, `Admin2`.`comment`, `Admin2`.`seat_id`, `Admin2`.`msg_notifications`, `Admin2`.`mouseHand`, `Admin2`.`deviceId`, `Admin2`.`alternative_login`, `CompoState`.`id`, `CompoState`.`name`, `Tag`.`id`, `Tag`.`tagName`, `Tag`.`bannerUrl`, `Tag`.`parentId`, `Tag`.`slug`, `Tag`.`color` FROM `fom_site`.`compos` AS `Compo` LEFT JOIN `fom_site`.`events` AS `Event` ON (`Compo`.`eventId` = `Event`.`id`) LEFT JOIN `fom_site`.`users` AS `Admin` ON (`Compo`.`adminId` = `Admin`.`id`) LEFT JOIN `fom_site`.`users` AS `Admin2` ON (`Compo`.`adminId2` = `Admin2`.`id`) LEFT JOIN `fom_site`.`compo_states` AS `CompoState` ON (`Compo`.`compoStateId` = `CompoState`.`id`) LEFT JOIN `fom_site`.`tags` AS `Tag` ON (`Compo`.`tagId` = `Tag`.`id`) WHERE `Compo`.`id` = 380 ORDER BY `Compo`.`id` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Teams`.`id`, `Teams`.`name`, `Teams`.`leaderId`, `Teams`.`compoId`, `Teams`.`pouleId`, `Teams`.`notes`, `Teams`.`withdrew` FROM `fom_site`.`teams` AS `Teams` WHERE `Teams`.`compoId` = (380) | 55 | 55 | 0 | |
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` = (380) | 64 | 64 | 0 | |