|
|
|
|
2025-02-13T02:25:24+01:00 | info | | Database connected |
2025-02-13T02:25:24+01:00 | sql | 7 ms | SELECT *, clave FROM lexington_traducciones |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT clave, valor FROM lexington_config |
2025-02-13T02:25:24+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-13T02:25:24+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-13T02:25:24+01:00 | sql | 0 ms | SELECT file_name FROM lexington_images_articulos WHERE parent_id = 48 ORDER BY orden |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT file_name FROM lexington_files_articulos WHERE parent_id = 48 ORDER BY orden |
2025-02-13T02:25:24+01:00 | sql | 2 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-13T02:25:24+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-13T02:25:24+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-13T02:25:24+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-13T02:25:24+01:00 | sql | 3 ms | SELECT main.*, titulo_en AS titulo,
descripcion_en AS descripcion,
loc.nombre as localidad, loc.descr_en AS localidad_descr,
cos.provincia, main.fecha_creado, direccion,
loc.costa_id,
zon.nombre as zona,
main.codigo_postal,
tip.nombre_thinkspain,
cla.nombre_en as clase,
tip.nombre_en as tipo,
cos.nombre_en as costa,
pis.nombre_en as piscina,
jar.nombre_en as jardin,
ori.nombre_en as orientacion,
par.nombre_en as parking,
vis.nombre_en as vistas
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 OUTER JOIN lexington_costas cos
ON loc.costa_id = cos.id
LEFT JOIN lexington_clases cla
ON main.clase_id = cla.id
LEFT JOIN lexington_tipos tip
ON main.tipo_id = tip.id
LEFT JOIN lexington_piscinas pis
ON main.piscina_id = pis.id
LEFT JOIN lexington_jardines jar
ON main.jardin_id = jar.id
LEFT JOIN lexington_orientaciones ori
ON main.orientacion_id = ori.id
LEFT JOIN lexington_parkings par
ON main.parking_id = par.id
LEFT JOIN lexington_vistas vis
ON main.vista_id = vis.id
WHERE main.id = 11529 |
2025-02-13T02:25:24+01:00 | sql | 1 ms | SELECT parent_id, file_name FROM lexington_images_viviendas WHERE parent_id = 11529 ORDER BY orden |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT parent_id, file_name FROM lexington_files_viviendas WHERE parent_id = 11529 ORDER BY orden |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT id, nombre_en as nombre FROM lexington_opciones ORDER BY orden |
2025-02-13T02:25:24+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-13T02:25:24+01:00 | sql | 42 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 (precio_de_venta >= 269250) AND (precio_de_venta <= 448750) AND (costa_id = 2) AND (tipo_id = 1) AND (main.id != 11529) AND (visible = 1) ORDER BY RAND() LIMIT 3 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT loc.*, descr_en AS descripcion,
cos.nombre_en AS costa
FROM lexington_localidades loc
JOIN lexington_costas cos
ON loc.costa_id = cos.id
WHERE loc.id = 210 |
2025-02-13T02:25:24+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-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_en AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_en AS nombre FROM lexington_tipos WHERE id = 1 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_en AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_en AS nombre FROM lexington_tipos WHERE id = 1 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_dk AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_dk AS nombre FROM lexington_tipos WHERE id = 1 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_se AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_se AS nombre FROM lexington_tipos WHERE id = 1 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_no AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_no AS nombre FROM lexington_tipos WHERE id = 1 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_fr AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_fr AS nombre FROM lexington_tipos WHERE id = 1 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_tipos WHERE id = 1 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_de AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_de AS nombre FROM lexington_tipos WHERE id = 1 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_es AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_es AS nombre FROM lexington_tipos WHERE id = 1 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_pl AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_pl AS nombre FROM lexington_tipos WHERE id = 1 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_dk AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_dk AS nombre FROM lexington_tipos WHERE id = 1 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_se AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_se AS nombre FROM lexington_tipos WHERE id = 1 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_no AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_no AS nombre FROM lexington_tipos WHERE id = 1 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_fr AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_fr AS nombre FROM lexington_tipos WHERE id = 1 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_tipos WHERE id = 1 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_de AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_de AS nombre FROM lexington_tipos WHERE id = 1 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_es AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_es AS nombre FROM lexington_tipos WHERE id = 1 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_pl AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_pl AS nombre FROM lexington_tipos WHERE id = 1 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T02:25:24+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_tipos WHERE id = 1 |