| 0.0002 |
SELECT GET_LOCK('r3dk67qi3fuba4u36aa1seuk4v_18.97.14.85', 300) AS ci_session_lock
|
| 0.0002 |
SELECT `data`
FROM `ci_sessions`
WHERE `id` = 'r3dk67qi3fuba4u36aa1seuk4v'
AND `ip_address` = '18.97.14.85'
|
| 0.0003 |
SELECT *
FROM `region_master`
|
| 0.0005 |
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.0003 |
SELECT *
FROM `block`
WHERE `block_machine_name` = 'blog_random_album'
AND `block_type` = 'custom'
AND deleted_at is null
|
| 0.0034 |
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.0005 |
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.0003 |
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.0024 |
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
|
