0.0008 |
SHOW TABLES FROM `sandp_dev`
|
0.0001 |
SELECT `modules`.`id` FROM (`modules`) JOIN `content_modules` ON `content_modules`.`module_id` = `modules`.`id` WHERE `folder_name` = 'comments'
|
0.0000 |
SELECT `modules`.`id` FROM (`modules`) JOIN `content_modules` ON `content_modules`.`module_id` = `modules`.`id` WHERE `folder_name` = 'search'
|
0.0000 |
SELECT `modules`.`id` FROM (`modules`) JOIN `content_modules` ON `content_modules`.`module_id` = `modules`.`id` WHERE `folder_name` = 'social'
|
0.0006 |
SELECT * FROM (`redirects`) WHERE `from` = '/book-reviews/list'
|
0.0001 |
SELECT user_reports.report_id FROM user_reports WHERE user_reports.user_group_id = NULL
|
0.0000 |
SELECT user_settings.setting_id FROM user_settings WHERE user_settings.user_group_id = NULL
|
0.0000 |
SELECT * FROM `settings_values`
|
0.0002 |
SELECT `modules`.*, `content_modules`.`id` as install_id, `content_modules`.`default`, `content_modules`.`wrapper`, `content_modules`.`section_id` FROM (`modules`) LEFT JOIN `content_modules` ON `content_modules`.`module_id` = `modules`.`id` WHERE `folder_name` = 'book_reviews' AND `absolute_url` LIKE 'book-reviews/list%'
|
0.0000 |
SELECT `modules`.*, `content_modules`.`id` as install_id, `content_modules`.`default`, `content_modules`.`wrapper`, `content_modules`.`section_id` FROM (`modules`) LEFT JOIN `content_modules` ON `content_modules`.`module_id` = `modules`.`id` WHERE `folder_name` = 'book_reviews'
|
0.0000 |
SELECT `sections`.*, `content_positions`.`label`, `content_positions`.`position` FROM (`sections`) LEFT JOIN `content_positions` ON `sections`.`id` = `content_positions`.`section_id` WHERE `sections`.`id` = '5'
|
0.0001 |
SELECT `sections`.*, `content_positions`.`label`, `content_positions`.`position` FROM (`sections`) LEFT JOIN `content_positions` ON `sections`.`id` = `content_positions`.`section_id` WHERE `sections`.`id` = '5'
|
0.0000 |
SELECT `sections`.*, `content_positions`.`label`, `content_positions`.`position` FROM (`sections`) LEFT JOIN `content_positions` ON `sections`.`id` = `content_positions`.`section_id` WHERE `sections`.`id` = '1'
|
0.0001 |
SELECT `user_permissions`.* FROM (`user_permissions`) JOIN `user_groups` ON `user_groups`.`id` = `user_permissions`.`user_group_id` WHERE `content_module_id` = '33' AND `user_groups`.`type` = 'site'
|
0.0001 |
SELECT * FROM (`content_module_settings`) WHERE `content_module_id` = '33'
|
0.0000 |
SELECT * FROM (`settings_values`) WHERE `settings_values`.`editable` = 1 AND `name` = 'keywords'
|
0.0000 |
SELECT * FROM (`settings_values`) WHERE `settings_values`.`editable` = 1 AND `name` = 'description'
|
0.0000 |
SELECT * FROM (`settings_values`) WHERE `settings_values`.`editable` = 1 AND `name` = 'title'
|
0.0563 |
SELECT * FROM (`book_reviews`) WHERE `active` = 1 AND `rss_date` <= NOW() ORDER BY `book_reviews`.`rss_date` DESC LIMIT 20
|
0.0006 |
SHOW TABLES LIKE 'practices'
|
0.0003 |
SELECT `practices`.*, `book_reviews_practices`.* FROM (`book_reviews_practices`) JOIN `practices` ON `book_reviews_practices`.`practices_id` = `practices`.`id` WHERE `book_reviews_practices`.`book_reviews_id` = '29004' ORDER BY `name` ASC
|
0.0005 |
SHOW TABLES LIKE 'practices'
|
0.0002 |
SELECT `practices`.*, `book_reviews_practices`.* FROM (`book_reviews_practices`) JOIN `practices` ON `book_reviews_practices`.`practices_id` = `practices`.`id` WHERE `book_reviews_practices`.`book_reviews_id` = '29006' ORDER BY `name` ASC
|
0.0005 |
SHOW TABLES LIKE 'practices'
|
0.0002 |
SELECT `practices`.*, `book_reviews_practices`.* FROM (`book_reviews_practices`) JOIN `practices` ON `book_reviews_practices`.`practices_id` = `practices`.`id` WHERE `book_reviews_practices`.`book_reviews_id` = '29005' ORDER BY `name` ASC
|
0.0005 |
SHOW TABLES LIKE 'practices'
|
0.0003 |
SELECT `practices`.*, `book_reviews_practices`.* FROM (`book_reviews_practices`) JOIN `practices` ON `book_reviews_practices`.`practices_id` = `practices`.`id` WHERE `book_reviews_practices`.`book_reviews_id` = '29003' ORDER BY `name` ASC
|
0.0010 |
SHOW TABLES LIKE 'practices'
|
0.0003 |
SELECT `practices`.*, `book_reviews_practices`.* FROM (`book_reviews_practices`) JOIN `practices` ON `book_reviews_practices`.`practices_id` = `practices`.`id` WHERE `book_reviews_practices`.`book_reviews_id` = '29002' ORDER BY `name` ASC
|
0.0006 |
SHOW TABLES LIKE 'practices'
|
0.0002 |
SELECT `practices`.*, `book_reviews_practices`.* FROM (`book_reviews_practices`) JOIN `practices` ON `book_reviews_practices`.`practices_id` = `practices`.`id` WHERE `book_reviews_practices`.`book_reviews_id` = '29001' ORDER BY `name` ASC
|
0.0006 |
SHOW TABLES LIKE 'practices'
|
0.0002 |
SELECT `practices`.*, `book_reviews_practices`.* FROM (`book_reviews_practices`) JOIN `practices` ON `book_reviews_practices`.`practices_id` = `practices`.`id` WHERE `book_reviews_practices`.`book_reviews_id` = '28997' ORDER BY `name` ASC
|
0.0006 |
SHOW TABLES LIKE 'practices'
|
0.0002 |
SELECT `practices`.*, `book_reviews_practices`.* FROM (`book_reviews_practices`) JOIN `practices` ON `book_reviews_practices`.`practices_id` = `practices`.`id` WHERE `book_reviews_practices`.`book_reviews_id` = '29000' ORDER BY `name` ASC
|
0.0005 |
SHOW TABLES LIKE 'practices'
|
0.0002 |
SELECT `practices`.*, `book_reviews_practices`.* FROM (`book_reviews_practices`) JOIN `practices` ON `book_reviews_practices`.`practices_id` = `practices`.`id` WHERE `book_reviews_practices`.`book_reviews_id` = '28999' ORDER BY `name` ASC
|
0.0005 |
SHOW TABLES LIKE 'practices'
|
0.0002 |
SELECT `practices`.*, `book_reviews_practices`.* FROM (`book_reviews_practices`) JOIN `practices` ON `book_reviews_practices`.`practices_id` = `practices`.`id` WHERE `book_reviews_practices`.`book_reviews_id` = '28998' ORDER BY `name` ASC
|
0.0005 |
SHOW TABLES LIKE 'practices'
|
0.0002 |
SELECT `practices`.*, `book_reviews_practices`.* FROM (`book_reviews_practices`) JOIN `practices` ON `book_reviews_practices`.`practices_id` = `practices`.`id` WHERE `book_reviews_practices`.`book_reviews_id` = '28996' ORDER BY `name` ASC
|
0.0005 |
SHOW TABLES LIKE 'practices'
|
0.0002 |
SELECT `practices`.*, `book_reviews_practices`.* FROM (`book_reviews_practices`) JOIN `practices` ON `book_reviews_practices`.`practices_id` = `practices`.`id` WHERE `book_reviews_practices`.`book_reviews_id` = '28995' ORDER BY `name` ASC
|
0.0005 |
SHOW TABLES LIKE 'practices'
|
0.0002 |
SELECT `practices`.*, `book_reviews_practices`.* FROM (`book_reviews_practices`) JOIN `practices` ON `book_reviews_practices`.`practices_id` = `practices`.`id` WHERE `book_reviews_practices`.`book_reviews_id` = '28987' ORDER BY `name` ASC
|
0.0005 |
SHOW TABLES LIKE 'practices'
|
0.0002 |
SELECT `practices`.*, `book_reviews_practices`.* FROM (`book_reviews_practices`) JOIN `practices` ON `book_reviews_practices`.`practices_id` = `practices`.`id` WHERE `book_reviews_practices`.`book_reviews_id` = '28994' ORDER BY `name` ASC
|
0.0005 |
SHOW TABLES LIKE 'practices'
|
0.0002 |
SELECT `practices`.*, `book_reviews_practices`.* FROM (`book_reviews_practices`) JOIN `practices` ON `book_reviews_practices`.`practices_id` = `practices`.`id` WHERE `book_reviews_practices`.`book_reviews_id` = '28993' ORDER BY `name` ASC
|
0.0005 |
SHOW TABLES LIKE 'practices'
|
0.0002 |
SELECT `practices`.*, `book_reviews_practices`.* FROM (`book_reviews_practices`) JOIN `practices` ON `book_reviews_practices`.`practices_id` = `practices`.`id` WHERE `book_reviews_practices`.`book_reviews_id` = '28992' ORDER BY `name` ASC
|
0.0005 |
SHOW TABLES LIKE 'practices'
|
0.0002 |
SELECT `practices`.*, `book_reviews_practices`.* FROM (`book_reviews_practices`) JOIN `practices` ON `book_reviews_practices`.`practices_id` = `practices`.`id` WHERE `book_reviews_practices`.`book_reviews_id` = '28990' ORDER BY `name` ASC
|
0.0005 |
SHOW TABLES LIKE 'practices'
|
0.0002 |
SELECT `practices`.*, `book_reviews_practices`.* FROM (`book_reviews_practices`) JOIN `practices` ON `book_reviews_practices`.`practices_id` = `practices`.`id` WHERE `book_reviews_practices`.`book_reviews_id` = '28989' ORDER BY `name` ASC
|
0.0005 |
SHOW TABLES LIKE 'practices'
|
0.0002 |
SELECT `practices`.*, `book_reviews_practices`.* FROM (`book_reviews_practices`) JOIN `practices` ON `book_reviews_practices`.`practices_id` = `practices`.`id` WHERE `book_reviews_practices`.`book_reviews_id` = '28988' ORDER BY `name` ASC
|
0.0005 |
SHOW TABLES LIKE 'practices'
|
0.0002 |
SELECT `practices`.*, `book_reviews_practices`.* FROM (`book_reviews_practices`) JOIN `practices` ON `book_reviews_practices`.`practices_id` = `practices`.`id` WHERE `book_reviews_practices`.`book_reviews_id` = '28986' ORDER BY `name` ASC
|
0.0614 |
SELECT * FROM (`book_reviews`) WHERE `active` = 1 AND `rss_date` <= NOW() ORDER BY `book_reviews`.`rss_date` DESC
|
0.0049 |
SHOW TABLES LIKE 'authors'
|
0.0003 |
SELECT `authors`.*, `book_reviews_authors`.* FROM (`book_reviews_authors`) JOIN `authors` ON `book_reviews_authors`.`authors_id` = `authors`.`id` WHERE `book_reviews_authors`.`book_reviews_id` = '29004' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0005 |
SHOW TABLES LIKE 'authors'
|
0.0003 |
SELECT `authors`.*, `book_reviews_authors`.* FROM (`book_reviews_authors`) JOIN `authors` ON `book_reviews_authors`.`authors_id` = `authors`.`id` WHERE `book_reviews_authors`.`book_reviews_id` = '29006' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0006 |
SHOW TABLES LIKE 'authors'
|
0.0002 |
SELECT `authors`.*, `book_reviews_authors`.* FROM (`book_reviews_authors`) JOIN `authors` ON `book_reviews_authors`.`authors_id` = `authors`.`id` WHERE `book_reviews_authors`.`book_reviews_id` = '29005' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0006 |
SHOW TABLES LIKE 'authors'
|
0.0002 |
SELECT `authors`.*, `book_reviews_authors`.* FROM (`book_reviews_authors`) JOIN `authors` ON `book_reviews_authors`.`authors_id` = `authors`.`id` WHERE `book_reviews_authors`.`book_reviews_id` = '29003' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0006 |
SHOW TABLES LIKE 'authors'
|
0.0002 |
SELECT `authors`.*, `book_reviews_authors`.* FROM (`book_reviews_authors`) JOIN `authors` ON `book_reviews_authors`.`authors_id` = `authors`.`id` WHERE `book_reviews_authors`.`book_reviews_id` = '29002' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0006 |
SHOW TABLES LIKE 'authors'
|
0.0002 |
SELECT `authors`.*, `book_reviews_authors`.* FROM (`book_reviews_authors`) JOIN `authors` ON `book_reviews_authors`.`authors_id` = `authors`.`id` WHERE `book_reviews_authors`.`book_reviews_id` = '29001' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0005 |
SHOW TABLES LIKE 'authors'
|
0.0002 |
SELECT `authors`.*, `book_reviews_authors`.* FROM (`book_reviews_authors`) JOIN `authors` ON `book_reviews_authors`.`authors_id` = `authors`.`id` WHERE `book_reviews_authors`.`book_reviews_id` = '28997' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0006 |
SHOW TABLES LIKE 'authors'
|
0.0002 |
SELECT `authors`.*, `book_reviews_authors`.* FROM (`book_reviews_authors`) JOIN `authors` ON `book_reviews_authors`.`authors_id` = `authors`.`id` WHERE `book_reviews_authors`.`book_reviews_id` = '29000' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0005 |
SHOW TABLES LIKE 'authors'
|
0.0003 |
SELECT `authors`.*, `book_reviews_authors`.* FROM (`book_reviews_authors`) JOIN `authors` ON `book_reviews_authors`.`authors_id` = `authors`.`id` WHERE `book_reviews_authors`.`book_reviews_id` = '28999' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0008 |
SHOW TABLES LIKE 'authors'
|
0.0002 |
SELECT `authors`.*, `book_reviews_authors`.* FROM (`book_reviews_authors`) JOIN `authors` ON `book_reviews_authors`.`authors_id` = `authors`.`id` WHERE `book_reviews_authors`.`book_reviews_id` = '28998' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0005 |
SHOW TABLES LIKE 'authors'
|
0.0003 |
SELECT `authors`.*, `book_reviews_authors`.* FROM (`book_reviews_authors`) JOIN `authors` ON `book_reviews_authors`.`authors_id` = `authors`.`id` WHERE `book_reviews_authors`.`book_reviews_id` = '28996' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0006 |
SHOW TABLES LIKE 'authors'
|
0.0003 |
SELECT `authors`.*, `book_reviews_authors`.* FROM (`book_reviews_authors`) JOIN `authors` ON `book_reviews_authors`.`authors_id` = `authors`.`id` WHERE `book_reviews_authors`.`book_reviews_id` = '28995' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0006 |
SHOW TABLES LIKE 'authors'
|
0.0003 |
SELECT `authors`.*, `book_reviews_authors`.* FROM (`book_reviews_authors`) JOIN `authors` ON `book_reviews_authors`.`authors_id` = `authors`.`id` WHERE `book_reviews_authors`.`book_reviews_id` = '28987' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0005 |
SHOW TABLES LIKE 'authors'
|
0.0002 |
SELECT `authors`.*, `book_reviews_authors`.* FROM (`book_reviews_authors`) JOIN `authors` ON `book_reviews_authors`.`authors_id` = `authors`.`id` WHERE `book_reviews_authors`.`book_reviews_id` = '28994' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0005 |
SHOW TABLES LIKE 'authors'
|
0.0002 |
SELECT `authors`.*, `book_reviews_authors`.* FROM (`book_reviews_authors`) JOIN `authors` ON `book_reviews_authors`.`authors_id` = `authors`.`id` WHERE `book_reviews_authors`.`book_reviews_id` = '28993' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0005 |
SHOW TABLES LIKE 'authors'
|
0.0002 |
SELECT `authors`.*, `book_reviews_authors`.* FROM (`book_reviews_authors`) JOIN `authors` ON `book_reviews_authors`.`authors_id` = `authors`.`id` WHERE `book_reviews_authors`.`book_reviews_id` = '28992' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0005 |
SHOW TABLES LIKE 'authors'
|
0.0003 |
SELECT `authors`.*, `book_reviews_authors`.* FROM (`book_reviews_authors`) JOIN `authors` ON `book_reviews_authors`.`authors_id` = `authors`.`id` WHERE `book_reviews_authors`.`book_reviews_id` = '28990' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0005 |
SHOW TABLES LIKE 'authors'
|
0.0002 |
SELECT `authors`.*, `book_reviews_authors`.* FROM (`book_reviews_authors`) JOIN `authors` ON `book_reviews_authors`.`authors_id` = `authors`.`id` WHERE `book_reviews_authors`.`book_reviews_id` = '28989' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0005 |
SHOW TABLES LIKE 'authors'
|
0.0002 |
SELECT `authors`.*, `book_reviews_authors`.* FROM (`book_reviews_authors`) JOIN `authors` ON `book_reviews_authors`.`authors_id` = `authors`.`id` WHERE `book_reviews_authors`.`book_reviews_id` = '28988' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0005 |
SHOW TABLES LIKE 'authors'
|
0.0003 |
SELECT `authors`.*, `book_reviews_authors`.* FROM (`book_reviews_authors`) JOIN `authors` ON `book_reviews_authors`.`authors_id` = `authors`.`id` WHERE `book_reviews_authors`.`book_reviews_id` = '28986' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0001 |
SELECT user_reports.report_id FROM user_reports WHERE user_reports.user_group_id = NULL
|
0.0000 |
SELECT user_settings.setting_id FROM user_settings WHERE user_settings.user_group_id = NULL
|
0.0000 |
SELECT * FROM `settings_values`
|
0.0000 |
SELECT `modules`.*, `content_modules`.`id` as install_id, `content_modules`.`default`, `content_modules`.`wrapper`, `content_modules`.`section_id` FROM (`modules`) LEFT JOIN `content_modules` ON `content_modules`.`module_id` = `modules`.`id` WHERE `folder_name` = 'users'
|
0.0000 |
SELECT `sections`.*, `content_positions`.`label`, `content_positions`.`position` FROM (`sections`) LEFT JOIN `content_positions` ON `sections`.`id` = `content_positions`.`section_id` WHERE `sections`.`id` = '1'
|
0.0001 |
SELECT * FROM (`settings_values`) WHERE `settings_values`.`editable` = 1 AND `name` = 'enable_analytics'
|
0.0000 |
SELECT * FROM (`settings_values`) WHERE `settings_values`.`editable` = 1 AND `name` = 'analytics_code'
|
0.0000 |
SELECT * FROM (`settings_values`) WHERE `settings_values`.`editable` = 1 AND `name` = 'analytics_code'
|