| 0.0007 |
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.0012 |
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.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/excerpts%'
|
| 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.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.0000 |
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.0403 |
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 = 3187
|
| 0.0005 |
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` = '3187'
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` = '13637'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 6553
|
| 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` = '6553'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0025 |
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` = '14061'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 16688
|
| 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` = '16688'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0029 |
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` = '16689'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 22186
|
| 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` = '22186'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0028 |
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` = '22732'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 22031
|
| 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` = '22031'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0029 |
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` = '22032'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 15875
|
| 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` = '15875'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0025 |
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` = '15876'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 1972
|
| 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` = '1972'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0026 |
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` = '13471'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 19703
|
| 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` = '19703'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0026 |
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` = '19704'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 2080
|
| 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` = '2080'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0025 |
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` = '15200'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 28527
|
| 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` = '28527'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0028 |
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` = '28323'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 10097
|
| 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` = '10097'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0026 |
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` = '14817'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 2131
|
| 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` = '2131'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0006 |
SHOW TABLES LIKE 'practices'
|
| 0.0028 |
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` = '18773'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 27815
|
| 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` = '27815'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0026 |
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` = '27816'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 28494
|
| 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` = '28494'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0025 |
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` = '28291'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 8367
|
| 0.0009 |
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` = '8367'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0025 |
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` = '14280'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 28470
|
| 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` = '28470'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0025 |
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` = '28273'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 6769
|
| 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` = '6769'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0026 |
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` = '14137'
ORDER BY `name` ASC
|
| 0.0001 |
SELECT * FROM book_reviews WHERE id = 22190
|
| 0.0005 |
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` = '22190'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0026 |
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` = '22191'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 2614
|
| 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` = '2614'
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` = '17237'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 9497
|
| 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` = '9497'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0025 |
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` = '14528'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 975
|
| 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` = '975'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0025 |
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` = '11811'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 28664
|
| 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` = '28664'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0026 |
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` = '28410'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 15607
|
| 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` = '15607'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0027 |
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` = '15620'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 1661
|
| 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` = '1661'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0008 |
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` = '15485'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 22498
|
| 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` = '22498'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0006 |
SHOW TABLES LIKE 'practices'
|
| 0.0028 |
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` = '22499'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 24572
|
| 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` = '24572'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0027 |
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` = '24573'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 16449
|
| 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` = '16449'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0027 |
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` = '16453'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 28922
|
| 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` = '28922'
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` = '28560'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 10167
|
| 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` = '10167'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0029 |
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` = '14860'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 5812
|
| 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` = '5812'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0006 |
SHOW TABLES LIKE 'practices'
|
| 0.0027 |
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` = '13952'
ORDER BY `name` 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'
|