Released: 01-01-1970
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | DESCRIBE `records` | 13 | 13 | 1 | |
2 | DESCRIBE `users` | 7 | 7 | 1 | |
3 | DESCRIBE `artists` | 8 | 8 | 1 | |
4 | DESCRIBE `presents` | 10 | 10 | 1 | |
5 | DESCRIBE `tour_dates` | 14 | 14 | 1 | |
6 | DESCRIBE `reviews` | 12 | 12 | 1 | |
7 | DESCRIBE `headlines` | 10 | 10 | 1 | |
8 | DESCRIBE `media` | 11 | 11 | 1 | |
9 | DESCRIBE `audioplayer` | 4 | 4 | 0 | |
10 | DESCRIBE `photos` | 8 | 8 | 1 | |
11 | DESCRIBE `links` | 7 | 7 | 0 | |
12 | SELECT DISTINCT `Artist`.`title`, `Artist`.`id` FROM `records` AS `Record` LEFT JOIN `users` AS `User` ON (`Record`.`user_id` = `User`.`id`) LEFT JOIN `artists` AS `Artist` ON (`Record`.`artist_id` = `Artist`.`id`) WHERE `Record`.`enable` != '0000-00-00 00:00:00' AND `Record`.`enable` <= '2022-08-13 05:52:46' | 63 | 63 | 1 | |
13 | SELECT `Record`.`id`, `Record`.`user_id`, `Record`.`artist_id`, `Record`.`created`, `Record`.`modified`, `Record`.`enable`, `Record`.`date`, `Record`.`title`, `Record`.`code`, `Record`.`body`, `Record`.`tracklist`, `Record`.`image`, `Record`.`buy_url`, `User`.`id`, `User`.`username`, `User`.`email`, `Artist`.`id`, `Artist`.`title` FROM `records` AS `Record` LEFT JOIN `users` AS `User` ON (`Record`.`user_id` = `User`.`id`) LEFT JOIN `artists` AS `Artist` ON (`Record`.`artist_id` = `Artist`.`id`) WHERE `Record`.`id` IS NULL LIMIT 1 | 0 | 0 | 0 | |
14 | SELECT `Record`.`id`, `Record`.`date`, `Record`.`title`, `Record`.`code`, `Record`.`image`, `Artist`.`title` FROM `records` AS `Record` LEFT JOIN `artists` AS `Artist` ON (`Record`.`artist_id` = `Artist`.`id`) WHERE `Record`.`enable` != '0000-00-00 00:00:00' AND `Record`.`enable` <= '2022-08-13 05:52:46' AND `Record`.`artist_id` = '' AND `Record`.`id` != '' ORDER BY `Record`.`date` ASC | 0 | 0 | 0 |