| 0.0001 |
SELECT `spk_content_ia`.`id`, `spk_content_ia`.`content_level`, `spk_content_ia`.`content_parent`, `spk_content_ia`.`meta_slug`, `spk_content_ia`.`title`
FROM (`spk_content_ia`)
WHERE `spk_content_ia`.`menu` IN ('Primary')
ORDER BY `spk_content_ia`.`menu`, `spk_content_ia`.`content_level` asc, `spk_content_ia`.`content_order` asc
|
| 0.0001 |
SELECT `spk_content`.*, `articles`.`article_type` AS article_name, `metadata`.`meta_slug`
FROM (`spk_content`)
JOIN `spk_article_types` AS articles ON `articles`.`id` = `spk_content`.`type_details`
LEFT JOIN `spk_content_metadata` AS metadata ON `metadata`.`content_id` = `spk_content`.`id`
WHERE `spk_content`.`type_details` IN (1, 5, 9, 10, 11, 13, 14, 15, 16, 17)
AND `spk_content`.`content_type` = 'Article'
AND `spk_content`.`status` = 'Published'
ORDER BY `spk_content`.`date_start` DESC
LIMIT 3
|
| 0.0006 |
SELECT *
FROM (`spk_content_ia`)
WHERE `meta_slug` = 'press_room_archive'
LIMIT 1
|
| 0.0004 |
SELECT `spk_content`.`id`
FROM (`spk_content`)
JOIN `spk_content_metadata` AS metadata ON `metadata`.`content_id` = `spk_content`.`id`
WHERE `meta_slug` = 'press_room_archive'
LIMIT 1
|
| 0.0001 |
SELECT `company`, `meta_title`, `meta_keywords`, `meta_description`
FROM (`spk_settings`)
LIMIT 1
|
| 0.0004 |
SELECT `ia`.`title` AS page_title, `ia`.`status` AS status, `ia`.`menu` AS menu, `ia`.`meta_slug` AS page_slug, `ia`.`id` AS page_id, `ia`.`meta_title`, `ia`.`meta_keywords`, `ia`.`meta_description`, `parent`.`title` AS parent_title, `parent`.`id` AS parent_id, `parent`.`meta_slug` AS parent_slug
FROM (`spk_content_ia` AS ia)
JOIN `spk_content_ia` AS parent ON `parent`.`id` = `ia`.`content_parent`
WHERE `ia`.`meta_slug` = 'press_room_archive'
LIMIT 1
|
| 0.0110 |
SELECT *
FROM (`spk_content_blocks`)
WHERE `page_id` = '95'
ORDER BY `content_order` asc
|
| 0.0038 |
SELECT *
FROM (`spk_content`)
WHERE ((type_details LIKE '%,95,%' OR type_details LIKE '95,%' OR type_details LIKE '%,95' OR type_details = '95') OR (type_details LIKE '%,All,%' OR type_details LIKE 'All,%' OR type_details LIKE '%,All' OR type_details = 'All')) AND content_type = 'Sidebar' AND status = 'Published'
ORDER BY `content_order` asc, `date_modified` desc
|
| 0.0005 |
SELECT *
FROM (`spk_content`)
WHERE `id` = '333'
AND `status` = 'Published'
LIMIT 1
|
| 0.0040 |
SELECT `spk_content`.*, `articles`.`article_type` AS article_name, `metadata`.`meta_slug`
FROM (`spk_content`)
JOIN `spk_article_types` AS articles ON `articles`.`id` = `spk_content`.`type_details`
LEFT JOIN `spk_content_metadata` AS metadata ON `metadata`.`content_id` = `spk_content`.`id`
WHERE `spk_content`.`type_details` IN ('13')
AND `spk_content`.`content_type` = 'Article'
AND `spk_content`.`status` = 'Published'
AND YEAR(spk_content.date_start) <= YEAR(NOW())-1
ORDER BY `spk_content`.`date_start` DESC
|
