Lexington Realty dedicated estate agency in Costa Blanca
Viviendas 1 - 18 / 453
Viviendas 1 - 18 / 453
2025-02-13T17:40:37+01:00 | info | Database connected | |
2025-02-13T17:40:37+01:00 | sql | 10 ms | SELECT *, clave FROM lexington_traducciones |
2025-02-13T17:40:37+01:00 | sql | 0 ms | SELECT clave, valor FROM lexington_config |
2025-02-13T17:40:37+01:00 | sql | 0 ms | SELECT id, clave, parent_id, privado, formulario, titulo_es AS titulo, banner, link_es AS link, slug_es AS slug, meta_key_es AS meta_key, meta_descr_es AS meta_descr, art_es AS text FROM lexington_articulos WHERE slug_es = 'apartamentos-en-venta' |
2025-02-13T17:40:37+01:00 | sql | 0 ms | SELECT id, clave, titulo_es AS title, link_es AS link, slug_es AS slug, art_es AS text, meta_descr_es AS meta, (SELECT img.file_name as file_name FROM lexington_images_articulos img WHERE img.parent_id = main.id ORDER BY img.orden ASC LIMIT 1) AS file_name FROM lexington_articulos main WHERE parent_id = 11 ORDER BY orden |
2025-02-13T17:40:37+01:00 | sql | 0 ms | SELECT file_name FROM lexington_images_articulos WHERE parent_id = 11 ORDER BY orden |
2025-02-13T17:40:37+01:00 | sql | 0 ms | SELECT file_name FROM lexington_files_articulos WHERE parent_id = 11 ORDER BY orden |
2025-02-13T17:40:37+01:00 | sql | 3 ms | SELECT *, id, clave, link_es AS link, titulo_es AS titulo, slug_es AS slug, header_menu, footer_menu, parent_id, orden FROM lexington_articulos ORDER BY orden |
2025-02-13T17:40:37+01:00 | sql | 0 ms | SELECT slug_en, slug_dk, slug_se, slug_no, slug_fr, slug_nl, slug_de, slug_es, slug_pl FROM lexington_articulos WHERE clave = 'viviendas-apartamentos' |
2025-02-13T17:40:37+01:00 | sql | 0 ms | SELECT slug_en, slug_dk, slug_se, slug_no, slug_fr, slug_nl, slug_de, slug_es, slug_pl FROM lexington_articulos WHERE clave = 'viviendas-apartamentos' |
2025-02-13T17:40:37+01:00 | sql | 0 ms | SELECT slug_en, slug_dk, slug_se, slug_no, slug_fr, slug_nl, slug_de, slug_es, slug_pl FROM lexington_articulos WHERE clave = 'viviendas-apartamentos' |
2025-02-13T17:40:37+01:00 | sql | 0 ms | SELECT slug_en, slug_dk, slug_se, slug_no, slug_fr, slug_nl, slug_de, slug_es, slug_pl FROM lexington_articulos WHERE clave = 'viviendas-apartamentos' |
2025-02-13T17:40:37+01:00 | sql | 148 ms | SELECT main.id AS main_id, referencia, dormitorios, banos, sup_vivienda, sup_parcela, precio_de_venta, main.fecha_creado, precio_desde, descripcion_es AS descripcion, piscina_id AS piscina, zon.nombre as zona, main.opciones_json AS opciones, lat, lon, reservado, vendido, reducido, agente, main.titulo_es AS titulo, loc.nombre AS localidad, tip.nombre_es AS tipo, cla.id AS clase_id, cla.nombre_es AS clase, cos.nombre_es AS costa, loc.costa_id, opciones_json, (SELECT img.file_name as file_name FROM lexington_images_viviendas img WHERE img.parent_id = main.id ORDER BY img.orden ASC, img.id ASC LIMIT 1) AS file_name FROM lexington_viviendas main LEFT JOIN lexington_localidades loc ON main.localidad_id = loc.id LEFT JOIN lexington_zonas zon ON main.zona_id = zon.id LEFT JOIN lexington_tipos tip ON main.tipo_id = tip.id LEFT JOIN lexington_clases cla ON main.clase_id = cla.id LEFT OUTER JOIN lexington_costas cos ON loc.costa_id = cos.id WHERE 1 = 1 AND ((tipo_id = 1 OR tipo_id = 2 OR tipo_id = 3)) AND (visible = 1) ORDER BY main.id DESC |
2025-02-13T17:40:38+01:00 | sql | 118 ms | SELECT main.id AS main_id, referencia, dormitorios, banos, sup_vivienda, sup_parcela, precio_de_venta, main.fecha_creado, precio_desde, descripcion_es AS descripcion, piscina_id AS piscina, zon.nombre as zona, main.opciones_json AS opciones, lat, lon, reservado, vendido, reducido, agente, main.titulo_es AS titulo, loc.nombre AS localidad, tip.nombre_es AS tipo, cla.id AS clase_id, cla.nombre_es AS clase, cos.nombre_es AS costa, loc.costa_id, opciones_json, (SELECT img.file_name as file_name FROM lexington_images_viviendas img WHERE img.parent_id = main.id ORDER BY img.orden ASC, img.id ASC LIMIT 1) AS file_name FROM lexington_viviendas main LEFT JOIN lexington_localidades loc ON main.localidad_id = loc.id LEFT JOIN lexington_zonas zon ON main.zona_id = zon.id LEFT JOIN lexington_tipos tip ON main.tipo_id = tip.id LEFT JOIN lexington_clases cla ON main.clase_id = cla.id LEFT OUTER JOIN lexington_costas cos ON loc.costa_id = cos.id WHERE 1 = 1 AND ((tipo_id = 1 OR tipo_id = 2 OR tipo_id = 3)) AND (visible = 1) ORDER BY main.id DESC LIMIT 0, 18 |
2025-02-13T17:40:38+01:00 | sql | 1 ms | SELECT meta_descr_es AS field FROM lexington_articulos WHERE clave = 'inicio' |
2025-02-13T17:40:38+01:00 | sql | 0 ms | SELECT art_es AS field FROM lexington_articulos WHERE clave = 'inicio' |
2025-02-13T17:40:38+01:00 | sql | 0 ms | SELECT file_name, art.id AS aid FROM lexington_images_articulos img JOIN lexington_articulos art ON img.parent_id = art.id WHERE art.clave = 'viviendas-apartamentos' |
2025-02-13T17:40:38+01:00 | sql | 0 ms | SELECT id, nombre_es AS nombre FROM lexington_costas ORDER BY orden |
2025-02-13T17:40:38+01:00 | sql | 4 ms | SELECT id, nombre AS nombre FROM lexington_localidades c WHERE c.id IN (SELECT DISTINCT localidad_id FROM lexington_viviendas WHERE visible = 1) ORDER BY nombre |
2025-02-13T17:40:38+01:00 | sql | 3 ms | SELECT id, nombre_es AS nombre FROM lexington_tipos c WHERE c.id IN (SELECT DISTINCT tipo_id FROM lexington_viviendas WHERE visible = 1) ORDER BY nombre |
2025-02-13T17:40:38+01:00 | sql | 36 ms | SELECT id, referencia AS nombre FROM lexington_viviendas c WHERE visible = 1 ORDER BY nombre |