0.0002 |
SELECT GET_LOCK('sakqdlib1kkfdk75ousdlm8n4i_3.15.141.151', 300) AS ci_session_lock
|
0.0002 |
SELECT `data` FROM `ci_sessions` WHERE `id` = 'sakqdlib1kkfdk75ousdlm8n4i' AND `ip_address` = '3.15.141.151'
|
0.0005 |
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.0006 |
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.0051 |
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.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` = 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.0023 |
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.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.0019 |
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 `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.0026 |
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
|