Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT chat.registration_id,chat.message,registrations.username, registrations.avatar_file_name,DATE_FORMAT(chat.time_posted, '%a %l:%i%p') as time_posted FROM chat,registrations where registrations.id=chat.registration_id AND chat.player_club_id IS NULL AND chat.to IS NULL ORDER BY chat.id DESC LIMIT 25 | 25 | 25 | 1 | |
SELECT `AdminBreed`.`id`, `AdminBreed`.`title`, `AdminBreed`.`description`, `AdminBreed`.`created`, `AdminBreed`.`modified`, `AdminBreed`.`speed`, `AdminBreed`.`stamina`, `AdminBreed`.`strength`, `AdminBreed`.`agility`, `AdminBreed`.`collection`, `AdminBreed`.`min_adult_height`, `AdminBreed`.`max_adult_height` FROM `movementsim`.`horse_breeds` AS `AdminBreed` WHERE 1 = 1 | 5 | 5 | 1 | maybe slow |
SELECT `AdminImage`.`id`, `AdminImage`.`horse_breed_id`, `AdminImage`.`horse_shade_id`, `AdminImage`.`title`, `AdminImage`.`created`, `AdminImage`.`modified`, `AdminImage`.`age`, `AdminImage`.`image_type`, `AdminImage`.`image_name` FROM `movementsim`.`horse_images` AS `AdminImage` WHERE `AdminImage`.`horse_breed_id` = 7 AND `AdminImage`.`image_type` = 'base' | 84 | 84 | 2 | |
SELECT `HorseMarking`.`id`, `HorseMarking`.`horse_breed_id`, `HorseMarking`.`horse_image_id`, `HorseMarking`.`age`, `HorseMarking`.`title`, `HorseMarking`.`created`, `HorseMarking`.`modified`, `HorseMarking`.`marking_type`, `HorseMarking`.`marking_leg`, `HorseMarking`.`grey_only`, `HorseMarking`.`white_marking`, `HorseMarking`.`appaloosa_marking`, `HorseMarking`.`sabino_marking`, `HorseMarking`.`splashed_overo_marking`, `HorseMarking`.`foundation_horse_occurrence`, `HorseMarking`.`random` FROM `movementsim`.`horse_markings` AS `HorseMarking` WHERE `HorseMarking`.`horse_breed_id` = 7 | 32 | 32 | 1 | |
SELECT `AdminImage`.`id`, `AdminImage`.`horse_breed_id`, `AdminImage`.`horse_shade_id`, `AdminImage`.`title`, `AdminImage`.`created`, `AdminImage`.`modified`, `AdminImage`.`age`, `AdminImage`.`image_type`, `AdminImage`.`image_name` FROM `movementsim`.`horse_images` AS `AdminImage` WHERE `AdminImage`.`horse_breed_id` = 2 AND `AdminImage`.`image_type` = 'base' | 82 | 82 | 2 | |
SELECT `HorseMarking`.`id`, `HorseMarking`.`horse_breed_id`, `HorseMarking`.`horse_image_id`, `HorseMarking`.`age`, `HorseMarking`.`title`, `HorseMarking`.`created`, `HorseMarking`.`modified`, `HorseMarking`.`marking_type`, `HorseMarking`.`marking_leg`, `HorseMarking`.`grey_only`, `HorseMarking`.`white_marking`, `HorseMarking`.`appaloosa_marking`, `HorseMarking`.`sabino_marking`, `HorseMarking`.`splashed_overo_marking`, `HorseMarking`.`foundation_horse_occurrence`, `HorseMarking`.`random` FROM `movementsim`.`horse_markings` AS `HorseMarking` WHERE `HorseMarking`.`horse_breed_id` = 2 | 50 | 50 | 1 | |
SELECT `AdminImage`.`id`, `AdminImage`.`horse_breed_id`, `AdminImage`.`horse_shade_id`, `AdminImage`.`title`, `AdminImage`.`created`, `AdminImage`.`modified`, `AdminImage`.`age`, `AdminImage`.`image_type`, `AdminImage`.`image_name` FROM `movementsim`.`horse_images` AS `AdminImage` WHERE `AdminImage`.`horse_breed_id` = 3 AND `AdminImage`.`image_type` = 'base' | 21 | 21 | 2 | maybe slow |
SELECT `HorseMarking`.`id`, `HorseMarking`.`horse_breed_id`, `HorseMarking`.`horse_image_id`, `HorseMarking`.`age`, `HorseMarking`.`title`, `HorseMarking`.`created`, `HorseMarking`.`modified`, `HorseMarking`.`marking_type`, `HorseMarking`.`marking_leg`, `HorseMarking`.`grey_only`, `HorseMarking`.`white_marking`, `HorseMarking`.`appaloosa_marking`, `HorseMarking`.`sabino_marking`, `HorseMarking`.`splashed_overo_marking`, `HorseMarking`.`foundation_horse_occurrence`, `HorseMarking`.`random` FROM `movementsim`.`horse_markings` AS `HorseMarking` WHERE `HorseMarking`.`horse_breed_id` = 3 | 38 | 38 | 1 | |
SELECT `AdminImage`.`id`, `AdminImage`.`horse_breed_id`, `AdminImage`.`horse_shade_id`, `AdminImage`.`title`, `AdminImage`.`created`, `AdminImage`.`modified`, `AdminImage`.`age`, `AdminImage`.`image_type`, `AdminImage`.`image_name` FROM `movementsim`.`horse_images` AS `AdminImage` WHERE `AdminImage`.`horse_breed_id` = 4 AND `AdminImage`.`image_type` = 'base' | 32 | 32 | 2 | maybe slow |
SELECT `HorseMarking`.`id`, `HorseMarking`.`horse_breed_id`, `HorseMarking`.`horse_image_id`, `HorseMarking`.`age`, `HorseMarking`.`title`, `HorseMarking`.`created`, `HorseMarking`.`modified`, `HorseMarking`.`marking_type`, `HorseMarking`.`marking_leg`, `HorseMarking`.`grey_only`, `HorseMarking`.`white_marking`, `HorseMarking`.`appaloosa_marking`, `HorseMarking`.`sabino_marking`, `HorseMarking`.`splashed_overo_marking`, `HorseMarking`.`foundation_horse_occurrence`, `HorseMarking`.`random` FROM `movementsim`.`horse_markings` AS `HorseMarking` WHERE `HorseMarking`.`horse_breed_id` = 4 | 44 | 44 | 1 | |
SELECT `AdminImage`.`id`, `AdminImage`.`horse_breed_id`, `AdminImage`.`horse_shade_id`, `AdminImage`.`title`, `AdminImage`.`created`, `AdminImage`.`modified`, `AdminImage`.`age`, `AdminImage`.`image_type`, `AdminImage`.`image_name` FROM `movementsim`.`horse_images` AS `AdminImage` WHERE `AdminImage`.`horse_breed_id` = 6 AND `AdminImage`.`image_type` = 'base' | 89 | 89 | 2 | |
SELECT `HorseMarking`.`id`, `HorseMarking`.`horse_breed_id`, `HorseMarking`.`horse_image_id`, `HorseMarking`.`age`, `HorseMarking`.`title`, `HorseMarking`.`created`, `HorseMarking`.`modified`, `HorseMarking`.`marking_type`, `HorseMarking`.`marking_leg`, `HorseMarking`.`grey_only`, `HorseMarking`.`white_marking`, `HorseMarking`.`appaloosa_marking`, `HorseMarking`.`sabino_marking`, `HorseMarking`.`splashed_overo_marking`, `HorseMarking`.`foundation_horse_occurrence`, `HorseMarking`.`random` FROM `movementsim`.`horse_markings` AS `HorseMarking` WHERE `HorseMarking`.`horse_breed_id` = 6 | 51 | 51 | 1 | |