Journal for artistic research

ISSN 2235-0225
(default) 26 queries took 24 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `issues`991
2DESCRIBE `issue_exhibitions`18182
3SELECT `Issue`.`id` FROM `issues` AS `Issue` WHERE 1 = 1 ORDER BY `Issue`.`date` DESC, `Issue`.`id` DESC LIMIT 1111
4DESCRIBE `pages`13131
5DESCRIBE `site_items`14141
6DESCRIBE `chunks`661
7SELECT `SiteItem`.`id`, `SiteItem`.`site_item_type_id`, `SiteItem`.`parent_id`, `SiteItem`.`first_site_item_id`, `SiteItem`.`is_published`, `SiteItem`.`title`, `Page`.`text`, `Page`.`col1`, `Page`.`col2`, `Page`.`col3`, `Page`.`col4`, `Page`.`extra_text`, `Page`.`hide_extra_text_on_load`, `Page`.`num_cols`, `SiteItem`.`show_in_popup` FROM `pages` AS `Page` LEFT JOIN `site_items` AS `SiteItem` ON (`Page`.`site_item_id` = `SiteItem`.`id`) WHERE `Page`.`site_item_id` = 97 ORDER BY `SiteItem`.`lft` ASC LIMIT 1111
8SELECT `SiteItem`.`lft`, `SiteItem`.`rght` FROM `site_items` AS `SiteItem` WHERE `SiteItem`.`id` = 97 ORDER BY `SiteItem`.`lft` ASC LIMIT 1110
9SELECT `SiteItem`.`id` FROM `site_items` AS `SiteItem` WHERE 1 = 1 AND `SiteItem`.`lft` <= 2 AND `SiteItem`.`rght` >= 3 ORDER BY `SiteItem`.`lft` asc 221
10SELECT `Issue`.`id` FROM `issues` AS `Issue` WHERE 1 = 1 ORDER BY `Issue`.`date` DESC, `Issue`.`id` DESC LIMIT 1111
11SELECT `Issue`.`id`, `Issue`.`is_published`, `Issue`.`title`, `Issue`.`date`, `Issue`.`editorial_intro`, `Issue`.`editorial`, `Issue`.`imprint`, `Issue`.`created`, `Issue`.`modified` FROM `issues` AS `Issue` WHERE `Issue`.`id` = 491 ORDER BY `Issue`.`date` DESC, `Issue`.`id` DESC LIMIT 1111
12SELECT `IssueExhibition`.`id`, `IssueExhibition`.`is_published`, `IssueExhibition`.`issue_id`, `IssueExhibition`.`title`, `IssueExhibition`.`image_filename`, `IssueExhibition`.`audio_filename`, `IssueExhibition`.`audio_title`, `IssueExhibition`.`video_filename`, `IssueExhibition`.`video_width`, `IssueExhibition`.`video_height`, `IssueExhibition`.`author`, `IssueExhibition`.`intro`, `IssueExhibition`.`text`, `IssueExhibition`.`review_report_url`, `IssueExhibition`.`link_to_exhibition`, `IssueExhibition`.`ranking`, `IssueExhibition`.`created`, `IssueExhibition`.`modified` FROM `issue_exhibitions` AS `IssueExhibition` WHERE `IssueExhibition`.`is_published` = 1 AND `IssueExhibition`.`issue_id` = (491) ORDER BY `IssueExhibition`.`ranking` ASC 551
13SELECT `Issue`.`id`, `Issue`.`is_published`, `Issue`.`title`, `Issue`.`date`, `Issue`.`editorial_intro`, `Issue`.`editorial`, `Issue`.`imprint`, `Issue`.`created`, `Issue`.`modified` FROM `issues` AS `Issue` WHERE `Issue`.`id` = 491 111
14SELECT `Issue`.`id`, `Issue`.`is_published`, `Issue`.`title`, `Issue`.`date`, `Issue`.`editorial_intro`, `Issue`.`editorial`, `Issue`.`imprint`, `Issue`.`created`, `Issue`.`modified` FROM `issues` AS `Issue` WHERE `Issue`.`id` = 491 111
15SELECT `Issue`.`id`, `Issue`.`is_published`, `Issue`.`title`, `Issue`.`date`, `Issue`.`editorial_intro`, `Issue`.`editorial`, `Issue`.`imprint`, `Issue`.`created`, `Issue`.`modified` FROM `issues` AS `Issue` WHERE `Issue`.`id` = 491 110
16SELECT `Issue`.`id`, `Issue`.`is_published`, `Issue`.`title`, `Issue`.`date`, `Issue`.`editorial_intro`, `Issue`.`editorial`, `Issue`.`imprint`, `Issue`.`created`, `Issue`.`modified` FROM `issues` AS `Issue` WHERE `Issue`.`id` = 491 111
17SELECT `Issue`.`id`, `Issue`.`is_published`, `Issue`.`title`, `Issue`.`date`, `Issue`.`editorial_intro`, `Issue`.`editorial`, `Issue`.`imprint`, `Issue`.`created`, `Issue`.`modified` FROM `issues` AS `Issue` WHERE `Issue`.`id` = 491 111
18SELECT `SiteItem`.`id`, `SiteItem`.`site_item_type_id`, `SiteItem`.`parent_id`, `SiteItem`.`first_site_item_id`, `SiteItem`.`is_published`, `SiteItem`.`title`, `Page`.`text`, `Page`.`col1`, `Page`.`col2`, `Page`.`col3`, `Page`.`col4`, `Page`.`extra_text`, `Page`.`hide_extra_text_on_load`, `Page`.`num_cols`, `SiteItem`.`show_in_popup` FROM `pages` AS `Page` LEFT JOIN `site_items` AS `SiteItem` ON (`Page`.`site_item_id` = `SiteItem`.`id`) WHERE `Page`.`site_item_id` = 94 ORDER BY `SiteItem`.`lft` ASC LIMIT 1112
19SELECT `SiteItem`.`id`, `SiteItem`.`lft`, `SiteItem`.`rght`, `SiteItem`.`title`, `SiteItem`.`site_item_type_id`, `SiteItem`.`is_published`, `SiteItem`.`show_in_menu`, `SiteItem`.`url`, `SiteItem`.`show_in_popup` FROM `site_items` AS `SiteItem` WHERE 1 = 1 AND `SiteItem`.`parent_id` = 102 ORDER BY `SiteItem`.`lft` asc 881
20DESCRIBE `site_modules`442
21SELECT `SiteModule`.`controller` FROM `site_modules` AS `SiteModule` WHERE `SiteModule`.`site_item_id` = 103 LIMIT 1111
22SELECT `SiteItem`.`id`, `SiteItem`.`site_item_type_id`, `SiteItem`.`parent_id`, `SiteItem`.`first_site_item_id`, `SiteItem`.`is_published`, `SiteItem`.`title`, `Page`.`text`, `Page`.`col1`, `Page`.`col2`, `Page`.`col3`, `Page`.`col4`, `Page`.`extra_text`, `Page`.`hide_extra_text_on_load`, `Page`.`num_cols`, `SiteItem`.`show_in_popup` FROM `pages` AS `Page` LEFT JOIN `site_items` AS `SiteItem` ON (`Page`.`site_item_id` = `SiteItem`.`id`) WHERE `Page`.`site_item_id` = 102 ORDER BY `SiteItem`.`lft` ASC LIMIT 1111
23SELECT `SiteItem`.`id`, `SiteItem`.`lft`, `SiteItem`.`rght`, `SiteItem`.`title`, `SiteItem`.`site_item_type_id`, `SiteItem`.`is_published`, `SiteItem`.`show_in_menu`, `SiteItem`.`url`, `SiteItem`.`show_in_popup` FROM `site_items` AS `SiteItem` WHERE 1 = 1 AND `SiteItem`.`parent_id` = 94 ORDER BY `SiteItem`.`lft` asc 770
24SELECT `SiteItem`.`id`, `SiteItem`.`lft`, `SiteItem`.`rght`, `SiteItem`.`title`, `SiteItem`.`site_item_type_id`, `SiteItem`.`is_published`, `SiteItem`.`show_in_menu`, `SiteItem`.`url`, `SiteItem`.`show_in_popup` FROM `site_items` AS `SiteItem` WHERE 1 = 1 AND `SiteItem`.`parent_id` = 116 ORDER BY `SiteItem`.`lft` asc 770
25SELECT `Issue`.`id`, `Issue`.`title`, `Issue`.`date` FROM `issues` AS `Issue` WHERE `Issue`.`is_published` = 1 ORDER BY `Issue`.`date` DESC, `Issue`.`id` DESC 10100
26SELECT `Chunk`.`id`, `Chunk`.`is_published`, `Chunk`.`title`, `Chunk`.`text`, `Chunk`.`created`, `Chunk`.`modified` FROM `chunks` AS `Chunk` WHERE `Chunk`.`id` = 2 ORDER BY `Chunk`.`id` ASC LIMIT 1111