| 0.0017 |
SELECT `u`.*
FROM `app_aobject` `o`
JOIN `sif_cities` `c` ON `c`.`cityId` = `o`.`cityId`
JOIN `app_aunit` `u` ON `u`.`objectId` = `o`.`aObjectId`
WHERE `regionId` = '10' AND NOT EXISTS (SELECT 1 FROM app_booking ab WHERE
u.aUnitId = ab.aUnitId
and ((fromDate >= '' and fromDate <= '')
or (toDate >= '' and toDate <= '')))
|
| 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.0005 |
SELECT * FROM sif_cities where cityId in (select cityId from app_aobject);
|
| 0.0005 |
SELECT * FROM sif_islands where islandId in (select islandId from app_aobject);
|
| 0.0006 |
SELECT *
FROM `app_unit_types`
WHERE `active` = 1
|
| 0.0004 |
SELECT *
FROM `app_aobject`
WHERE `aObjectId` = '2'
|
| 0.0004 |
SELECT *
FROM `app_aunit`
WHERE `objectId` = '2'
|
| 0.0010 |
SELECT *
FROM `app_images`
WHERE `aUnitId` = '3'
|
| 0.0008 |
SELECT *
FROM `app_aunit_infield`
WHERE `aUnitId` = '3'
|
| 0.0008 |
SELECT *
FROM `app_aunit_add_offer`
WHERE `aUnitId` = '3'
|
| 0.0003 |
SELECT *
FROM `app_unit_types`
WHERE `unitTypeId` = '1'
|
| 0.0006 |
SELECT *
FROM `sif_toilet_status`
WHERE `toiletStatusId` = '2'
|
| 0.0004 |
SELECT *
FROM `app_booking`
WHERE `aUnitId` = '3'
|
| 0.0007 |
SELECT *
FROM `app_discounts`
WHERE `unitId` = '3'
|
| 0.0006 |
SELECT *
FROM `app_prices`
WHERE `unitId` = '3'
|
| 0.0005 |
SELECT *
FROM `app_images`
WHERE `AobjectId` = '2'
AND `AunitId` IS NULL
|
| 0.0006 |
SELECT *
FROM `app_object_types`
WHERE `objectTypeId` = '1'
|
| 0.0007 |
SELECT *
FROM `app_object_distance` `aod`
WHERE `aObjectId` = '2'
|
| 0.0007 |
SELECT *
FROM `sif_postanski_brojevi`
WHERE `postanskiBrojId` = '492'
|
| 0.0003 |
SELECT *
FROM `sif_cities`
WHERE `cityId` = '1048'
|
| 0.0007 |
SELECT *
FROM `std_place`
WHERE `cityId` = '1048'
|
| 0.0007 |
SELECT *
FROM `sif_countries`
WHERE `countryId` = '1'
|
| 0.0006 |
SELECT *
FROM `sif_continents`
WHERE `continentId` = '5'
|
| 0.0002 |
SELECT *
FROM `sif_islands`
WHERE `islandId` IS NULL
|
| 0.0006 |
SELECT *
FROM `std_agency`
WHERE `agencyId` = '2'
|
| 0.0010 |
SELECT `account`.*
FROM `idem_account` `account`
JOIN `rel_account_agency` `rel` ON `rel`.`accountId` = `account`.`accountId`
WHERE `rel`.`agencyId` = '2'
|
| 0.0007 |
SELECT *
FROM `idem_account_details`
WHERE `accountId` = '12'
|
