![]() |
Abe Vigoda |
More Info... |
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | DESCRIBE `records` | 13 | 13 | 2 | |
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 | 0 | |
9 | DESCRIBE `audioplayer` | 4 | 4 | 1 | |
10 | DESCRIBE `photos` | 8 | 8 | 0 | |
11 | DESCRIBE `links` | 7 | 7 | 1 | |
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` <= '2021-04-23 00:02:35' | 63 | 63 | 1 | |
13 | SELECT `Artist`.`id`, `Artist`.`enable`, `Artist`.`title`, `Artist`.`body`, `Artist`.`image` FROM `artists` AS `Artist` WHERE `Artist`.`id` = 86 LIMIT 1 | 1 | 1 | 1 | |
14 | SELECT `Present`.`id`, `Present`.`title`, `Present`.`image`, `Present`.`artist_id` FROM `presents` AS `Present` WHERE `Present`.`enable` != "0000-00-00 00:00:00" AND `Present`.`enable` < '2021-04-23 00:02:35' AND `Present`.`artist_id` IN (86) ORDER BY `Present`.`enable` ASC | 1 | 1 | 0 | |
15 | SELECT `TourDate`.`id`, `TourDate`.`enable`, `TourDate`.`date`, `TourDate`.`venue`, `TourDate`.`buy_url`, `TourDate`.`sold_out`, `TourDate`.`present_id` FROM `tour_dates` AS `TourDate` WHERE `TourDate`.`enable` != '0000-00-00 00:00:00' AND `TourDate`.`present_id` IN (100) ORDER BY `TourDate`.`date` ASC | 2 | 2 | 0 | |
16 | SELECT `Record`.`id`, `Record`.`date`, `Record`.`title`, `Record`.`code`, `Record`.`image`, `Record`.`artist_id` FROM `records` AS `Record` WHERE `Record`.`enable` != "0000-00-00 00:00:00" AND `Record`.`enable` < '2021-04-23 00:02:35' AND `Record`.`artist_id` IN (86) ORDER BY `Record`.`date` DESC | 1 | 1 | 0 | |
17 | SELECT `Headline`.`id`, `Headline`.`enable`, `Headline`.`type`, `Headline`.`title`, `Headline`.`artist_id` FROM `headlines` AS `Headline` WHERE `Headline`.`enable` != "0000-00-00 00:00:00" AND `Headline`.`enable` < '2021-04-23 00:02:35' AND `Headline`.`artist_id` IN (86) ORDER BY `Headline`.`enable` ASC | 0 | 0 | 0 |