|
|
|
|
2025-02-13T11:27:51+01:00 | info | | Database connected |
2025-02-13T11:27:51+01:00 | sql | 17 ms | SELECT *, clave FROM lexington_traducciones |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT clave, valor FROM lexington_config |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT id, clave, parent_id, privado, formulario,
titulo_de AS titulo, banner,
link_de AS link,
slug_de AS slug,
meta_key_de AS meta_key,
meta_descr_de AS meta_descr,
art_de AS text
FROM lexington_articulos
WHERE slug_de = '-immobilien-zum-verkauf'
|
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT id, clave,
titulo_de AS title,
link_de AS link,
slug_de AS slug,
art_de AS text,
meta_descr_de 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-13T11:27:51+01:00 | sql | 0 ms | SELECT file_name FROM lexington_images_articulos WHERE parent_id = 48 ORDER BY orden |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT file_name FROM lexington_files_articulos WHERE parent_id = 48 ORDER BY orden |
2025-02-13T11:27:51+01:00 | sql | 1 ms | SELECT *, id, clave, link_de AS link, titulo_de AS titulo,
slug_de AS slug, header_menu, footer_menu, parent_id, orden
FROM lexington_articulos
ORDER BY orden
|
2025-02-13T11:27:51+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-13T11:27:51+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-13T11:27:51+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-13T11:27:51+01:00 | sql | 1 ms | SELECT main.*, titulo_de AS titulo,
descripcion_de AS descripcion,
loc.nombre as localidad, loc.descr_de AS localidad_descr,
cos.provincia, main.fecha_creado, direccion,
loc.costa_id,
zon.nombre as zona,
main.codigo_postal,
tip.nombre_thinkspain,
cla.nombre_de as clase,
tip.nombre_de as tipo,
cos.nombre_de as costa,
pis.nombre_de as piscina,
jar.nombre_de as jardin,
ori.nombre_de as orientacion,
par.nombre_de as parking,
vis.nombre_de 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 = 12237 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT parent_id, file_name FROM lexington_images_viviendas WHERE parent_id = 12237 ORDER BY orden |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT parent_id, file_name FROM lexington_files_viviendas WHERE parent_id = 12237 ORDER BY orden |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT id, nombre_de as nombre FROM lexington_opciones ORDER BY orden |
2025-02-13T11:27:51+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-13T11:27:51+01:00 | sql | 45 ms | SELECT main.id AS main_id, referencia, dormitorios, banos, sup_vivienda,
sup_parcela, precio_de_venta, main.fecha_creado, precio_desde,
descripcion_de AS descripcion,
piscina_id AS piscina, zon.nombre as zona, main.opciones_json AS opciones,
lat, lon, reservado, vendido, reducido, agente,
main.titulo_de AS titulo,
loc.nombre AS localidad,
tip.nombre_de AS tipo,
cla.id AS clase_id, cla.nombre_de AS clase,
cos.nombre_de 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 >= 2396250) AND (precio_de_venta <= 3993750) AND (costa_id = 1) AND (tipo_id = 5) AND (main.id != 12237) AND (visible = 1) ORDER BY RAND() LIMIT 3 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT loc.*, descr_de AS descripcion,
cos.nombre_de AS costa
FROM lexington_localidades loc
JOIN lexington_costas cos
ON loc.costa_id = cos.id
WHERE loc.id = 81 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT meta_descr_de AS field FROM lexington_articulos WHERE clave = 'inicio' |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT art_de AS field FROM lexington_articulos WHERE clave = 'inicio' |
2025-02-13T11:27:51+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-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_de AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_de AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_en AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_en AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_dk AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_dk AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_se AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_se AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_no AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_no AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_fr AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_fr AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_de AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_de AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_es AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_es AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_pl AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_pl AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_en AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_en AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_dk AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_dk AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_se AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_se AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_no AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_no AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_fr AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_fr AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_es AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_es AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_pl AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_pl AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T11:27:51+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_tipos WHERE id = 5 |