| 0.0001 |
SELECT GET_LOCK('7l5mff6lgq938fps6f678ed9jr_18.97.14.84', 300) AS ci_session_lock
|
| 0.0002 |
SELECT `data`
FROM `ci_sessions`
WHERE `id` = '7l5mff6lgq938fps6f678ed9jr'
AND `ip_address` = '18.97.14.84'
|
| 0.0004 |
SELECT count(*) as cnt
FROM `content`
JOIN `content_type` ON `content_type`.`content_type_id`=`content`.`content_type_id`
WHERE `content`.`content_type_id` = 3
AND `content`.`content_published` = 1
AND (content.content_status is null or content.content_status='Approved')
AND content.deleted_at is null
AND content_type.deleted_at is null
ORDER BY `content`.`rank_order` DESC, `content`.`stick_ontop` DESC
|
| 0.0005 |
SELECT `content_type`.*, `content`.*
FROM `content`
JOIN `content_type` ON `content_type`.`content_type_id`=`content`.`content_type_id`
WHERE `content`.`content_type_id` = 3
AND `content`.`content_published` = 1
AND (content.content_status is null or content.content_status='Approved')
AND content.deleted_at is null
AND content_type.deleted_at is null
ORDER BY `content`.`rank_order` DESC, `content`.`stick_ontop` DESC
LIMIT 10
|
| 0.0040 |
SELECT *
FROM `content_value`
WHERE `content_id` IN('164', '161', '157', '156', '155', '152', '151', '146', '84', '67')
ORDER BY isnull(content_value_rank) ASC, `content_value_rank` ASC, `content_value_id` ASC
|
| 0.0005 |
SELECT `content_type`.*, `content`.*
FROM `content`
JOIN `content_type` ON `content_type`.`content_type_id`=`content`.`content_type_id`
WHERE `content`.`content_type_id` = 3
AND `content`.`content_published` = 1
AND (content.content_status is null or content.content_status='Approved')
AND content.deleted_at is null
AND content_type.deleted_at is null
ORDER BY `content`.`rank_order` DESC, `content`.`stick_ontop` DESC
LIMIT 5
|
| 0.0031 |
SELECT *
FROM `content_value`
WHERE `content_id` IN('164', '161', '157', '156', '155')
ORDER BY isnull(content_value_rank) ASC, `content_value_rank` ASC, `content_value_id` ASC
|
| 0.0002 |
SELECT *
FROM `region_master`
|
| 0.0004 |
SELECT *
FROM `block_visibility`
LEFT JOIN `block` ON `block_visibility`.`block_id`=`block`.`block_id`
JOIN `region_master` ON `region_master`.`region_master_id`=`block_visibility`.`region_id`
WHERE `block_visibility`.`enable` = '1'
AND block.deleted_at is null
AND block_visibility.deleted_at is null
ORDER BY `block_visibility`.`block_weight` ASC
|
| 0.0002 |
SELECT *
FROM `block`
WHERE `block_machine_name` = 'blog_random_album'
AND `block_type` = 'custom'
AND deleted_at is null
|
| 0.0035 |
SELECT `content`.*, `content_value`.*
FROM `content_value`
JOIN `content` ON `content_value`.`content_id` = `content`.`content_id`
WHERE `content`.`content_published` = 1
AND (content_value.field_machine_name ='display_image_3')
AND content_value.media_path IS NOT NULL
AND (content.content_status is null or content.content_status='Approved')
ORDER BY RAND(), isnull(content_value_rank) ASC, `content_value_rank` ASC, `content_value_id` ASC
LIMIT 30
|
| 0.0004 |
SELECT *
FROM `menu_link`
LEFT JOIN `media` ON `media`.`media_id`=`menu_link`.`icon_image`
WHERE `menu_master_id` = 1
AND `link_status` = 1
AND menu_link.deleted_at is null
ORDER BY `link_weight`
|
| 0.0001 |
SELECT *
FROM `region_master`
|
| 0.0003 |
SELECT *
FROM `block_visibility`
LEFT JOIN `block` ON `block_visibility`.`block_id`=`block`.`block_id`
JOIN `region_master` ON `region_master`.`region_master_id`=`block_visibility`.`region_id`
WHERE `block_visibility`.`enable` = '1'
AND block.deleted_at is null
AND block_visibility.deleted_at is null
ORDER BY `block_visibility`.`block_weight` ASC
|
| 0.0001 |
SELECT *
FROM `block`
WHERE `block_machine_name` = 'blog_random_album'
AND `block_type` = 'custom'
AND deleted_at is null
|
| 0.0030 |
SELECT `content`.*, `content_value`.*
FROM `content_value`
JOIN `content` ON `content_value`.`content_id` = `content`.`content_id`
WHERE `content`.`content_published` = 1
AND (content_value.field_machine_name ='display_image_3')
AND content_value.media_path IS NOT NULL
AND (content.content_status is null or content.content_status='Approved')
ORDER BY RAND(), isnull(content_value_rank) ASC, `content_value_rank` ASC, `content_value_id` ASC
LIMIT 30
|
