| 0.0008 |
SHOW TABLES FROM `sandp_dev`
|
| 0.0000 |
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.0006 |
SELECT *
FROM (`redirects`)
WHERE `from` = '/films/reviews/view/28282/a-man-called-ove'
|
| 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.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` = 'film_reviews'
AND `absolute_url` LIKE 'films/reviews/view/28282/a-man-called-ove%'
|
| 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` = 'film_reviews'
|
| 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` = '4'
|
| 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` = '4'
|
| 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.0002 |
SELECT `user_permissions`.*
FROM (`user_permissions`)
JOIN `user_groups` ON `user_groups`.`id` = `user_permissions`.`user_group_id`
WHERE `content_module_id` = '34'
AND `user_groups`.`type` = 'site'
|
| 0.0002 |
SELECT *
FROM (`content_module_settings`)
WHERE `content_module_id` = '34'
|
| 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.0002 |
SELECT * FROM film_reviews WHERE id = 28282
|
| 0.0001 |
SELECT * FROM features WHERE title = LOWER('frederic and mary ann brussat') AND type = 'Contributor'
|
| 0.0001 |
SELECT * FROM authors WHERE CONCAT(first_name,' ',last_name) = 'Frederic and Mary Ann Brussat'
|
| 0.0008 |
SHOW TABLES LIKE 'authors'
|
| 0.0004 |
SELECT `authors`.*, `film_reviews_authors`.*
FROM (`film_reviews_authors`)
JOIN `authors` ON `film_reviews_authors`.`authors_id` = `authors`.`id`
WHERE `film_reviews_authors`.`film_reviews_id` = '28282'
ORDER BY `film_reviews_authors`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'related_contents'
|
| 0.0002 |
SELECT `related_contents`.*, `film_reviews_related_contents`.*
FROM (`film_reviews_related_contents`)
JOIN `related_contents` ON `film_reviews_related_contents`.`related_contents_id` = `related_contents`.`id`
WHERE `film_reviews_related_contents`.`film_reviews_id` = '28282'
ORDER BY `film_reviews_related_contents`.`position` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'practices'
|
| 0.0002 |
SELECT `practices`.*, `film_reviews_practices`.*
FROM (`film_reviews_practices`)
JOIN `practices` ON `film_reviews_practices`.`practices_id` = `practices`.`id`
WHERE `film_reviews_practices`.`film_reviews_id` = '28282'
ORDER BY `name` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'traditions'
|
| 0.0002 |
SELECT `traditions`.*, `film_reviews_traditions`.*
FROM (`film_reviews_traditions`)
JOIN `traditions` ON `film_reviews_traditions`.`traditions_id` = `traditions`.`id`
WHERE `film_reviews_traditions`.`film_reviews_id` = '28282'
ORDER BY `traditions`.`name` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'content_types'
|
| 0.0002 |
SELECT `content_types`.*, `film_reviews_content_types`.*
FROM (`film_reviews_content_types`)
JOIN `content_types` ON `film_reviews_content_types`.`content_types_id` = `content_types`.`id`
WHERE `film_reviews_content_types`.`film_reviews_id` = '28282'
ORDER BY `content_types`.`name` ASC
|
| 0.0005 |
SHOW TABLES LIKE 'keywords'
|
| 0.0021 |
SELECT `keywords`.*, `film_reviews_keywords`.*
FROM (`film_reviews_keywords`)
JOIN `keywords` ON `film_reviews_keywords`.`keywords_id` = `keywords`.`id`
WHERE `film_reviews_keywords`.`film_reviews_id` = '28282'
ORDER BY `keywords`.`name` ASC
|
| 0.0006 |
SHOW TABLES LIKE 'authors'
|
| 0.0002 |
SELECT `authors`.*, `film_reviews_authors`.*
FROM (`film_reviews_authors`)
JOIN `authors` ON `film_reviews_authors`.`authors_id` = `authors`.`id`
WHERE `film_reviews_authors`.`film_reviews_id` = '28282'
ORDER BY `film_reviews_authors`.`position` ASC
|
| 0.0008 |
SELECT *
FROM (`teaching_scenes`)
WHERE `active` = 1
AND `film_reviews_id` = '28282'
ORDER BY `teaching_scenes`.`created` DESC
|
| 0.0006 |
SHOW TABLES LIKE 'practices'
|
| 0.0000 |
SELECT `practices`.*, `film_reviews_practices`.*
FROM (`film_reviews_practices`)
JOIN `practices` ON `film_reviews_practices`.`practices_id` = `practices`.`id`
WHERE `film_reviews_practices`.`film_reviews_id` = '28282'
ORDER BY `name` ASC
|
| 0.0001 |
SELECT *
FROM (`multi_practices`)
WHERE `title` = 'Transformation'
|
| 0.0001 |
SELECT *
FROM (`multi_practices`)
WHERE `title` = 'Compassion'
|
| 0.0001 |
SELECT *
FROM (`multi_practices`)
WHERE `title` = 'Joy'
|
| 0.0001 |
SELECT *
FROM (`multi_practices`)
WHERE `title` = 'Kindness'
|
| 0.0003 |
SELECT *
FROM (`multi_practices`)
WHERE `title` = 'Love'
|
| 0.0001 |
SELECT *
FROM (`multi_practices`)
WHERE `title` = 'Teachers'
|
| 0.0001 |
SELECT *
FROM (`multi_practices`)
WHERE `title` = 'Wonder'
|
| 0.0001 |
SELECT *
FROM (`multi_practices`)
WHERE `title` = 'You'
|
| 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'
|
