| 0.0010 |
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.0001 |
SELECT `modules`.`id`
FROM (`modules`)
JOIN `content_modules` ON `content_modules`.`module_id` = `modules`.`id`
WHERE `folder_name` = 'search'
|
| 0.0001 |
SELECT `modules`.`id`
FROM (`modules`)
JOIN `content_modules` ON `content_modules`.`module_id` = `modules`.`id`
WHERE `folder_name` = 'social'
|
| 0.0008 |
SELECT *
FROM (`redirects`)
WHERE `from` = '/book-reviews/excerpts'
|
| 0.0001 |
SELECT
user_reports.report_id
FROM
user_reports
WHERE
user_reports.user_group_id = NULL
|
| 0.0001 |
SELECT
user_settings.setting_id
FROM
user_settings
WHERE
user_settings.user_group_id = NULL
|
| 0.0001 |
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/excerpts%'
|
| 0.0001 |
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.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` = '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.0000 |
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.0478 |
SELECT *
FROM (`book_excerpts`)
WHERE `active` = 1
AND `oftheday` IS NOT NULL
ORDER BY `book_excerpts`.`oftheday` DESC
LIMIT 30
|
| 0.0004 |
SELECT * FROM book_reviews WHERE id = 8667
|
| 0.0006 |
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` = '8667'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0032 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '28459'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 6460
|
| 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` = '6460'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0032 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '14034'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 24679
|
| 0.0006 |
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` = '24679'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0006 |
SHOW TABLES LIKE 'practices'
|
| 0.0032 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '24680'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 7532
|
| 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` = '7532'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0006 |
SHOW TABLES LIKE 'practices'
|
| 0.0034 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '28132'
ORDER BY `name` ASC
|
| 0.0004 |
SELECT * FROM book_reviews WHERE id = 16971
|
| 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` = '16971'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0033 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '16972'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 20248
|
| 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` = '20248'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0006 |
SHOW TABLES LIKE 'practices'
|
| 0.0032 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '20249'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 18588
|
| 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` = '18588'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0032 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '18589'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 28835
|
| 0.0005 |
SHOW TABLES LIKE 'authors'
|
| 0.0000 |
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` = '28835'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0032 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '28498'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 26160
|
| 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` = '26160'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0032 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '26161'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 21474
|
| 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` = '21474'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0033 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '21475'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 5826
|
| 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` = '5826'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0033 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '13959'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 2709
|
| 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` = '2709'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0033 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '13604'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 18431
|
| 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` = '18431'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0032 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '18432'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 3325
|
| 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` = '3325'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0032 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '13671'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 7842
|
| 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` = '7842'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0032 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '24974'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 9148
|
| 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` = '9148'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0032 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '14406'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 21784
|
| 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` = '21784'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0032 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '21785'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 9977
|
| 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` = '9977'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0045 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '14769'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 24940
|
| 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` = '24940'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0008 |
SHOW TABLES LIKE 'practices'
|
| 0.0058 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '24941'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 2081
|
| 0.0007 |
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` = '2081'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0008 |
SHOW TABLES LIKE 'practices'
|
| 0.0059 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '13484'
ORDER BY `name` ASC
|
| 0.0004 |
SELECT * FROM book_reviews WHERE id = 9539
|
| 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` = '9539'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0008 |
SHOW TABLES LIKE 'practices'
|
| 0.0058 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '14559'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 9339
|
| 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` = '9339'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0008 |
SHOW TABLES LIKE 'practices'
|
| 0.0046 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '14471'
ORDER BY `name` ASC
|
| 0.0004 |
SELECT * FROM book_reviews WHERE id = 20289
|
| 0.0007 |
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` = '20289'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0008 |
SHOW TABLES LIKE 'practices'
|
| 0.0044 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '20290'
ORDER BY `name` ASC
|
| 0.0004 |
SELECT * FROM book_reviews WHERE id = 5439
|
| 0.0008 |
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` = '5439'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0008 |
SHOW TABLES LIKE 'practices'
|
| 0.0060 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '13863'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 22316
|
| 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` = '22316'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0008 |
SHOW TABLES LIKE 'practices'
|
| 0.0059 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '22317'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 21998
|
| 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` = '21998'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0008 |
SHOW TABLES LIKE 'practices'
|
| 0.0035 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '21999'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 922
|
| 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` = '922'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0006 |
SHOW TABLES LIKE 'practices'
|
| 0.0034 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '13318'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 3714
|
| 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` = '3714'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0006 |
SHOW TABLES LIKE 'practices'
|
| 0.0034 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '13696'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 22000
|
| 0.0006 |
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` = '22000'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0034 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '22001'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 27851
|
| 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` = '27851'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0006 |
SHOW TABLES LIKE 'practices'
|
| 0.0034 |
SELECT `practices`.*, `book_excerpts_practices`.*
FROM (`book_excerpts_practices`)
JOIN `practices` ON `book_excerpts_practices`.`practices_id` = `practices`.`id`
WHERE `book_excerpts_practices`.`book_excerpts_id` = '27852'
ORDER BY `name` ASC
|
| 0.0001 |
SELECT
user_reports.report_id
FROM
user_reports
WHERE
user_reports.user_group_id = NULL
|
| 0.0001 |
SELECT
user_settings.setting_id
FROM
user_settings
WHERE
user_settings.user_group_id = NULL
|
| 0.0001 |
SELECT *
FROM
`settings_values`
|
| 0.0001 |
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.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` = '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'
|