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.0014 |
SELECT * FROM (`redirects`) WHERE `from` = '/book-reviews/children'
|
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.0003 |
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/children%'
|
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.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` = '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.0534 |
SELECT * FROM (`book_reviews`) WHERE `active` = 1 AND `rss_date` <= NOW() AND `for_children` = 1 ORDER BY `book_reviews`.`rss_date` DESC LIMIT 20
|
0.0005 |
SHOW TABLES LIKE 'practices'
|
0.0004 |
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` = '28932' 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` = '28930' 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` = '28921' 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` = '28919' ORDER BY `name` ASC
|
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` = '28911' 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` = '28907' 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` = '28906' 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` = '28905' 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` = '28902' 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` = '28901' 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` = '28898' 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` = '28891' 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` = '28890' 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` = '28879' 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` = '28878' 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` = '28874' 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` = '28872' 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` = '28829' 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` = '28828' ORDER BY `name` ASC
|
0.0009 |
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` = '28825' ORDER BY `name` ASC
|
0.0115 |
SELECT * FROM (`book_reviews`) WHERE `active` = 1 AND `rss_date` <= NOW() AND `for_children` = 1 ORDER BY `book_reviews`.`rss_date` DESC
|
0.0011 |
SHOW TABLES LIKE 'authors'
|
0.0005 |
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` = '28932' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0008 |
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` = '28930' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0008 |
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` = '28921' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0008 |
SHOW TABLES LIKE 'authors'
|
0.0004 |
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` = '28919' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0008 |
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` = '28911' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0008 |
SHOW TABLES LIKE 'authors'
|
0.0004 |
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` = '28907' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0008 |
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` = '28906' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0009 |
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` = '28905' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0008 |
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` = '28902' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0008 |
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` = '28901' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0008 |
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` = '28898' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0007 |
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` = '28891' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0008 |
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` = '28890' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0008 |
SHOW TABLES LIKE 'authors'
|
0.0004 |
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` = '28879' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0011 |
SHOW TABLES LIKE 'authors'
|
0.0004 |
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` = '28878' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0008 |
SHOW TABLES LIKE 'authors'
|
0.0004 |
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` = '28874' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0008 |
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` = '28872' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0008 |
SHOW TABLES LIKE 'authors'
|
0.0004 |
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` = '28829' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0008 |
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` = '28828' ORDER BY `book_reviews_authors`.`position` ASC
|
0.0008 |
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` = '28825' 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'
|