| 0.0001 |
SELECT GET_LOCK('gg73i5nttd8o55svvq4s7tf1nq_18.226.4.249', 300) AS ci_session_lock
|
| 0.0001 |
SELECT `data`
FROM `ci_sessions`
WHERE `id` = 'gg73i5nttd8o55svvq4s7tf1nq'
AND `ip_address` = '18.226.4.249'
|
| 0.0019 |
SELECT `content_type`.*, `content_value`.*, `content`.*
FROM `content_value`
JOIN `content` ON `content_value`.`content_id` = `content`.`content_id`
JOIN `content_type` ON `content_type`.`content_type_id` = `content`.`content_type_id`
WHERE `content_value`.`content_value` = '2'
AND `content_value`.`field_machine_name` = 'blog_category_4'
AND `content`.`content_type_id` = 4
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
GROUP BY `content`.`content_id`
ORDER BY `content`.`rank_order` DESC, `content`.`stick_ontop` DESC
|
| 0.0009 |
SELECT *
FROM `content_value`
WHERE `content_id` IN('9', '8')
ORDER BY isnull(content_value_rank) ASC, `content_value_rank` ASC, `content_value_id` ASC
|
| 0.0021 |
SELECT `content_type`.*, `content_value`.*, `content`.*
FROM `content_value`
JOIN `content` ON `content_value`.`content_id` = `content`.`content_id`
JOIN `content_type` ON `content_type`.`content_type_id` = `content`.`content_type_id`
WHERE `content_value`.`content_value` = '2'
AND `content_value`.`field_machine_name` = 'blog_type_3'
AND `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
GROUP BY `content`.`content_id`
ORDER BY `content`.`rank_order` DESC, `content`.`stick_ontop` DESC
|
| 0.0020 |
SELECT `content_type`.*, `content_value`.*, `content`.*
FROM `content_value`
JOIN `content` ON `content_value`.`content_id` = `content`.`content_id`
JOIN `content_type` ON `content_type`.`content_type_id` = `content`.`content_type_id`
WHERE `content_value`.`content_value` = '2'
AND `content_value`.`field_machine_name` = 'blog_type_3'
AND `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
GROUP BY `content`.`content_id`
ORDER BY `content`.`rank_order` DESC, `content`.`stick_ontop` DESC
LIMIT 15
|
| 0.0064 |
SELECT *
FROM `content_value`
WHERE `content_id` IN('164', '161', '146', '84', '67', '65', '81', '42', '83', '63', '140', '85', '68', '113', '75')
ORDER BY isnull(content_value_rank) ASC, `content_value_rank` ASC, `content_value_id` ASC
|
| 0.0004 |
SELECT `content_type`.*, `content`.*
FROM `content`
JOIN `content_type` ON `content_type`.`content_type_id`=`content`.`content_type_id`
WHERE `content`.`content_type_id` = 7
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.0010 |
SELECT *
FROM `content_value`
WHERE `content_id` IN('182', '112', '111', '99', '101')
ORDER BY isnull(content_value_rank) ASC, `content_value_rank` ASC, `content_value_id` ASC
|
| 0.0003 |
SELECT `content_type`.*, `content`.*
FROM `content`
JOIN `content_type` ON `content_type`.`content_type_id`=`content`.`content_type_id`
WHERE `content`.`content_type_id` = 8
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.0009 |
SELECT *
FROM `content_value`
WHERE `content_id` IN('125', '123', '119', '114', '121', '115', '117', '122', '120', '116', '118')
ORDER BY isnull(content_value_rank) ASC, `content_value_rank` ASC, `content_value_id` ASC
|
| 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.0018 |
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.0002 |
SELECT *
FROM `block`
WHERE `block_machine_name` = 'top_wedding'
AND `block_type` = 'custom'
AND deleted_at is null
|
| 0.0011 |
SELECT `content_type`.*, `content`.*
FROM `content`
JOIN `content_type` ON `content_type`.`content_type_id`=`content`.`content_type_id`
WHERE `content`.`content_type_id` = 8
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 RAND(), `content`.`rank_order` DESC, `content`.`stick_ontop` DESC
LIMIT 5
|
| 0.0009 |
SELECT *
FROM `content_value`
WHERE `content_id` IN('118', '120', '121', '117', '114')
ORDER BY isnull(content_value_rank) ASC, `content_value_rank` ASC, `content_value_id` ASC
|
| 0.0003 |
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.0002 |
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.0018 |
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.0001 |
SELECT *
FROM `block`
WHERE `block_machine_name` = 'top_wedding'
AND `block_type` = 'custom'
AND deleted_at is null
|
| 0.0008 |
SELECT `content_type`.*, `content`.*
FROM `content`
JOIN `content_type` ON `content_type`.`content_type_id`=`content`.`content_type_id`
WHERE `content`.`content_type_id` = 8
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 RAND(), `content`.`rank_order` DESC, `content`.`stick_ontop` DESC
LIMIT 5
|
| 0.0009 |
SELECT *
FROM `content_value`
WHERE `content_id` IN('125', '119', '116', '117', '122')
ORDER BY isnull(content_value_rank) ASC, `content_value_rank` ASC, `content_value_id` ASC
|
