The query took 0.000053 seconds to load.
/home/sewakost/webapps/sewakost/includes/classes/dbi.class.php(101) / function: query
SET sql_mode = ''
The query took 0.000122 seconds to load.
/home/sewakost/webapps/sewakost/includes/classes/reefless.class.php(98) / function: __construct
SELECT `Name`,`Class`,`Plugin`,`Code` FROM `fl_hooks` WHERE (`Status` = 'active')
The query took 0.000029 seconds to load.
/home/sewakost/webapps/sewakost/includes/classes/reefless.class.php(98) / function: __construct
SELECT `Default` FROM `fl_config` WHERE `Key` = 'cache_method' LIMIT 1
The query took 0.000082 seconds to load.
/home/sewakost/webapps/sewakost/includes/classes/rlConfig.class.php(91) / function: fetch
SELECT `Key`,`Default` FROM `fl_config`
The query took 0.000053 seconds to load.
/home/sewakost/webapps/sewakost/includes/classes/rlCommon.class.php(1224) / function: fetch
SELECT `Key`,`Version` FROM `fl_plugins` WHERE (`Status` = 'active')
The query took 0.002458 seconds to load.
/home/sewakost/webapps/sewakost/includes/classes/rlHook.class.php(140) / function: hookReeflessWwwRedirect
SELECT `T1`.*, `T2`.`Box_position`, `T2`.`Box_design`
FROM `fl_landing_pages_lang` AS `T1`
LEFT JOIN `fl_landing_pages` AS `T2` ON `T1`.`Page_ID` = `T2`.`ID`
WHERE `T1`.`Lang_code` = 'id' AND ((`Landing_path` = 'kost-jawa-timur/kost-kediri/jenis:Kost+Campur/aircon:0/kamar-mandi-dalam:0/price:500000-1000000/index2.html' ) OR (`Original_path` = 'kost-jawa-timur/kost-kediri/jenis:Kost+Campur/aircon:0/kamar-mandi-dalam:0/price:500000-1000000/index2.html' )) AND `T2`.`Status` = 'active'
LIMIT 1
The query took 0.000527 seconds to load.
/home/sewakost/webapps/sewakost/includes/classes/reefless.class.php(98) / function: __construct
SHOW COLUMNS FROM `fl_listings` LIKE 'price'
The query took 0.000046 seconds to load.
/home/sewakost/webapps/sewakost/plugins/categoryFilter/rlCategoryFilter.class.php(2413) / function: getAll
SELECT `Key` FROM `fl_listing_fields`
The query took 0.000032 seconds to load.
/home/sewakost/webapps/sewakost/includes/classes/dbi.class.php(385) / function: getAll
SELECT `Code`, IF(`Code` = "id", 1, 0) AS `Order`,`Key`,`Direction`,`Locale`,`Date_format`,`Status` FROM `fl_languages` WHERE (`Status` = 'active') ORDER BY `Order` DESC
The query took 0.000022 seconds to load.
/home/sewakost/webapps/sewakost/includes/classes/dbi.class.php(385) / function: getAll
SELECT `Key`,`Value`,`Code` FROM `fl_lang_keys` WHERE (`module` = 'common') AND `Key` LIKE 'languages+name+%'
The query took 0.000033 seconds to load.
/home/sewakost/webapps/sewakost/includes/classes/dbi.class.php(223) / function: query
SELECT `T1`.`Links_type`, `T1`.`Key`, `T2`.`Path` FROM `fl_listing_types` AS `T1` JOIN `fl_pages` AS `T2` ON `T2`.`Key` = CONCAT('lt_', `T1`.`Key`) WHERE (`Links_type` = 'short' OR `Links_type` = 'subdomain') AND `T1`.`Status` = 'active'
The query took 0.000034 seconds to load.
/home/sewakost/webapps/sewakost/includes/classes/dbi.class.php(302) / function: query
SELECT `Type` FROM `fl_categories` WHERE `Path` = 'kost-jawa-timur' AND ( `Type` = 'listings' OR `Type` = 'apartments' OR `Type` = 'kontrakan' ) LIMIT 1
The query took 0.000085 seconds to load.
/home/sewakost/webapps/sewakost/includes/classes/rlListingTypes.class.php(44) / function: get
SELECT `T1`.*, IF(`T2`.`Status` = 'active', 1, 0) AS `Advanced_search_availability` FROM `fl_listing_types` AS `T1` LEFT JOIN `fl_search_forms` AS `T2` ON `T1`.`Key` = `T2`.`Type` AND `T2`.`Mode` = 'advanced' WHERE `T1`.`Status` = 'active' ORDER BY `Order`
The query took 0.000038 seconds to load.
/home/sewakost/webapps/sewakost/includes/classes/rlAccountTypes.class.php(59) / function: get
SELECT `T1`.* FROM `fl_account_types` AS `T1` WHERE `T1`.`Status` = 'active' ORDER BY `Position`
The query took 0.000031 seconds to load.
/home/sewakost/webapps/sewakost/includes/classes/dbi.class.php(302) / function: query
SELECT * FROM `fl_pages` WHERE `Path` = CONVERT('kost' USING utf8) AND `Status` = 'active' LIMIT 1
The query took 0.000029 seconds to load.
/home/sewakost/webapps/sewakost/includes/utils/Category.php(843) / function: getCategory
SELECT `ID`,`Parent_ID`,`Parent_IDs`,`Path`,`Key`,`Count`,`Lock`,`Type`,`Level`,`Add`,`Status` FROM `fl_categories` WHERE (`Status` = 'active') AND (`Path` = 'kost-jawa-timur/kost-kediri') AND (`Type` = 'listings') LIMIT 1
The query took 0.000412 seconds to load.
/home/sewakost/webapps/sewakost/includes/utils/Category.php(843) / function: getCategory
SELECT `Key`,`Value`,`JS` FROM `fl_lang_keys` WHERE `Target_key` = '' AND `Module` = 'category' AND `Code` = 'id' AND `Status` = 'active'
The query took 0.000492 seconds to load.
/home/sewakost/webapps/sewakost/includes/classes/dbi.class.php(223) / function: query
SELECT `ID`, `Key`, `Side`, `Type`, `Content`, `Tpl`, `Header`, `Position`, `Plugin`, `Options` FROM `fl_blocks` WHERE `Status` = 'active' AND (FIND_IN_SET('68', `Category_ID`) > 0 OR (`Cat_sticky` = '1' AND FIND_IN_SET('307', `Page_ID`) > 0) OR ((FIND_IN_SET('19', `Category_ID`) > 0 AND `Subcategories` = '1'))) ORDER BY `Position`
The query took 0.000263 seconds to load.
/home/sewakost/webapps/sewakost/includes/classes/rlLang.class.php(202) / function: fetch
SELECT `Key`,`Value`,`JS` FROM `fl_lang_keys`
WHERE `Status` = 'active' AND `Code` = 'id'
AND
(
(
(`Module` = 'frontEnd' OR `Module` = 'common')
AND (`Target_key` = '' OR `Target_key` = 'listing_type')
)
OR (`Module` = 'box' AND `Target_key` IN ('ltcategories_listings','categoryFilter_18'))
)
The query took 0.000100 seconds to load.
/home/sewakost/webapps/sewakost/includes/classes/rlDb.class.php(567) / function: query
SET time_zone = '+7:00'
The query took 0.000037 seconds to load.
/home/sewakost/webapps/sewakost/includes/utils/Util.php(350) / function: getAll
SELECT `Key`, `Path` FROM `fl_pages` WHERE (`Status` = 'active')
The query took 0.000062 seconds to load.
/home/sewakost/webapps/sewakost/plugins/bankWireTransfer/rlBankWireTransfer.class.php(49) / function: loadClass
SELECT * FROM `fl_payment_gateways` WHERE `Status` = 'active'
The query took 0.000034 seconds to load.
/home/sewakost/webapps/sewakost/includes/classes/rlMembershipPlan.class.php(311) / function: getAll
SELECT * FROM `fl_membership_services` WHERE `Status` = 'active'
The query took 0.000034 seconds to load.
/home/sewakost/webapps/sewakost/includes/classes/rlCommon.class.php(151) / function: fetch
SELECT `ID`,`Page_type`,`Key`,`Path`,`Get_vars`,`Controller`,`No_follow`,`Menus`,`Deny`,`Login` FROM `fl_pages` WHERE (`Status` = 'active') ORDER BY `Position`
The query took 0.000057 seconds to load.
/home/sewakost/webapps/sewakost/includes/classes/rlHook.class.php(140) / function: hookSpecialBlock
SELECT * FROM `fl_multi_formats` WHERE `Key` = 'jenis_kost' AND `Status` = 'active' LIMIT 1
The query took 0.000024 seconds to load.
/home/sewakost/webapps/sewakost/includes/classes/rlCategories.class.php(1607) / function: getAll
SELECT * FROM `fl_data_formats` WHERE `Conversion` = '1' AND `Parent_ID` = 0
The query took 0.000027 seconds to load.
/home/sewakost/webapps/sewakost/includes/classes/rlSearch.class.php(983) / function: getOne
SELECT `Key` FROM `fl_search_forms` WHERE `Status` = 'active' AND `Category_ID` > 0 AND (`Subcategories` = '1' OR `Category_ID` = 68) AND `Category_ID` IN ('68','19') ORDER BY FIND_IN_SET(`Category_ID`, '68,19') ASC LIMIT 1
The query took 0.000042 seconds to load.
/home/sewakost/webapps/sewakost/includes/classes/rlListings.class.php(815) / function: load
SELECT `T1`.`ID`, `T2`.`ID` AS `Field_ID`, `T1`.`Items`, `T1`.`Item_names`, `T1`.`Items_display_limit`, `T1`.`Mode`, `T2`.`Key`, `T2`.`Type`, `T2`.`Condition`, `T2`.`Values`, CONCAT('listing_fields+name+', `T2`.`Key`) AS `pName`, `T1`.`No_index`, `T1`.`Data_in_title`, `T1`.`Data_in_description`, `T1`.`Data_in_H1` FROM `fl_category_filter_field` AS `T1` LEFT JOIN `fl_listing_fields` AS `T2` ON `T2`.`ID` = `T1`.`Field_ID` WHERE `T1`.`Box_ID` = 18 AND `T1`.`Status` = 'active' AND `T2`.`Status` = 'active' ORDER BY `T1`.`ID`
The query took 0.045970 seconds to load.
/home/sewakost/webapps/sewakost/includes/classes/rlListings.class.php(867) / function: getAll
SELECT SQL_CALC_FOUND_ROWS IF (FIND_IN_SET('68', `T1`.`Crossed`) > 0, 1, 0) AS `Crossed_listing`, `T1`.*, `T3`.`Key` AS `Key`, `T3`.`Type` AS `Listing_type`, `T3`.`Parent_keys`, `T3`.`Parent_IDs`, `T3`.`Path` AS `Path`, IF(`T1`.`Featured_date` <> '0000-00-00 00:00:00', '1', '0') `Featured` FROM `fl_listings` AS `T1` LEFT JOIN `fl_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` WHERE `T1`.`Status` = 'active' AND (`T1`.`Category_ID` = '68' OR (FIND_IN_SET('68', `T1`.`Crossed`) > 0) OR FIND_IN_SET('68', `T3`.`Parent_IDs`) > 0 ) AND `T1`.`jenis` = 'jenis_kost_jenis_kost_pria_wanita' AND `T1`.`aircon` = '0' AND `T1`.`kamar_mandi_dalam` = '0' AND (ROUND(`T1`.`price`, 2) >= 500000 AND ROUND(`T1`.`price`, 2) <= 1000000) AND ((`T1`.`Category_ID` = 68 OR FIND_IN_SET(68, `T3`.`Parent_IDs`) > 0) OR (FIND_IN_SET(68, `T1`.`Crossed`) > 0)) ORDER BY `Featured_date` DESC , `T1`.`date` DESC LIMIT 24, 24