Search accommodation objects

  1. Objects
  2. Search accommodation objects
  3. Form

Select your options

Items that can get search results are listed. Country chosen may have more regions, cities and islands.

Object

Apartmani Meleh

Apartmani Meleh, kuće Crikvenica
User Avatar

3
UNITS

Object

Risika Stepanić Horvat

Apartmani Stepanić Horvat
User Avatar

3
UNITS
  BENCHMARKS  
Loading Time: Base Classes  0.0100
Controller Execution Time ( Objects / Search )  0.0200
Total Execution Time  0.0303
  GET DATA  
$_GET['regionId']   7
  MEMORY USAGE  
4,731,368 bytes
  POST DATA  
No POST data exists
  URI STRING  
Accomodation/Objects/search
  CLASS/METHOD  
Objects/search
  DATABASE:  sinisadm_mareadria_booking (CI:$db)   QUERIES: 12 (0.0028 seconds)  (Hide)
0.0010   SELECT *
FROM `app_aobject` `o`
JOIN `sif_cities` `c` ON `c`.`cityId` = `o`.`cityId`
WHERE `regionId` = '7' 
0.0003   SELECT * FROM sif_regions where regionId in (select regionId from app_aobject a inner join sif_cities c on a.cityId = c.cityId); 
0.0002   SELECT * FROM sif_cities where cityId in (select cityId from app_aobject); 
0.0002   SELECT * FROM sif_islands where islandId in (select islandId from app_aobject); 
0.0002   SELECT *
FROM `app_images`
WHERE `AobjectId` = '1'
AND `AunitId` IS NULL 
0.0001   SELECT *
FROM `std_agency`
WHERE `agencyId` = '1' 
0.0002   SELECT `account`.*
FROM `idem_account` `account`
JOIN `rel_account_agency` `rel` ON `rel`.`accountId` = `account`.`accountId`
WHERE `rel`.`agencyId` = '1' 
0.0001   SELECT *
FROM `idem_account_details`
WHERE `accountId` = '13' 
0.0001   SELECT *
FROM `app_images`
WHERE `AobjectId` = '3'
AND `AunitId` IS NULL 
0.0001   SELECT *
FROM `std_agency`
WHERE `agencyId` = '2' 
0.0001   SELECT `account`.*
FROM `idem_account` `account`
JOIN `rel_account_agency` `rel` ON `rel`.`accountId` = `account`.`accountId`
WHERE `rel`.`agencyId` = '2' 
0.0001   SELECT *
FROM `idem_account_details`
WHERE `accountId` = '12' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)