Project

General

Profile

Feature #2265

Optimize a generation of the block 'Quick Search'

Added by Batyr Mackenov almost 4 years ago. Updated almost 4 years ago.

Status:
Closed
Priority:
Normal
Target version:
Start date:
October 29, 2015
Due date:
% Done:

100%

Estimated time:

Description

Optimize the SQL queries.
Now it uses too much similar queries:

SELECT `values` FROM `sbr_fields` WHERE `name` = 'type' AND `item` = 'estates' LIMIT 0, 1
SELECT `values` FROM `sbr_fields` WHERE `name` = 'bathrooms' AND `item` = 'estates' LIMIT 0, 1
SELECT `values` FROM `sbr_fields` WHERE `name` = 'bedrooms' AND `item` = 'estates' LIMIT 0, 1
SELECT `values` FROM `sbr_fields` WHERE `name` = 'category' AND `item` = 'estates' LIMIT 0, 1

History

#1

Updated by Batyr Mackenov almost 4 years ago

  • Status changed from New to Closed
  • % Done changed from 0 to 100

Done in 2f516ac

Also available in: Atom PDF