Released: 01-01-1970
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | 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-06-26 20:56:27' | 63 | 63 | 1 | |
2 | 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 | |
3 | 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-06-26 20:56:27' AND `Record`.`artist_id` = '' AND `Record`.`id` != '' ORDER BY `Record`.`date` ASC | 0 | 0 | 1 |