| 0.0013 |
SHOW TABLES FROM `sandp_dev`
|
| 0.0006 |
SELECT `modules`.`id`
FROM (`modules`)
JOIN `content_modules` ON `content_modules`.`module_id` = `modules`.`id`
WHERE `folder_name` = 'social'
|
| 0.0006 |
SELECT `modules`.`id`
FROM (`modules`)
JOIN `content_modules` ON `content_modules`.`module_id` = `modules`.`id`
WHERE `folder_name` = 'search'
|
| 0.0005 |
SELECT `modules`.`id`
FROM (`modules`)
JOIN `content_modules` ON `content_modules`.`module_id` = `modules`.`id`
WHERE `folder_name` = 'comments'
|
| 0.0011 |
SELECT *
FROM (`redirects`)
WHERE `from` = '/book-reviews/excerpts'
|
| 0.0004 |
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.0002 |
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.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'
|
| 0.0004 |
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.0002 |
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.0002 |
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.0006 |
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.0006 |
SELECT *
FROM (`content_module_settings`)
WHERE `content_module_id` = '33'
|
| 0.0002 |
SELECT *
FROM (`settings_values`)
WHERE `settings_values`.`editable` = 1
AND `name` = 'keywords'
|
| 0.0002 |
SELECT *
FROM (`settings_values`)
WHERE `settings_values`.`editable` = 1
AND `name` = 'description'
|
| 0.0001 |
SELECT *
FROM (`settings_values`)
WHERE `settings_values`.`editable` = 1
AND `name` = 'title'
|
| 0.0034 |
SELECT *
FROM (`book_excerpts`)
WHERE `active` = 1
AND `oftheday` IS NOT NULL
ORDER BY `book_excerpts`.`oftheday` DESC
LIMIT 30
|
| 0.0005 |
SELECT * FROM book_reviews WHERE id = 21527
|
| 0.0007 |
SHOW TABLES LIKE 'authors'
|
| 0.0007 |
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` = '21527'
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` = '21528'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 26265
|
| 0.0006 |
SHOW TABLES LIKE 'authors'
|
| 0.0066 |
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` = '26265'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0006 |
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` = '26274'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 25384
|
| 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` = '25384'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0006 |
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` = '25385'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 21114
|
| 0.0006 |
SHOW TABLES LIKE 'authors'
|
| 0.0032 |
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` = '21114'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0006 |
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` = '21115'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 8783
|
| 0.0005 |
SHOW TABLES LIKE 'authors'
|
| 0.0080 |
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` = '8783'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0006 |
SHOW TABLES LIKE 'practices'
|
| 0.0055 |
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` = '14392'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 18213
|
| 0.0007 |
SHOW TABLES LIKE 'authors'
|
| 0.0041 |
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` = '18213'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0008 |
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` = '18214'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 21025
|
| 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` = '21025'
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` = '24955'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 3246
|
| 0.0006 |
SHOW TABLES LIKE 'authors'
|
| 0.0049 |
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` = '3246'
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` = '13660'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 18321
|
| 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` = '18321'
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` = '18322'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 5332
|
| 0.0006 |
SHOW TABLES LIKE 'authors'
|
| 0.0085 |
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` = '5332'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0007 |
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` = '13850'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 7712
|
| 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` = '7712'
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` = '16118'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 28568
|
| 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` = '28568'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0005 |
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` = '28351'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 27353
|
| 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` = '27353'
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` = '27354'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 20493
|
| 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` = '20493'
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` = '20495'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 16758
|
| 0.0005 |
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` = '16758'
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` = '16759'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 15715
|
| 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` = '15715'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0007 |
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` = '15716'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 22496
|
| 0.0005 |
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` = '22496'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0007 |
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` = '22497'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 9865
|
| 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` = '9865'
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` = '14720'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 20774
|
| 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` = '20774'
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` = '20775'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 18586
|
| 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` = '18586'
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` = '18587'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 18789
|
| 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` = '18789'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0008 |
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` = '18790'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 9935
|
| 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` = '9935'
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` = '14745'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 21624
|
| 0.0006 |
SHOW TABLES LIKE 'authors'
|
| 0.0006 |
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` = '21624'
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` = '21625'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 15918
|
| 0.0005 |
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` = '15918'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0007 |
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` = '15920'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 3359
|
| 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` = '3359'
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` = '13677'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 26231
|
| 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` = '26231'
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` = '26232'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 19139
|
| 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` = '19139'
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` = '19140'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT * FROM book_reviews WHERE id = 5715
|
| 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` = '5715'
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` = '13928'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 28605
|
| 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` = '28605'
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` = '28386'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT * FROM book_reviews WHERE id = 15912
|
| 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` = '15912'
ORDER BY `book_reviews_authors`.`position` ASC
|
| 0.0007 |
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` = '15913'
ORDER BY `name` ASC
|
| 0.0002 |
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.0002 |
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` = 'users'
|
| 0.0002 |
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.0003 |
SELECT *
FROM (`settings_values`)
WHERE `settings_values`.`editable` = 1
AND `name` = 'enable_analytics'
|
| 0.0002 |
SELECT *
FROM (`settings_values`)
WHERE `settings_values`.`editable` = 1
AND `name` = 'analytics_code'
|