Buscador Avanzado

Time of execution: 0,19443392753601
Memory Usage: 885,36 kb
Connections to database: 1
QUERIES

Error	Query	Results	Time	Insert ID	Fields	Affected Rows
0	SELECT DISTINCT prop_properties.city_id FROM prop_properties INNER JOIN `geo_cities` ON prop_properties.city_id = geo_cities.city_id WHERE 1 = 1 AND prop_properties.property_status = 'A' ORDER BY city_name	25	9,608268737793E-5		1
0	SHOW COLUMNS FROM geo_cities		0,0011420249938965
0	SELECT city_id, city_name, state_id FROM geo_cities WHERE city_id = '468'	1	7,7962875366211E-5		3
0	SELECT city_id, city_name, state_id FROM geo_cities WHERE city_id = '540'	1	6,5088272094727E-5		3
0	SELECT city_id, city_name, state_id FROM geo_cities WHERE city_id = '154'	1	6,6995620727539E-5		3
0	SELECT city_id, city_name, state_id FROM geo_cities WHERE city_id = '476'	1	7,2002410888672E-5		3
0	SELECT city_id, city_name, state_id FROM geo_cities WHERE city_id = '1005'	1	8,2015991210938E-5		3
0	SELECT city_id, city_name, state_id FROM geo_cities WHERE city_id = '966'	1	7,1048736572266E-5		3
0	SELECT city_id, city_name, state_id FROM geo_cities WHERE city_id = '160'	1	8,1062316894531E-5		3
0	SELECT city_id, city_name, state_id FROM geo_cities WHERE city_id = '486'	1	7,6055526733398E-5		3
0	SELECT city_id, city_name, state_id FROM geo_cities WHERE city_id = '502'	1	7,2956085205078E-5		3
0	SELECT city_id, city_name, state_id FROM geo_cities WHERE city_id = '506'	1	7,7962875366211E-5		3
0	SELECT city_id, city_name, state_id FROM geo_cities WHERE city_id = '508'	1	7,8201293945312E-5		3
0	SELECT city_id, city_name, state_id FROM geo_cities WHERE city_id = '513'	1	7,6055526733398E-5		3
0	SELECT city_id, city_name, state_id FROM geo_cities WHERE city_id = '4'	1	6,7949295043945E-5		3
0	SELECT city_id, city_name, state_id FROM geo_cities WHERE city_id = '526'	1	7,0095062255859E-5		3
0	SELECT city_id, city_name, state_id FROM geo_cities WHERE city_id = '528'	1	7,2002410888672E-5		3
0	SELECT city_id, city_name, state_id FROM geo_cities WHERE city_id = '833'	1	7,2002410888672E-5		3
0	SELECT city_id, city_name, state_id FROM geo_cities WHERE city_id = '1087'	1	6,6041946411133E-5		3
0	SELECT city_id, city_name, state_id FROM geo_cities WHERE city_id = '547'	1	6,7949295043945E-5		3
0	SELECT city_id, city_name, state_id FROM geo_cities WHERE city_id = '548'	1	6,4849853515625E-5		3
0	SELECT city_id, city_name, state_id FROM geo_cities WHERE city_id = '552'	1	7,4148178100586E-5		3
0	SELECT city_id, city_name, state_id FROM geo_cities WHERE city_id = '554'	1	6,1988830566406E-5		3
0	SELECT city_id, city_name, state_id FROM geo_cities WHERE city_id = '562'	1	6,6995620727539E-5		3
0	SELECT city_id, city_name, state_id FROM geo_cities WHERE city_id = '570'	1	6,7949295043945E-5		3
0	SELECT city_id, city_name, state_id FROM geo_cities WHERE city_id = '685'	1	6,7949295043945E-5		3
0	SELECT city_id, city_name, state_id FROM geo_cities WHERE city_id = '577'	1	8,2969665527344E-5		3
0	SELECT business_type_id FROM prop_business_types WHERE 1 = 1	3	5,1021575927734E-5		1
0	SHOW COLUMNS FROM prop_business_types		0,0014798641204834
0	SELECT business_type_id, business_type_name FROM prop_business_types WHERE business_type_id = '1'	1	7,1048736572266E-5		2
0	SELECT business_type_id, business_type_name FROM prop_business_types WHERE business_type_id = '1'	1	5,1975250244141E-5		2
0	SELECT business_type_id, business_type_name FROM prop_business_types WHERE business_type_id = '2'	1	7,0095062255859E-5		2
0	SELECT business_type_id, business_type_name FROM prop_business_types WHERE business_type_id = '2'	1	5,0067901611328E-5		2
0	SELECT business_type_id, business_type_name FROM prop_business_types WHERE business_type_id = '3'	1	4,8160552978516E-5		2
0	SELECT business_type_id, business_type_name FROM prop_business_types WHERE business_type_id = '3'	1	5,2928924560547E-5		2
0	SELECT meta_tag_id FROM cont_meta_tags WHERE 1 = 1 AND meta_tag_url LIKE '%/search_advanced.html'	1	0,0015549659729004		1
0	SHOW COLUMNS FROM cont_meta_tags		0,0010139942169189
0	SELECT meta_tag_id, meta_tag_url, meta_tag_title, meta_tag_keywords, meta_tag_description, meta_tag_keyphrases, content_id FROM cont_meta_tags WHERE meta_tag_id = '179'	1	0,00025796890258789		7
0	SELECT meta_tag_id, meta_tag_url, meta_tag_title, meta_tag_keywords, meta_tag_description, meta_tag_keyphrases, content_id FROM cont_meta_tags WHERE meta_tag_id = '179'	1	5,793571472168E-5		7
0	SELECT meta_tag_id, meta_tag_url, meta_tag_title, meta_tag_keywords, meta_tag_description, meta_tag_keyphrases, content_id FROM cont_meta_tags WHERE meta_tag_id = '1'	1	6,6041946411133E-5		7
0	SELECT meta_tag_id, meta_tag_url, meta_tag_title, meta_tag_keywords, meta_tag_description, meta_tag_keyphrases, content_id FROM cont_meta_tags WHERE meta_tag_id = '1'	1	5,8889389038086E-5		7
0	UPDATE cont_meta_tags SET meta_tag_id = '179', meta_tag_url = '/search_advanced.html', meta_tag_title = 'Buscador Avanzado', meta_tag_keywords = '', meta_tag_description = '', meta_tag_keyphrases = '', content_id = '0' WHERE meta_tag_id = '179'		0,00017094612121582			0
0	SELECT zone_id FROM prop_zones WHERE 1 = 1	7	0,0003960132598877		1
0	SHOW COLUMNS FROM prop_zones		0,0012531280517578
0	SELECT zone_id, zone_name FROM prop_zones WHERE zone_id = '1'	1	0,00020098686218262		2
0	SELECT zone_id, zone_name FROM prop_zones WHERE zone_id = '1'	1	5,6028366088867E-5		2
0	SELECT zone_id, zone_name FROM prop_zones WHERE zone_id = '2'	1	0,00012803077697754		2
0	SELECT zone_id, zone_name FROM prop_zones WHERE zone_id = '2'	1	5,4836273193359E-5		2
0	SELECT zone_id, zone_name FROM prop_zones WHERE zone_id = '3'	1	0,00017285346984863		2
0	SELECT zone_id, zone_name FROM prop_zones WHERE zone_id = '3'	1	5,6028366088867E-5		2
0	SELECT zone_id, zone_name FROM prop_zones WHERE zone_id = '4'	1	0,00014615058898926		2
0	SELECT zone_id, zone_name FROM prop_zones WHERE zone_id = '4'	1	4,9829483032227E-5		2
0	SELECT zone_id, zone_name FROM prop_zones WHERE zone_id = '5'	1	0,00013899803161621		2
0	SELECT zone_id, zone_name FROM prop_zones WHERE zone_id = '5'	1	5,3167343139648E-5		2
0	SELECT zone_id, zone_name FROM prop_zones WHERE zone_id = '6'	1	0,00015091896057129		2
0	SELECT zone_id, zone_name FROM prop_zones WHERE zone_id = '6'	1	5,4121017456055E-5		2
0	SELECT zone_id, zone_name FROM prop_zones WHERE zone_id = '7'	1	0,00014495849609375		2
0	SELECT zone_id, zone_name FROM prop_zones WHERE zone_id = '7'	1	5,2928924560547E-5		2
0	SELECT type_id FROM prop_types WHERE 1 = 1	9	0,00020694732666016		1
0	SHOW COLUMNS FROM prop_types		0,0011870861053467
0	SELECT type_id, type_name FROM prop_types WHERE type_id = '1'	1	6,5088272094727E-5		2
0	SELECT type_id, type_name FROM prop_types WHERE type_id = '1'	1	5,9127807617188E-5		2
0	SELECT type_id, type_name FROM prop_types WHERE type_id = '2'	1	6,103515625E-5		2
0	SELECT type_id, type_name FROM prop_types WHERE type_id = '2'	1	6,1988830566406E-5		2
0	SELECT type_id, type_name FROM prop_types WHERE type_id = '3'	1	6,6995620727539E-5		2
0	SELECT type_id, type_name FROM prop_types WHERE type_id = '3'	1	7,0095062255859E-5		2
0	SELECT type_id, type_name FROM prop_types WHERE type_id = '4'	1	6,2942504882812E-5		2
0	SELECT type_id, type_name FROM prop_types WHERE type_id = '4'	1	6,8902969360352E-5		2
0	SELECT type_id, type_name FROM prop_types WHERE type_id = '5'	1	6,413459777832E-5		2
0	SELECT type_id, type_name FROM prop_types WHERE type_id = '5'	1	6,6995620727539E-5		2
0	SELECT type_id, type_name FROM prop_types WHERE type_id = '6'	1	6,2942504882812E-5		2
0	SELECT type_id, type_name FROM prop_types WHERE type_id = '6'	1	8,2015991210938E-5		2
0	SELECT type_id, type_name FROM prop_types WHERE type_id = '7'	1	7,3909759521484E-5		2
0	SELECT type_id, type_name FROM prop_types WHERE type_id = '7'	1	6,5088272094727E-5		2
0	SELECT type_id, type_name FROM prop_types WHERE type_id = '8'	1	6,9856643676758E-5		2
0	SELECT type_id, type_name FROM prop_types WHERE type_id = '8'	1	8,0108642578125E-5		2
0	SELECT type_id, type_name FROM prop_types WHERE type_id = '9'	1	8,1062316894531E-5		2
0	SELECT type_id, type_name FROM prop_types WHERE type_id = '9'	1	7,8201293945312E-5		2
0	SELECT service_id FROM cont_services WHERE 1 = 1 AND service_highlighted = 1 AND service_state = "A" ORDER by service_name	6	0,0001988410949707		1
0	SHOW COLUMNS FROM cont_services		0,052206039428711
0	SELECT service_id, service_name, service_description, service_state, service_highlighted FROM cont_services WHERE service_id = '5'	1	8,5115432739258E-5		5
0	SELECT service_id, service_name, service_description, service_state, service_highlighted FROM cont_services WHERE service_id = '5'	1	5,9127807617188E-5		5
0	SELECT service_id, service_name, service_description, service_state, service_highlighted FROM cont_services WHERE service_id = '6'	1	0,00013613700866699		5
0	SELECT service_id, service_name, service_description, service_state, service_highlighted FROM cont_services WHERE service_id = '6'	1	9,5129013061523E-5		5
0	SELECT service_id, service_name, service_description, service_state, service_highlighted FROM cont_services WHERE service_id = '2'	1	9,608268737793E-5		5
0	SELECT service_id, service_name, service_description, service_state, service_highlighted FROM cont_services WHERE service_id = '2'	1	9,6797943115234E-5		5
0	SELECT service_id, service_name, service_description, service_state, service_highlighted FROM cont_services WHERE service_id = '4'	1	0,00010895729064941		5
0	SELECT service_id, service_name, service_description, service_state, service_highlighted FROM cont_services WHERE service_id = '4'	1	9,3936920166016E-5		5
0	SELECT service_id, service_name, service_description, service_state, service_highlighted FROM cont_services WHERE service_id = '1'	1	0,00011992454528809		5
0	SELECT service_id, service_name, service_description, service_state, service_highlighted FROM cont_services WHERE service_id = '1'	1	0,00011706352233887		5
0	SELECT service_id, service_name, service_description, service_state, service_highlighted FROM cont_services WHERE service_id = '7'	1	5,5074691772461E-5		5
0	SELECT service_id, service_name, service_description, service_state, service_highlighted FROM cont_services WHERE service_id = '7'	1	5,5074691772461E-5		5
0	SELECT info_id FROM cont_infos WHERE 1 = 1 AND info_state = "A" ORDER by info_name	5	0,0028109550476074		1
0	SHOW COLUMNS FROM cont_infos		0,0015900135040283
0	SELECT info_id, info_name, info_description, info_state FROM cont_infos WHERE info_id = '4'	1	0,00011515617370605		4
0	SELECT info_id, info_name, info_description, info_state FROM cont_infos WHERE info_id = '4'	1	7,2956085205078E-5		4
0	SELECT info_id, info_name, info_description, info_state FROM cont_infos WHERE info_id = '2'	1	7,2002410888672E-5		4
0	SELECT info_id, info_name, info_description, info_state FROM cont_infos WHERE info_id = '2'	1	6,6995620727539E-5		4
0	SELECT info_id, info_name, info_description, info_state FROM cont_infos WHERE info_id = '5'	1	0,010334014892578		4
0	SELECT info_id, info_name, info_description, info_state FROM cont_infos WHERE info_id = '5'	1	0,00035905838012695		4
0	SELECT info_id, info_name, info_description, info_state FROM cont_infos WHERE info_id = '3'	1	6,0796737670898E-5		4
0	SELECT info_id, info_name, info_description, info_state FROM cont_infos WHERE info_id = '3'	1	6,103515625E-5		4
0	SELECT info_id, info_name, info_description, info_state FROM cont_infos WHERE info_id = '1'	1	6,1988830566406E-5		4
0	SELECT info_id, info_name, info_description, info_state FROM cont_infos WHERE info_id = '1'	1	5,6982040405273E-5		4

Total time: 0,083023071289062
Number of SQL: 104

SESSION

POST

GET

FILES

tutecho.net - Asesores Inmobiliarios

búsqueda de inmuebles

elija el tipo de negocio

elija ciudad o municipio

elija zona de Bogotá

elija tipo de inmueble