|
|
|
|
2025-02-13T11:43:04+01:00 | info | | Database connected |
2025-02-13T11:43:04+01:00 | sql | 6 ms | SELECT *, clave FROM lexington_traducciones |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT clave, valor FROM lexington_config |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT id, clave, parent_id, privado, formulario,
titulo_dk AS titulo, banner,
link_dk AS link,
slug_dk AS slug,
meta_key_dk AS meta_key,
meta_descr_dk AS meta_descr,
art_dk AS text
FROM lexington_articulos
WHERE slug_dk = 'ejendomme-til-salg'
|
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT id, clave,
titulo_dk AS title,
link_dk AS link,
slug_dk AS slug,
art_dk AS text,
meta_descr_dk 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:43:04+01:00 | sql | 0 ms | SELECT file_name FROM lexington_images_articulos WHERE parent_id = 48 ORDER BY orden |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT file_name FROM lexington_files_articulos WHERE parent_id = 48 ORDER BY orden |
2025-02-13T11:43:04+01:00 | sql | 1 ms | SELECT *, id, clave, link_dk AS link, titulo_dk AS titulo,
slug_dk AS slug, header_menu, footer_menu, parent_id, orden
FROM lexington_articulos
ORDER BY orden
|
2025-02-13T11:43:04+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:43:04+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:43:04+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:43:04+01:00 | sql | 1 ms | SELECT main.*, titulo_dk AS titulo,
descripcion_dk AS descripcion,
loc.nombre as localidad, loc.descr_dk AS localidad_descr,
cos.provincia, main.fecha_creado, direccion,
loc.costa_id,
zon.nombre as zona,
main.codigo_postal,
tip.nombre_thinkspain,
cla.nombre_dk as clase,
tip.nombre_dk as tipo,
cos.nombre_dk as costa,
pis.nombre_dk as piscina,
jar.nombre_dk as jardin,
ori.nombre_dk as orientacion,
par.nombre_dk as parking,
vis.nombre_dk 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 = 10790 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT parent_id, file_name FROM lexington_images_viviendas WHERE parent_id = 10790 ORDER BY orden |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT parent_id, file_name FROM lexington_files_viviendas WHERE parent_id = 10790 ORDER BY orden |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT id, nombre_dk as nombre FROM lexington_opciones ORDER BY orden |
2025-02-13T11:43:04+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:43:04+01:00 | sql | 41 ms | SELECT main.id AS main_id, referencia, dormitorios, banos, sup_vivienda,
sup_parcela, precio_de_venta, main.fecha_creado, precio_desde,
descripcion_dk AS descripcion,
piscina_id AS piscina, zon.nombre as zona, main.opciones_json AS opciones,
lat, lon, reservado, vendido, reducido, agente,
main.titulo_dk AS titulo,
loc.nombre AS localidad,
tip.nombre_dk AS tipo,
cla.id AS clase_id, cla.nombre_dk AS clase,
cos.nombre_dk 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 >= 281250) AND (precio_de_venta <= 468750) AND (costa_id = 2) AND (tipo_id = 5) AND (main.id != 10790) AND (visible = 1) ORDER BY RAND() LIMIT 3 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT loc.*, descr_dk AS descripcion,
cos.nombre_dk AS costa
FROM lexington_localidades loc
JOIN lexington_costas cos
ON loc.costa_id = cos.id
WHERE loc.id = 184 |
2025-02-13T11:43:04+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:43:04+01:00 | sql | 0 ms | SELECT nombre_dk AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_dk AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_en AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_en AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_dk AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_dk AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_se AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_se AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_no AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_no AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_fr AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_fr AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_de AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_de AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_es AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_es AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_pl AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_pl AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_en AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_en AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_se AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_se AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_no AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_no AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_fr AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_fr AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_de AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_de AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_es AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_es AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_pl AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_pl AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_costas WHERE id = 2 |
2025-02-13T11:43:04+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_tipos WHERE id = 5 |