1 | DESCRIBE `do_setlists` | | 6 | 6 | 1 |
2 | DESCRIBE `do_songs` | | 4 | 4 | 1 |
3 | DESCRIBE `do_shows` | | 7 | 7 | 1 |
4 | DESCRIBE `do_venues` | | 7 | 7 | 1 |
5 | DESCRIBE `do_tours` | | 4 | 4 | 1 |
6 | DESCRIBE `do_bands` | | 3 | 3 | 1 |
7 | DESCRIBE `do_photos` | | 7 | 7 | 1 |
8 | DESCRIBE `do_integrations` | | 4 | 4 | 1 |
9 | DESCRIBE `do_menus` | | 5 | 5 | 1 |
10 | DESCRIBE `do_news` | | 5 | 5 | 1 |
11 | SELECT `Show`.`integration_id` FROM `do_shows` AS `Show` LEFT JOIN `do_venues` AS `Venue` ON (`Show`.`venue_id` = `Venue`.`id`) WHERE `Show`.`id` = 195 LIMIT 1 | | 1 | 1 | 5 |
12 | SELECT `Integration`.`id`, `Integration`.`tour_id`, `Integration`.`band_id`, `Integration`.`integration_id`, `Tour`.`id`, `Tour`.`tourName`, `Tour`.`headliner_id`, `Tour`.`festivalFlag`, `Band`.`id`, `Band`.`bandName`, `Band`.`webLink` FROM `do_integrations` AS `Integration` LEFT JOIN `do_tours` AS `Tour` ON (`Integration`.`tour_id` = `Tour`.`id`) LEFT JOIN `do_bands` AS `Band` ON (`Integration`.`band_id` = `Band`.`id`) WHERE `integration_id` = 29 | | 2 | 2 | 0 |
13 | DESCRIBE `do_sources` | | 5 | 5 | 1 |
14 | DESCRIBE `do_notes` | | 2 | 2 | 1 |
15 | SELECT *, month(date) as month, day(date) as day, year(date) as year FROM `do_shows` AS `Show` LEFT JOIN `do_venues` AS `Venue` ON (`Show`.`venue_id` = `Venue`.`id`) WHERE `Show`.`id` = 195 | | 1 | 1 | 0 |
16 | SELECT `Audio`.`id`, `Audio`.`type`, `Audio`.`show_id`, `Audio`.`taper_id`, `Audio`.`sourceUrl`, `source`.`id`, `source`.`type`, `source`.`show_id`, `source`.`taper_id`, `source`.`sourceUrl` FROM `do_sources` AS `Audio` JOIN `do_sources` AS `source` ON (`source`.`show_id` = 195 AND `source`.`taper_id` = `Audio`.`id`) WHERE `Audio`.`type` = 1 | | 0 | 0 | 0 |
17 | SELECT `Video`.`id`, `Video`.`type`, `Video`.`show_id`, `Video`.`taper_id`, `Video`.`sourceUrl`, `source`.`id`, `source`.`type`, `source`.`show_id`, `source`.`taper_id`, `source`.`sourceUrl` FROM `do_sources` AS `Video` JOIN `do_sources` AS `source` ON (`source`.`show_id` = 195 AND `source`.`taper_id` = `Video`.`id`) WHERE `Video`.`type` = 2 | | 0 | 0 | 0 |
18 | SELECT `Notes`.`id`, `Notes`.`noteText`, `Setlist`.`show_id`, `Setlist`.`song_id`, `Setlist`.`setlistOrder`, `Setlist`.`note_id`, `Setlist`.`creditUser`, `Setlist`.`accuracyMultiplier` FROM `do_notes` AS `Notes` JOIN `do_setlists` AS `Setlist` ON (`Setlist`.`show_id` = 195 AND `Setlist`.`note_id` = `Notes`.`id`) WHERE 1 = 1 ORDER BY `Setlist`.`setlistOrder` ASC | | 0 | 0 | 2 |
19 | SELECT `Songs`.`id`, `Songs`.`songName`, `Songs`.`albumID`, `Songs`.`trackNumber`, `Setlist`.`show_id`, `Setlist`.`song_id`, `Setlist`.`setlistOrder`, `Setlist`.`note_id`, `Setlist`.`creditUser`, `Setlist`.`accuracyMultiplier` FROM `do_songs` AS `Songs` JOIN `do_setlists` AS `Setlist` ON (`Setlist`.`show_id` = 195 AND `Setlist`.`song_id` = `Songs`.`id`) WHERE 1 = 1 ORDER BY `Setlist`.`setlistOrder` ASC | | 0 | 0 | 2 |
20 | SELECT `Show`.`id`, `Show`.`date` FROM `do_shows` AS `Show` LEFT JOIN `do_venues` AS `Venue` ON (`Show`.`venue_id` = `Venue`.`id`) WHERE year(date) = '1994' ORDER BY `date` ASC | | 90 | 90 | 1 |
21 | SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`name`, `Menu`.`h_link`, `Menu`.`type` FROM `do_menus` AS `Menu` WHERE 1 = 1 ORDER BY `id` ASC | | 40 | 40 | 1 |
22 | SELECT year(newsTime) as year, month(newsTime) as month, count(*) as count FROM `do_news` AS `News` WHERE 1 = 1 GROUP BY month, year ORDER BY `year` DESC, `month` DESC | | 31 | 31 | 1 |
23 | SELECT year(date) as year, count(*) as count FROM `do_shows` AS `Shows` WHERE 1 = 1 GROUP BY year(date) | | 13 | 13 | 1 |