| 0.0009 |
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.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.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.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.0001 |
SELECT *
FROM (`content_module_settings`)
WHERE `content_module_id` = '33'
|
| 0.0001 |
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.0449 |
SELECT *
FROM (`book_excerpts`)
WHERE `active` = 1
AND `oftheday` IS NOT NULL
ORDER BY `book_excerpts`.`oftheday` DESC
LIMIT 30
|
| 0.0006 |
SELECT * FROM book_reviews WHERE id = 26294
|
| 0.0006 |
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` = '26294'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0050 |
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` = '26295'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 16810
|
| 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` = '16810'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0031 |
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` = '16811'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 27962
|
| 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` = '27962'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0030 |
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` = '27959'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 18823
|
| 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` = '18823'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0006 |
SHOW TABLES LIKE 'practices'
|
| 0.0030 |
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` = '18824'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 17652
|
| 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` = '17652'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0031 |
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` = '17653'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 15999
|
| 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` = '15999'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0031 |
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` = '16000'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 8391
|
| 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` = '8391'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0030 |
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` = '14296'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 8657
|
| 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` = '8657'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0031 |
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` = '14343'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 24048
|
| 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` = '24048'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0006 |
SHOW TABLES LIKE 'practices'
|
| 0.0030 |
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` = '24049'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 23229
|
| 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` = '23229'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0031 |
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` = '23230'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 24732
|
| 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` = '24732'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0031 |
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` = '24733'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 25003
|
| 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` = '25003'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0031 |
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` = '25004'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 18266
|
| 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` = '18266'
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` = '18267'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 9699
|
| 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` = '9699'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0006 |
SHOW TABLES LIKE 'practices'
|
| 0.0031 |
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` = '14632'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 22014
|
| 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` = '22014'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0031 |
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` = '22015'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 18978
|
| 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` = '18978'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0031 |
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` = '18979'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 25052
|
| 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` = '25052'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0006 |
SHOW TABLES LIKE 'practices'
|
| 0.0031 |
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` = '25053'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 19794
|
| 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` = '19794'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0031 |
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` = '19795'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 10172
|
| 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` = '10172'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0031 |
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` = '14862'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 15932
|
| 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` = '15932'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0031 |
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` = '15933'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 8402
|
| 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` = '8402'
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` = '14306'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 17841
|
| 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` = '17841'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0030 |
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` = '17842'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 23112
|
| 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` = '23112'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0031 |
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` = '26184'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 15576
|
| 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` = '15576'
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` = '15577'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 27653
|
| 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` = '27653'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0031 |
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` = '27654'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 28051
|
| 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` = '28051'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0031 |
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` = '28016'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 9277
|
| 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` = '9277'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0030 |
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` = '14464'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 1456
|
| 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` = '1456'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0030 |
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` = '11766'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 2585
|
| 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` = '2585'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0031 |
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` = '17220'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 28435
|
| 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` = '28435'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0031 |
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` = '28250'
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.0001 |
SELECT *
FROM (`settings_values`)
WHERE `settings_values`.`editable` = 1
AND `name` = 'analytics_code'
|