0.0001 |
SELECT GET_LOCK('pmu2g1a161fj58p4254780fgd5_18.97.9.170', 300) AS ci_session_lock
|
0.0008 |
SELECT `data` FROM `ci_sessions` WHERE `id` = 'pmu2g1a161fj58p4254780fgd5' AND `ip_address` = '18.97.9.170'
|
0.0031 |
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.0008 |
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.0027 |
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.0022 |
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.0007 |
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.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` = 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.0003 |
SELECT * FROM `region_master`
|
0.0006 |
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.0020 |
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('118', '120', '119', '117', '123') ORDER BY isnull(content_value_rank) ASC, `content_value_rank` ASC, `content_value_id` ASC
|
0.0009 |
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.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.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.0008 |
SELECT * FROM `content_value` WHERE `content_id` IN('120', '122', '121', '119', '125') ORDER BY isnull(content_value_rank) ASC, `content_value_rank` ASC, `content_value_id` ASC
|