|
incidentplay
|
Login |
|
© Copyright Incident Technologies January, 2013
|
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`user_facebook_id`, `User`.`user_facebook_id_hash`, `User`.`verified`, `User`.`randomkey`, `User`.`created`, `User`.`isAdmin`, `User`.`credits`, `UserProfile`.`id`, `UserProfile`.`user_id`, `UserProfile`.`name`, `UserProfile`.`firstname`, `UserProfile`.`middlename`, `UserProfile`.`lastname`, `UserProfile`.`email`, `UserProfile`.`profiletext`, `UserProfile`.`img_file_id`, `UserProfile`.`created`, `UserProfile`.`modified` FROM `users` AS `User` LEFT JOIN `user_profiles` AS `UserProfile` ON (`UserProfile`.`user_id` = `User`.`id`) WHERE `User`.`username` IS NULL LIMIT 1 | 0 | 0 | 0 | |
| 2 | SELECT `UserSong`.`id`, `UserSong`.`user_id`, `UserSong`.`viewcount`, `UserSong`.`rating`, `UserSong`.`permissions`, `UserSong`.`score`, `UserSong`.`title`, `UserSong`.`author`, `UserSong`.`tempo`, `UserSong`.`description`, `UserSong`.`genre`, `UserSong`.`xmp_file_id`, `UserSong`.`image_file_id`, `UserSong`.`created`, `UserSong`.`modified`, `UserSong`.`cost`, `UserSong`.`product_id`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`user_facebook_id`, `User`.`user_facebook_id_hash`, `User`.`verified`, `User`.`randomkey`, `User`.`created`, `User`.`isAdmin`, `User`.`credits` FROM `user_songs` AS `UserSong` LEFT JOIN `users` AS `User` ON (`UserSong`.`user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY `UserSong`.`created` DESC LIMIT 5 | 0 | 0 | 0 | |
| 3 | SELECT `UserSong`.`id`, `UserSong`.`user_id`, `UserSong`.`viewcount`, `UserSong`.`rating`, `UserSong`.`permissions`, `UserSong`.`score`, `UserSong`.`title`, `UserSong`.`author`, `UserSong`.`tempo`, `UserSong`.`description`, `UserSong`.`genre`, `UserSong`.`xmp_file_id`, `UserSong`.`image_file_id`, `UserSong`.`created`, `UserSong`.`modified`, `UserSong`.`cost`, `UserSong`.`product_id`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`user_facebook_id`, `User`.`user_facebook_id_hash`, `User`.`verified`, `User`.`randomkey`, `User`.`created`, `User`.`isAdmin`, `User`.`credits` FROM `user_songs` AS `UserSong` LEFT JOIN `users` AS `User` ON (`UserSong`.`user_id` = `User`.`id`) WHERE `UserSong`.`modified` != `UserSong`.`created` ORDER BY `UserSong`.`modified` DESC LIMIT 5 | 0 | 0 | 0 | |
| 4 | SELECT `UserComment`.`id`, `UserComment`.`user_id`, `UserComment`.`user_song_id`, `UserComment`.`user_profile_id`, `UserComment`.`commentText`, `UserComment`.`created`, `UserComment`.`user_song_session_id`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`user_facebook_id`, `User`.`user_facebook_id_hash`, `User`.`verified`, `User`.`randomkey`, `User`.`created`, `User`.`isAdmin`, `User`.`credits`, `UserProfile`.`id`, `UserProfile`.`user_id`, `UserProfile`.`name`, `UserProfile`.`firstname`, `UserProfile`.`middlename`, `UserProfile`.`lastname`, `UserProfile`.`email`, `UserProfile`.`profiletext`, `UserProfile`.`img_file_id`, `UserProfile`.`created`, `UserProfile`.`modified`, `UserSong`.`id`, `UserSong`.`user_id`, `UserSong`.`viewcount`, `UserSong`.`rating`, `UserSong`.`permissions`, `UserSong`.`score`, `UserSong`.`title`, `UserSong`.`author`, `UserSong`.`tempo`, `UserSong`.`description`, `UserSong`.`genre`, `UserSong`.`xmp_file_id`, `UserSong`.`image_file_id`, `UserSong`.`created`, `UserSong`.`modified`, `UserSong`.`cost`, `UserSong`.`product_id` FROM `user_comments` AS `UserComment` LEFT JOIN `users` AS `User` ON (`UserComment`.`user_id` = `User`.`id`) LEFT JOIN `user_profiles` AS `UserProfile` ON (`UserComment`.`user_profile_id` = `UserProfile`.`id`) LEFT JOIN `user_songs` AS `UserSong` ON (`UserComment`.`user_song_id` = `UserSong`.`id`) WHERE 1 = 1 ORDER BY `UserComment`.`created` DESC LIMIT 5 | 0 | 0 | 0 |