| 0.0231 |
SELECT `content_type`.*, `users`.*, `content`.*
FROM `content`
JOIN `content_type` ON `content_type`.`content_type_id`=`content`.`content_type_id`
LEFT JOIN `users` ON `content`.`created_by`=`users`.`user_id`
WHERE `content`.`content_published` = 1
AND `content`.`content_type_id` = 4
AND (content.content_status is null or content.content_status='Approved')
AND content.deleted_at is null
AND `content`.`parent_content_id` = '0'
AND content_type.deleted_at is null
ORDER BY `content`.`stick_ontop` DESC, `content`.`rank_order` DESC, `content`.`content_id` DESC
LIMIT 5
|
| 0.1181 |
SELECT *
FROM `content_value`
WHERE `content_id` IN('434', '50', '51', '52')
ORDER BY `content_value_rank` ASC
|
| 0.0146 |
SELECT `content_type`.*, `users`.*, `content`.*
FROM `content`
JOIN `content_type` ON `content_type`.`content_type_id`=`content`.`content_type_id`
LEFT JOIN `users` ON `content`.`created_by`=`users`.`user_id`
WHERE `content`.`content_published` = 1
AND (content.content_status is null or content.content_status='Approved')
AND `content`.`content_type_id` = 16
AND content.deleted_at is null
AND `content`.`parent_content_id` = '0'
AND content_type.deleted_at is null
ORDER BY `content`.`stick_ontop` DESC, `content`.`rank_order` DESC, `content`.`content_id` DESC
|
| 0.1151 |
SELECT *
FROM `content_value`
WHERE `content_id` IN('1402', '1401', '1400', '1399', '1398', '213', '212', '136', '135', '72', '62', '61')
ORDER BY `content_value_rank` ASC
|
| 0.0139 |
SELECT `content_type`.*, `users`.*, `content`.*
FROM `content`
JOIN `content_type` ON `content_type`.`content_type_id`=`content`.`content_type_id`
LEFT JOIN `users` ON `content`.`created_by`=`users`.`user_id`
WHERE `content`.`content_published` = 1
AND `content`.`content_type_id` = '8'
AND (content.content_status is null or content.content_status='Approved')
AND content.deleted_at is null
AND `content`.`parent_content_id` = '0'
AND content_type.deleted_at is null
ORDER BY `content`.`stick_ontop` DESC, `content`.`rank_order` DESC, `content`.`content_id` DESC
LIMIT 5
|
| 0.1160 |
SELECT *
FROM `content_value`
WHERE `content_id` IN('160', '161', '164', '167', '172')
ORDER BY `content_value_rank` ASC
|
| 0.0145 |
SELECT `content_type`.*, `users`.*, `content`.*
FROM `content`
JOIN `content_type` ON `content_type`.`content_type_id`=`content`.`content_type_id`
LEFT JOIN `users` ON `content`.`created_by`=`users`.`user_id`
WHERE `content`.`content_type_id` = 16
AND `content`.`content_published` = 1
AND (content.content_status is null or content.content_status='Approved')
AND content.deleted_at is null
AND `content`.`parent_content_id` = '0'
AND content_type.deleted_at is null
ORDER BY `content`.`stick_ontop` DESC, `content`.`rank_order` DESC, `content`.`content_id` DESC
LIMIT 12
|
| 0.1173 |
SELECT *
FROM `content_value`
WHERE `content_id` IN('1402', '1401', '1400', '1399', '1398', '213', '212', '136', '135', '72', '62', '61')
ORDER BY `content_value_rank` ASC
|
