1 | DESCRIBE `artists` | | 8 | 8 | 1 |
2 | DESCRIBE `users` | | 7 | 7 | 1 |
3 | DESCRIBE `presents` | | 10 | 10 | 1 |
4 | DESCRIBE `tour_dates` | | 14 | 14 | 1 |
5 | DESCRIBE `records` | | 13 | 13 | 1 |
6 | DESCRIBE `reviews` | | 12 | 12 | 1 |
7 | DESCRIBE `headlines` | | 10 | 10 | 1 |
8 | DESCRIBE `media` | | 11 | 11 | 1 |
9 | DESCRIBE `audioplayer` | | 4 | 4 | 1 |
10 | DESCRIBE `photos` | | 8 | 8 | 1 |
11 | DESCRIBE `links` | | 7 | 7 | 1 |
12 | SELECT `Artist`.`id`, `Artist`.`user_id`, `Artist`.`created`, `Artist`.`modified`, `Artist`.`enable`, `Artist`.`title`, `Artist`.`body`, `Artist`.`image`, `User`.`id`, `User`.`username`, `User`.`email` FROM `artists` AS `Artist` LEFT JOIN `users` AS `User` ON (`Artist`.`user_id` = `User`.`id`) WHERE `Artist`.`id` = 46 LIMIT 1 | | 1 | 1 | 0 |
13 | SELECT `User`.`id`, `User`.`username`, `User`.`email` FROM `users` AS `User` WHERE `User`.`id` = 4 | | 1 | 1 | 0 |
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`.`artist_id` IN (46) ORDER BY `Present`.`enable` ASC | | 2 | 2 | 0 |
15 | SELECT `Artist`.`id`, `Artist`.`title` FROM `artists` AS `Artist` WHERE `Artist`.`enable` != "0000-00-00 00:00:00" AND `Artist`.`id` = 46 | | 1 | 1 | 0 |
16 | 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 (55) ORDER BY `TourDate`.`date` ASC | | 4 | 4 | 0 |
17 | 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 (101) ORDER BY `TourDate`.`date` ASC | | 4 | 4 | 0 |
18 | 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`.`artist_id` IN (46) ORDER BY `Record`.`date` DESC | | 1 | 1 | 0 |
19 | SELECT `Artist`.`id`, `Artist`.`title` FROM `artists` AS `Artist` WHERE `Artist`.`id` = 46 | | 1 | 1 | 0 |
20 | SELECT `Review`.`id`, `Review`.`enable`, `Review`.`date`, `Review`.`title`, `Review`.`artist_id` FROM `reviews` AS `Review` WHERE `Review`.`enable` != "0000-00-00 00:00:00" AND `Review`.`artist_id` IN (46) ORDER BY `Review`.`date` ASC | | 0 | 0 | 0 |
21 | 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`.`artist_id` IN (46) ORDER BY `Headline`.`enable` ASC | | 0 | 0 | 0 |
22 | SELECT `Media`.`id`, `Media`.`type`, `Media`.`record_id`, `Media`.`title`, `Media`.`path_low`, `Media`.`path_high`, `Media`.`artist_id` FROM `media` AS `Media` WHERE `Media`.`enable` != "0000-00-00 00:00:00" AND `Media`.`artist_id` IN (46) ORDER BY `Media`.`id` DESC | | 0 | 0 | 0 |
23 | SELECT `Photo`.`id`, `Photo`.`title`, `Photo`.`image`, `Photo`.`artist_id` FROM `photos` AS `Photo` WHERE `Photo`.`enable` != "0000-00-00 00:00:00" AND `Photo`.`artist_id` IN (46) ORDER BY `Photo`.`id` DESC | | 3 | 3 | 0 |
24 | SELECT `Link`.`id`, `Link`.`title`, `Link`.`url`, `Link`.`enable` FROM `links` AS `Link` JOIN `artists_links` ON (`artists_links`.`artist_id` = 46 AND `artists_links`.`link_id` = `Link`.`id`) WHERE `Link`.`enable` != "0000-00-00 00:00:00" ORDER BY `Link`.`created` ASC | | 2 | 2 | 1 |
25 | SELECT `Artist`.`id`, `Artist`.`title` FROM `artists` AS `Artist` JOIN `artists_links` ON (`artists_links`.`link_id` = 104 AND `artists_links`.`artist_id` = `Artist`.`id`) WHERE `Artist`.`enable` != "0000-00-00 00:00:00" | | 1 | 1 | 0 |
26 | SELECT `Artist`.`id`, `Artist`.`title` FROM `artists` AS `Artist` JOIN `artists_links` ON (`artists_links`.`link_id` = 105 AND `artists_links`.`artist_id` = `Artist`.`id`) WHERE `Artist`.`enable` != "0000-00-00 00:00:00" | | 1 | 1 | 0 |
27 | SELECT `Artist`.`id`, `Artist`.`user_id`, `Artist`.`created`, `Artist`.`modified`, `Artist`.`enable`, `Artist`.`title`, `Artist`.`body`, `Artist`.`image` FROM `artists` AS `Artist` WHERE `Artist`.`enable` != '0000-00-00 00:00:00' AND `Artist`.`enable` <= '2022-05-23 09:31:39' ORDER BY `Artist`.`title` ASC | | 98 | 98 | 1 |