Lexington Realty real estate agency in Costa Blanca, Alicante, Santa Pola, Gran Alacant
2025-02-13T17:10:26+01:00 | info | Database connected | |
2025-02-13T17:10:26+01:00 | sql | 10 ms | SELECT *, clave FROM lexington_traducciones |
2025-02-13T17:10:26+01:00 | sql | 0 ms | SELECT clave, valor FROM lexington_config |
2025-02-13T17:10:26+01:00 | sql | 0 ms | SELECT id, clave, parent_id, privado, formulario, titulo_en AS titulo, banner, link_en AS link, slug_en AS slug, meta_key_en AS meta_key, meta_descr_en AS meta_descr, art_en AS text FROM lexington_articulos WHERE slug_en = 'properties-for-sale' |
2025-02-13T17:10:26+01:00 | sql | 0 ms | SELECT id, clave, titulo_en AS title, link_en AS link, slug_en AS slug, art_en AS text, meta_descr_en 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 = 48 ORDER BY orden |
2025-02-13T17:10:26+01:00 | sql | 0 ms | SELECT file_name FROM lexington_images_articulos WHERE parent_id = 48 ORDER BY orden |
2025-02-13T17:10:26+01:00 | sql | 0 ms | SELECT file_name FROM lexington_files_articulos WHERE parent_id = 48 ORDER BY orden |
2025-02-13T17:10:26+01:00 | sql | 1 ms | SELECT *, id, clave, link_en AS link, titulo_en AS titulo, slug_en AS slug, header_menu, footer_menu, parent_id, orden FROM lexington_articulos ORDER BY orden |
2025-02-13T17:10:26+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-comprar' |
2025-02-13T17:10:26+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-comprar' |
2025-02-13T17:10:26+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-comprar' |
2025-02-13T17:10:26+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-comprar' |
2025-02-13T17:10:26+01:00 | sql | 57 ms | SELECT main.id AS main_id, referencia, dormitorios, banos, sup_vivienda, sup_parcela, precio_de_venta, main.fecha_creado, precio_desde, descripcion_en AS descripcion, piscina_id AS piscina, zon.nombre as zona, main.opciones_json AS opciones, lat, lon, reservado, vendido, reducido, agente, main.titulo_en AS titulo, loc.nombre AS localidad, tip.nombre_en AS tipo, cla.id AS clase_id, cla.nombre_en AS clase, cos.nombre_en 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 (visible = 1) AND ((main.localidad_id = 139)) ORDER BY main.id DESC |
2025-02-13T17:10:26+01:00 | sql | 12 ms | SELECT main.id AS main_id, referencia, dormitorios, banos, sup_vivienda, sup_parcela, precio_de_venta, main.fecha_creado, precio_desde, descripcion_en AS descripcion, piscina_id AS piscina, zon.nombre as zona, main.opciones_json AS opciones, lat, lon, reservado, vendido, reducido, agente, main.titulo_en AS titulo, loc.nombre AS localidad, tip.nombre_en AS tipo, cla.id AS clase_id, cla.nombre_en AS clase, cos.nombre_en 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 (visible = 1) AND ((main.localidad_id = 139)) ORDER BY main.id DESC LIMIT 0, 18 |
2025-02-13T17:10:26+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-comprar' |
2025-02-13T17:10:26+01:00 | sql | 0 ms | SELECT id, nombre_en AS nombre FROM lexington_costas ORDER BY orden |
2025-02-13T17:10:26+01:00 | sql | 6 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:10:26+01:00 | sql | 2 ms | SELECT id, nombre_en 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:10:26+01:00 | sql | 19 ms | SELECT id, referencia AS nombre FROM lexington_viviendas c WHERE visible = 1 ORDER BY nombre |