1 | SELECT `AppPreference`.`id`, `AppPreference`.`application_name`, `AppPreference`.`email`, `AppPreference`.`mail_recipients`, `AppPreference`.`404_not_found_page_id`, `AppPreference`.`meta_title`, `AppPreference`.`meta_show_title`, `AppPreference`.`meta_reverse_title`, `AppPreference`.`userlog_record_limit`, `AppPreference`.`userlog_time_limit`, `AppPreference`.`favicon_id`, `AppPreference`.`animated_favicon_id`, `AppPreference`.`apple_touch_icon_id`, `AppPreference`.`created`, `AppPreference`.`modified` FROM `fourcornersarchive_live`.`app_preferences` AS `AppPreference` WHERE 1 = 1 LIMIT 1 | | 1 | 1 | 0 |
2 | SELECT `AppPreferenceExpanded`.`id`, `AppPreferenceExpanded`.`app_preference_id`, `AppPreferenceExpanded`.`key`, `AppPreferenceExpanded`.`value`, `AppPreferenceExpanded`.`created`, `AppPreferenceExpanded`.`modified` FROM `fourcornersarchive_live`.`app_preferences_extended` AS `AppPreferenceExpanded` WHERE `AppPreferenceExpanded`.`app_preference_id` = (1) | | 4 | 4 | 0 |
3 | SELECT `AppPreference`.`id`, `AppPreference`.`application_name`, `AppPreference`.`email`, `AppPreference`.`mail_recipients`, `AppPreference`.`404_not_found_page_id`, `AppPreference`.`meta_title`, `AppPreference`.`meta_show_title`, `AppPreference`.`meta_reverse_title`, `AppPreference`.`userlog_record_limit`, `AppPreference`.`userlog_time_limit`, `AppPreference`.`favicon_id`, `AppPreference`.`animated_favicon_id`, `AppPreference`.`apple_touch_icon_id`, `AppPreference`.`created`, `AppPreference`.`modified` FROM `fourcornersarchive_live`.`app_preferences` AS `AppPreference` WHERE 1 = 1 LIMIT 1 | | 1 | 1 | 0 |
4 | SELECT `AppPreferenceExpanded`.`id`, `AppPreferenceExpanded`.`app_preference_id`, `AppPreferenceExpanded`.`key`, `AppPreferenceExpanded`.`value`, `AppPreferenceExpanded`.`created`, `AppPreferenceExpanded`.`modified` FROM `fourcornersarchive_live`.`app_preferences_extended` AS `AppPreferenceExpanded` WHERE `AppPreferenceExpanded`.`app_preference_id` = (1) | | 4 | 4 | 0 |
5 | SELECT `FrontpageRewrite`.`id`, `FrontpageRewrite`.`old`, `FrontpageRewrite`.`new`, `FrontpageRewrite`.`created`, `FrontpageRewrite`.`created_by`, `FrontpageRewrite`.`modified`, `FrontpageRewrite`.`modified_by`, `FrontpageRewrite`.`status` FROM `fourcornersarchive_live`.`frontpage_rewrites` AS `FrontpageRewrite` WHERE `FrontpageRewrite`.`old` = '/archive/index/sort:origination_year/direction:asc/page:9' AND `FrontpageRewrite`.`status` = 1 LIMIT 1 | | 0 | 0 | 0 |
6 | SELECT `FrontpageRewrite`.`id`, `FrontpageRewrite`.`old`, `FrontpageRewrite`.`new`, `FrontpageRewrite`.`created`, `FrontpageRewrite`.`created_by`, `FrontpageRewrite`.`modified`, `FrontpageRewrite`.`modified_by`, `FrontpageRewrite`.`status` FROM `fourcornersarchive_live`.`frontpage_rewrites` AS `FrontpageRewrite` WHERE `FrontpageRewrite`.`old` LIKE '%*' AND `FrontpageRewrite`.`status` = 1 | | 0 | 0 | 0 |
7 | SELECT `FrontpagePage`.`id`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`layout`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`frontpage_user_landing_page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status` FROM `fourcornersarchive_live`.`frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`slug` = 'page:9' AND `FrontpagePage`.`status` = 1 LIMIT 1 | | 0 | 0 | 0 |
8 | SELECT `ArchiveItem`.*, MATCH (title) AGAINST ('Blackfriars young photography group' IN NATURAL LANGUAGE MODE) AS scoreTitle, MATCH (ref, title, subtitle, author, author_organisation, author_interviewee, author_designer, author_photographer, author_writer, author_editor, pdf_text, location) AGAINST ('Blackfriars young photography group' IN NATURAL LANGUAGE MODE) AS scoreAll, `ArchiveItem`.`id` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` inner JOIN `fourcornersarchive_live`.`archive_items_collections` AS `ArchiveItemsCollections` ON (`ArchiveItemsCollections`.`collection_id` = ('2') AND `ArchiveItemsCollections`.`archive_item_id` = `ArchiveItem`.`id`) WHERE `ArchiveItem`.`status` = '1' AND MATCH (ref, title, subtitle, author, author_organisation, author_interviewee, author_designer, author_photographer, author_writer, author_editor, pdf_text, location) AGAINST ('Blackfriars young photography group' IN NATURAL LANGUAGE MODE) ORDER BY `ArchiveItem`.`origination_year` asc LIMIT 160, 20 | | 0 | 0 | 242 |