| 0.0002 |
SELECT GET_LOCK('f7302391a204e455272359ce6d757bef2c385a9f', 300) AS ci_session_lock
|
| 0.0018 |
SELECT `data`
FROM `ci_sessions`
WHERE `id` = 'f7302391a204e455272359ce6d757bef2c385a9f'
|
| 0.0006 |
SELECT `id`, `language_name`
FROM `languages`
WHERE `slug` = 'es'
|
| 0.0006 |
SELECT `articleID`, `title`, `languageID`, `value`, `url`, `seoTitle`, `seoDescription`, `seoKeywords`, `accountID`, `typeID`, `webstatusID`, `categoryID`, `dateCreated`
FROM `articles`
WHERE `languageID` = '2'
AND `url` = 'index'
AND `accountID` = 7
|
| 0.0008 |
SELECT `articles`.`articleID`, `articles`.`title`, `articles`.`url`, `articles`.`dateCreated`, `categories`.`label` as `category`, `webstatus`.`label` as `webstatus`, `articles`.`languageID`, `articles`.`excerpt`
FROM `articles`
JOIN `categories` ON `categories`.`categoryID` = `articles`.`categoryID` AND `categories`.`languageID` = '2' AND `categories`.`moduleID` = 6
JOIN `webstatus` ON `webstatus`.`statusID` = `articles`.`webstatusID` AND `webstatus`.`languageID` = '2'
WHERE `articles`.`categoryID` = 2
AND `articles`.`languageID` = '2'
AND `articles`.`accountID` =0
ORDER BY `articles`.`dateCreated` DESC
LIMIT 3
|
| 0.0015 |
SELECT `banners`.`bannerID`, `banners`.`typeID`, `banner_notes`.`value` as `label`, `banners`.`typeID`, `banner_types`.`label` as `type`, `banners`.`webstatusID`, `webstatus`.`label` as `webstatus`, `banners`.`ordinal`, `banner_resources`.`file`, `banner_resources`.`galleryID`, `bn1`.`value` as `text_1`, `bn2`.`value` as `text_2`, `bn3`.`value` as `text_3`
FROM `banners`
LEFT JOIN `banner_notes` ON `banner_notes`.`bannerID` = `banners`.`bannerID` AND `banner_notes`.`languageID` = '2' AND `banner_notes`.`labelID` = '1'
LEFT JOIN `banner_notes` as `bn1` ON `bn1`.`bannerID` = `banners`.`bannerID` AND `bn1`.`languageID` = '2' AND `bn1`.`labelID` = '2'
LEFT JOIN `banner_notes` as `bn2` ON `bn2`.`bannerID` = `banners`.`bannerID` AND `bn2`.`languageID` = '2' AND `bn2`.`labelID` = '3'
LEFT JOIN `banner_notes` as `bn3` ON `bn3`.`bannerID` = `banners`.`bannerID` AND `bn3`.`languageID` = '2' AND `bn3`.`labelID` = '4'
JOIN `banner_types` ON `banner_types`.`bannerTypeID` = `banners`.`typeID` AND `banner_types`.`languageID` = '2'
JOIN `banner_resources` ON `banner_resources`.`bannerID` = `banners`.`bannerID`
JOIN `webstatus` ON `webstatus`.`statusID` = `banners`.`webstatusID` AND `webstatus`.`languageID` = '2'
WHERE `banners`.`typeID` = 1
ORDER BY `banners`.`ordinal` ASC
|
| 0.0846 |
SELECT `properties`.`propertyID`, `properties`.`internalRef`, `properties`.`externalRef`, `properties`.`bedrooms`, `properties`.`bathrooms`, `properties`.`salePrice`, `properties`.`rentPrice`, `properties`.`salePriceCurrencyID`, `properties`.`rentPriceCurrencyID`, `properties`.`termID`, `locations`.`label` as `location`, `municipalities`.`label` as `municipality`, `regions`.`label` as `region`, `property_types`.`label` as `type`, `properties`.`interior`, `properties`.`exterior`, `terms`.`label` as `term`, `property_resources`.`galleryID`, `property_resources`.`file`, `properties`.`accountID`, `energy_certificates`.`code` as `ecert`, `tags`.`label` as `tag`, `complexes`.`label` as `complex`, `property_notes`.`value` as `intro`
FROM `properties`
JOIN `property_types` ON `property_types`.`propertyTypeID` = `properties`.`typeID` AND `property_types`.`languageID` = '2'
JOIN `property_notes` ON `property_notes`.`propertyID` = `properties`.`propertyID` AND `property_notes`.`languageID` = '2' AND `property_notes`.`labelID` = 1
JOIN `property_resources` ON `property_resources`.`propertyID` = `properties`.`propertyID` AND `property_resources`.`galleryID` = '1' AND `property_resources`.`ordinal` = (SELECT MIN(property_resources.ordinal) FROM property_resources WHERE property_resources.propertyID = properties.propertyID AND `property_resources`.`galleryID` = '1' AND `property_resources`.`typeID` = '1')
JOIN `locations` ON `locations`.`locationID` = `properties`.`locationID`
JOIN `status` ON `status`.`statusID` = `properties`.`statusID` AND `status`.`languageID` = '2' AND `status`.`moduleID` = '3'
JOIN `terms` ON `terms`.`termID` = `properties`.`termID` AND `terms`.`languageID` = '2'
JOIN `municipalities` ON `municipalities`.`municipalityID` = `locations`.`municipalityID`
JOIN `regions` ON `regions`.`regionID` = `municipalities`.`regionID`
LEFT JOIN `complexes` ON `complexes`.`complexID` = `properties`.`complexID`
JOIN `energy_certificates` ON `energy_certificates`.`ecertID` = `properties`.`ecert`
LEFT JOIN `tags` ON `tags`.`tagID` = `properties`.`tagID` AND `tags`.`categoryID` = '9' AND `tags`.`languageID` = '2' AND `tags`.`moduleID` = '3'
WHERE `properties`.`termID` = 1
AND `properties`.`accountID` = 7
AND `properties`.`webstatusID` = 2
ORDER BY `properties`.`ordinal` ASC
LIMIT 6
|
| 0.0258 |
SELECT `properties`.`propertyID`, `properties`.`internalRef`, `properties`.`externalRef`, `properties`.`bedrooms`, `properties`.`bathrooms`, `properties`.`salePrice`, `properties`.`rentPrice`, `properties`.`salePriceCurrencyID`, `properties`.`rentPriceCurrencyID`, `properties`.`termID`, `locations`.`label` as `location`, `municipalities`.`label` as `municipality`, `regions`.`label` as `region`, `property_types`.`label` as `type`, `properties`.`interior`, `properties`.`exterior`, `terms`.`label` as `term`, `property_resources`.`galleryID`, `property_resources`.`file`, `properties`.`accountID`, `energy_certificates`.`code` as `ecert`, `tags`.`label` as `tag`, `complexes`.`label` as `complex`, `property_notes`.`value` as `intro`
FROM `properties`
JOIN `property_types` ON `property_types`.`propertyTypeID` = `properties`.`typeID` AND `property_types`.`languageID` = '2'
JOIN `property_notes` ON `property_notes`.`propertyID` = `properties`.`propertyID` AND `property_notes`.`languageID` = '2' AND `property_notes`.`labelID` = 1
JOIN `property_resources` ON `property_resources`.`propertyID` = `properties`.`propertyID` AND `property_resources`.`galleryID` = '1' AND `property_resources`.`ordinal` = (SELECT MIN(property_resources.ordinal) FROM property_resources WHERE property_resources.propertyID = properties.propertyID AND `property_resources`.`galleryID` = '1' AND `property_resources`.`typeID` = '1')
JOIN `locations` ON `locations`.`locationID` = `properties`.`locationID`
JOIN `status` ON `status`.`statusID` = `properties`.`statusID` AND `status`.`languageID` = '2' AND `status`.`moduleID` = '3'
JOIN `terms` ON `terms`.`termID` = `properties`.`termID` AND `terms`.`languageID` = '2'
JOIN `municipalities` ON `municipalities`.`municipalityID` = `locations`.`municipalityID`
JOIN `regions` ON `regions`.`regionID` = `municipalities`.`regionID`
LEFT JOIN `complexes` ON `complexes`.`complexID` = `properties`.`complexID`
JOIN `energy_certificates` ON `energy_certificates`.`ecertID` = `properties`.`ecert`
LEFT JOIN `tags` ON `tags`.`tagID` = `properties`.`tagID` AND `tags`.`categoryID` = '9' AND `tags`.`languageID` = '2' AND `tags`.`moduleID` = '3'
WHERE `properties`.`termID` = 2
AND `properties`.`accountID` = 7
AND `properties`.`webstatusID` = 2
ORDER BY `properties`.`ordinal` ASC
LIMIT 6
|
| 0.0117 |
SELECT `properties`.`propertyID`, `properties`.`internalRef`, `properties`.`externalRef`, `properties`.`bedrooms`, `properties`.`bathrooms`, `properties`.`salePrice`, `properties`.`rentPrice`, `properties`.`salePriceCurrencyID`, `properties`.`rentPriceCurrencyID`, `properties`.`termID`, `locations`.`label` as `location`, `municipalities`.`label` as `municipality`, `regions`.`label` as `region`, `property_types`.`label` as `type`, `properties`.`interior`, `properties`.`exterior`, `terms`.`label` as `term`, `property_resources`.`galleryID`, `property_resources`.`file`, `properties`.`accountID`, `energy_certificates`.`code` as `ecert`, `tags`.`label` as `tag`, `complexes`.`label` as `complex`, `property_notes`.`value` as `intro`
FROM `properties`
JOIN `property_types` ON `property_types`.`propertyTypeID` = `properties`.`typeID` AND `property_types`.`languageID` = '2'
JOIN `property_notes` ON `property_notes`.`propertyID` = `properties`.`propertyID` AND `property_notes`.`languageID` = '2' AND `property_notes`.`labelID` = 1
JOIN `property_resources` ON `property_resources`.`propertyID` = `properties`.`propertyID` AND `property_resources`.`galleryID` = '1' AND `property_resources`.`ordinal` = (SELECT MIN(property_resources.ordinal) FROM property_resources WHERE property_resources.propertyID = properties.propertyID AND `property_resources`.`galleryID` = '1' AND `property_resources`.`typeID` = '1')
JOIN `locations` ON `locations`.`locationID` = `properties`.`locationID`
JOIN `status` ON `status`.`statusID` = `properties`.`statusID` AND `status`.`languageID` = '2' AND `status`.`moduleID` = '3'
JOIN `terms` ON `terms`.`termID` = `properties`.`termID` AND `terms`.`languageID` = '2'
JOIN `municipalities` ON `municipalities`.`municipalityID` = `locations`.`municipalityID`
JOIN `regions` ON `regions`.`regionID` = `municipalities`.`regionID`
LEFT JOIN `complexes` ON `complexes`.`complexID` = `properties`.`complexID`
JOIN `energy_certificates` ON `energy_certificates`.`ecertID` = `properties`.`ecert`
LEFT JOIN `tags` ON `tags`.`tagID` = `properties`.`tagID` AND `tags`.`categoryID` = '9' AND `tags`.`languageID` = '2' AND `tags`.`moduleID` = '3'
WHERE `properties`.`termID` = 3
AND `properties`.`accountID` = 7
AND `properties`.`webstatusID` = 2
ORDER BY `properties`.`ordinal` ASC
LIMIT 6
|
| 0.0143 |
SELECT `properties`.`propertyID`, `properties`.`internalRef`, `properties`.`externalRef`, `properties`.`bedrooms`, `properties`.`bathrooms`, `properties`.`salePrice`, `properties`.`rentPrice`, `properties`.`salePriceCurrencyID`, `properties`.`rentPriceCurrencyID`, `properties`.`termID`, `locations`.`label` as `location`, `municipalities`.`label` as `municipality`, `regions`.`label` as `region`, `property_types`.`label` as `type`, `properties`.`interior`, `properties`.`exterior`, `terms`.`label` as `term`, `property_resources`.`galleryID`, `property_resources`.`file`, `properties`.`accountID`, `energy_certificates`.`code` as `ecert`, `tags`.`label` as `tag`, `complexes`.`label` as `complex`, `property_notes`.`value` as `intro`
FROM `properties`
JOIN `property_types` ON `property_types`.`propertyTypeID` = `properties`.`typeID` AND `property_types`.`languageID` = '2'
JOIN `property_notes` ON `property_notes`.`propertyID` = `properties`.`propertyID` AND `property_notes`.`languageID` = '2' AND `property_notes`.`labelID` = 1
JOIN `property_resources` ON `property_resources`.`propertyID` = `properties`.`propertyID` AND `property_resources`.`galleryID` = '3' AND `property_resources`.`ordinal` = (SELECT MIN(property_resources.ordinal) FROM property_resources WHERE property_resources.propertyID = properties.propertyID AND `property_resources`.`galleryID` = '3' AND `property_resources`.`typeID` = '1')
JOIN `locations` ON `locations`.`locationID` = `properties`.`locationID`
JOIN `status` ON `status`.`statusID` = `properties`.`statusID` AND `status`.`languageID` = '2' AND `status`.`moduleID` = '3'
JOIN `terms` ON `terms`.`termID` = `properties`.`termID` AND `terms`.`languageID` = '2'
JOIN `municipalities` ON `municipalities`.`municipalityID` = `locations`.`municipalityID`
JOIN `regions` ON `regions`.`regionID` = `municipalities`.`regionID`
LEFT JOIN `complexes` ON `complexes`.`complexID` = `properties`.`complexID`
JOIN `energy_certificates` ON `energy_certificates`.`ecertID` = `properties`.`ecert`
LEFT JOIN `tags` ON `tags`.`tagID` = `properties`.`tagID` AND `tags`.`categoryID` = '9' AND `tags`.`languageID` = '2' AND `tags`.`moduleID` = '3'
WHERE `properties`.`tagID` = 1
AND `properties`.`accountID` = 7
AND `properties`.`webstatusID` = 2
ORDER BY `properties`.`salePrice` ASC
LIMIT 6
|
| 0.0014 |
SELECT `properties`.`propertyID`, `properties`.`internalRef`, `properties`.`externalRef`, `properties`.`bedrooms`, `properties`.`bathrooms`, `properties`.`salePrice`, `properties`.`rentPrice`, `properties`.`salePriceCurrencyID`, `properties`.`rentPriceCurrencyID`, `properties`.`termID`, `locations`.`label` as `location`, `municipalities`.`label` as `municipality`, `regions`.`label` as `region`, `property_types`.`label` as `type`, `properties`.`interior`, `properties`.`exterior`, `terms`.`label` as `term`, `property_resources`.`galleryID`, `property_resources`.`file`, `properties`.`accountID`, `energy_certificates`.`code` as `ecert`, `tags`.`label` as `tag`, `complexes`.`label` as `complex`, `property_notes`.`value` as `intro`
FROM `properties`
JOIN `property_types` ON `property_types`.`propertyTypeID` = `properties`.`typeID` AND `property_types`.`languageID` = '2'
JOIN `property_notes` ON `property_notes`.`propertyID` = `properties`.`propertyID` AND `property_notes`.`languageID` = '2' AND `property_notes`.`labelID` = 1
JOIN `property_resources` ON `property_resources`.`propertyID` = `properties`.`propertyID` AND `property_resources`.`galleryID` = '1' AND `property_resources`.`ordinal` = (SELECT MIN(property_resources.ordinal) FROM property_resources WHERE property_resources.propertyID = properties.propertyID AND `property_resources`.`galleryID` = '1' AND `property_resources`.`typeID` = '1')
JOIN `locations` ON `locations`.`locationID` = `properties`.`locationID`
JOIN `status` ON `status`.`statusID` = `properties`.`statusID` AND `status`.`languageID` = '2' AND `status`.`moduleID` = '3'
JOIN `terms` ON `terms`.`termID` = `properties`.`termID` AND `terms`.`languageID` = '2'
JOIN `municipalities` ON `municipalities`.`municipalityID` = `locations`.`municipalityID`
JOIN `regions` ON `regions`.`regionID` = `municipalities`.`regionID`
LEFT JOIN `complexes` ON `complexes`.`complexID` = `properties`.`complexID`
JOIN `energy_certificates` ON `energy_certificates`.`ecertID` = `properties`.`ecert`
JOIN `tags` ON `tags`.`tagID` = `properties`.`tagID` AND `tags`.`categoryID` = '9' AND `tags`.`languageID` = '2' AND `tags`.`moduleID` = '3'
WHERE `properties`.`tagID` = 2
AND `properties`.`accountID` = 7
AND `properties`.`webstatusID` = 2
ORDER BY `properties`.`salePrice` ASC
LIMIT 4
|
| 0.0009 |
SELECT `locations`.`locationID`, `locations`.`label` as `location`, `municipalities`.`label` as `municipality`, `regions`.`label` as `region`
FROM `locations`
JOIN `municipalities` ON `municipalities`.`municipalityID` = `locations`.`municipalityID`
JOIN `regions` ON `regions`.`regionID` = `municipalities`.`regionID`
JOIN `properties` ON `properties`.`locationID` = `locations`.`locationID` AND `properties`.`accountID` = '7'
GROUP BY `locations`.`locationID`
ORDER BY `locations`.`label` ASC, `municipalities`.`label` ASC, `regions`.`label` ASC
|
| 0.0003 |
SELECT `propertyTypeID`, `label`
FROM `property_types`
WHERE `languageID` = '2'
ORDER BY `label` ASC
|
| 0.0002 |
SELECT `termID`, `label`
FROM `terms`
WHERE `languageID` = '2'
ORDER BY `label` DESC
|
