Search accommodation objects

Select your options

Object

Risika Stepanić Horvat

Kurija Morić Bedeković
User Avatar
  BENCHMARKS  
Loading Time: Base Classes  0.0066
Controller Execution Time ( Objects / Search )  0.0263
Total Execution Time  0.0332
  GET DATA  
$_GET['regionId']   10
  MEMORY USAGE  
1,550,664 bytes
  POST DATA  
No POST data exists
  URI STRING  
Accomodation/Objects/search
  CLASS/METHOD  
Objects/search
  DATABASE:  sinisadm_mareadria_booking (CI:$db)   QUERIES: 8 (0.0063 seconds)  (Hide)
0.0009   SELECT *
FROM `app_aobject` `o`
JOIN `sif_cities` `cON `c`.`cityId` = `o`.`cityId`
WHERE `regionId` = '10' 
0.0008   SELECT FROM sif_regions where regionId in (select regionId from app_aobject a inner join sif_cities c on a.cityId c.cityId)
0.0004   SELECT FROM sif_cities where cityId in (select cityId from app_aobject)
0.0006   SELECT FROM sif_islands where islandId in (select islandId from app_aobject)
0.0011   SELECT *
FROM `app_images`
WHERE `AobjectId` = '2'
AND `AunitIdIS NULL 
0.0006   SELECT *
FROM `std_agency`
WHERE `agencyId` = '2' 
0.0012   SELECT `account`.*
FROM `idem_account` `account`
JOIN `rel_account_agency` `relON `rel`.`accountId` = `account`.`accountId`
WHERE `rel`.`agencyId` = '2' 
0.0007   SELECT *
FROM `idem_account_details`
WHERE `accountId` = '12' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)