|
|
|
|
2025-02-13T01:50:32+01:00 | info | | Database connected |
2025-02-13T01:50:32+01:00 | sql | 12 ms | SELECT *, clave FROM lexington_traducciones |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT clave, valor FROM lexington_config |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT id, clave, parent_id, privado, formulario,
titulo_nl AS titulo, banner,
link_nl AS link,
slug_nl AS slug,
meta_key_nl AS meta_key,
meta_descr_nl AS meta_descr,
art_nl AS text
FROM lexington_articulos
WHERE slug_nl = 'woningen-te-koop'
|
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT id, clave,
titulo_nl AS title,
link_nl AS link,
slug_nl AS slug,
art_nl AS text,
meta_descr_nl 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-13T01:50:32+01:00 | sql | 0 ms | SELECT file_name FROM lexington_images_articulos WHERE parent_id = 48 ORDER BY orden |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT file_name FROM lexington_files_articulos WHERE parent_id = 48 ORDER BY orden |
2025-02-13T01:50:32+01:00 | sql | 1 ms | SELECT *, id, clave, link_nl AS link, titulo_nl AS titulo,
slug_nl AS slug, header_menu, footer_menu, parent_id, orden
FROM lexington_articulos
ORDER BY orden
|
2025-02-13T01:50:32+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-13T01:50:32+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-13T01:50:32+01:00 | sql | 1 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-13T01:50:32+01:00 | sql | 1 ms | SELECT main.*, titulo_nl AS titulo,
descripcion_nl AS descripcion,
loc.nombre as localidad, loc.descr_nl AS localidad_descr,
cos.provincia, main.fecha_creado, direccion,
loc.costa_id,
zon.nombre as zona,
main.codigo_postal,
tip.nombre_thinkspain,
cla.nombre_nl as clase,
tip.nombre_nl as tipo,
cos.nombre_nl as costa,
pis.nombre_nl as piscina,
jar.nombre_nl as jardin,
ori.nombre_nl as orientacion,
par.nombre_nl as parking,
vis.nombre_nl 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 = 9863 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT parent_id, file_name FROM lexington_images_viviendas WHERE parent_id = 9863 ORDER BY orden |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT parent_id, file_name FROM lexington_files_viviendas WHERE parent_id = 9863 ORDER BY orden |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT id, nombre_nl as nombre FROM lexington_opciones ORDER BY orden |
2025-02-13T01:50:32+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-13T01:50:32+01:00 | sql | 55 ms | SELECT main.id AS main_id, referencia, dormitorios, banos, sup_vivienda,
sup_parcela, precio_de_venta, main.fecha_creado, precio_desde,
descripcion_nl AS descripcion,
piscina_id AS piscina, zon.nombre as zona, main.opciones_json AS opciones,
lat, lon, reservado, vendido, reducido, agente,
main.titulo_nl AS titulo,
loc.nombre AS localidad,
tip.nombre_nl AS tipo,
cla.id AS clase_id, cla.nombre_nl AS clase,
cos.nombre_nl 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 >= 506250) AND (precio_de_venta <= 843750) AND (costa_id = 1) AND (tipo_id = 5) AND (main.id != 9863) AND (visible = 1) ORDER BY RAND() LIMIT 3 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT loc.*, descr_nl AS descripcion,
cos.nombre_nl AS costa
FROM lexington_localidades loc
JOIN lexington_costas cos
ON loc.costa_id = cos.id
WHERE loc.id = 19 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT meta_descr_nl AS field FROM lexington_articulos WHERE clave = 'inicio' |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT art_nl AS field FROM lexington_articulos WHERE clave = 'inicio' |
2025-02-13T01:50:32+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-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_en AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_en AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_dk AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_dk AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_se AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_se AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_no AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_no AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_fr AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_fr AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_de AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_de AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_es AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_es AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_pl AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_pl AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_en AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_en AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_dk AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_dk AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_se AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_se AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_no AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_no AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_fr AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_fr AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_de AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_de AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_es AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_es AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_pl AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_pl AS nombre FROM lexington_tipos WHERE id = 5 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_costas WHERE id = 1 |
2025-02-13T01:50:32+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_tipos WHERE id = 5 |