|
|
|
|
2025-02-13T02:16:58+01:00 | info | | Database connected |
2025-02-13T02:16:58+01:00 | sql | 10 ms | SELECT *, clave FROM lexington_traducciones |
2025-02-13T02:16:58+01:00 | sql | 1 ms | SELECT clave, valor FROM lexington_config |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT id, clave, parent_id, privado, formulario,
titulo_no AS titulo, banner,
link_no AS link,
slug_no AS slug,
meta_key_no AS meta_key,
meta_descr_no AS meta_descr,
art_no AS text
FROM lexington_articulos
WHERE slug_no = 'eiendommer-til-salgs'
|
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT id, clave,
titulo_no AS title,
link_no AS link,
slug_no AS slug,
art_no AS text,
meta_descr_no 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:16:58+01:00 | sql | 0 ms | SELECT file_name FROM lexington_images_articulos WHERE parent_id = 48 ORDER BY orden |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT file_name FROM lexington_files_articulos WHERE parent_id = 48 ORDER BY orden |
2025-02-13T02:16:58+01:00 | sql | 2 ms | SELECT *, id, clave, link_no AS link, titulo_no AS titulo,
slug_no AS slug, header_menu, footer_menu, parent_id, orden
FROM lexington_articulos
ORDER BY orden
|
2025-02-13T02:16:58+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:16:58+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:16:58+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:16:58+01:00 | sql | 1 ms | SELECT main.*, titulo_no AS titulo,
descripcion_no AS descripcion,
loc.nombre as localidad, loc.descr_no AS localidad_descr,
cos.provincia, main.fecha_creado, direccion,
loc.costa_id,
zon.nombre as zona,
main.codigo_postal,
tip.nombre_thinkspain,
cla.nombre_no as clase,
tip.nombre_no as tipo,
cos.nombre_no as costa,
pis.nombre_no as piscina,
jar.nombre_no as jardin,
ori.nombre_no as orientacion,
par.nombre_no as parking,
vis.nombre_no 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 = 10544 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT parent_id, file_name FROM lexington_images_viviendas WHERE parent_id = 10544 ORDER BY orden |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT parent_id, file_name FROM lexington_files_viviendas WHERE parent_id = 10544 ORDER BY orden |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT id, nombre_no as nombre FROM lexington_opciones ORDER BY orden |
2025-02-13T02:16:58+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:16:58+01:00 | sql | 0 ms | SELECT main.id AS main_id, referencia, dormitorios, banos, sup_vivienda,
sup_parcela, precio_de_venta, main.fecha_creado, precio_desde,
descripcion_no AS descripcion,
piscina_id AS piscina, zon.nombre as zona, main.opciones_json AS opciones,
lat, lon, reservado, vendido, reducido, agente,
main.titulo_no AS titulo,
loc.nombre AS localidad,
tip.nombre_no AS tipo,
cla.id AS clase_id, cla.nombre_no AS clase,
cos.nombre_no 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 >= 195000) AND (precio_de_venta <= 325000) AND (costa_id = ) AND (tipo_id = 6) AND (main.id != 10544) AND (visible = 1) ORDER BY RAND() LIMIT 3 |
2025-02-13T02:16:58+01:00 | error | | MySql Error (Err_no: 1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND (tipo_id = 6) AND (main.id != 10544) AND (visible = 1) ORDER BY RAND() LIM' at line 27 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT loc.*, descr_no AS descripcion,
cos.nombre_no AS costa
FROM lexington_localidades loc
JOIN lexington_costas cos
ON loc.costa_id = cos.id
WHERE loc.id = 202 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT meta_descr_no AS field FROM lexington_articulos WHERE clave = 'inicio' |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT art_no AS field FROM lexington_articulos WHERE clave = 'inicio' |
2025-02-13T02:16:58+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:16:58+01:00 | sql | 0 ms | SELECT nombre_no AS nombre FROM lexington_costas WHERE id = |
2025-02-13T02:16:58+01:00 | error | | MySql Error (Err_no: 1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_no AS nombre FROM lexington_tipos WHERE id = 6 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_en AS nombre FROM lexington_costas WHERE id = |
2025-02-13T02:16:58+01:00 | error | | MySql Error (Err_no: 1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_en AS nombre FROM lexington_tipos WHERE id = 6 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_dk AS nombre FROM lexington_costas WHERE id = |
2025-02-13T02:16:58+01:00 | error | | MySql Error (Err_no: 1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_dk AS nombre FROM lexington_tipos WHERE id = 6 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_se AS nombre FROM lexington_costas WHERE id = |
2025-02-13T02:16:58+01:00 | error | | MySql Error (Err_no: 1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_se AS nombre FROM lexington_tipos WHERE id = 6 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_no AS nombre FROM lexington_costas WHERE id = |
2025-02-13T02:16:58+01:00 | error | | MySql Error (Err_no: 1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_no AS nombre FROM lexington_tipos WHERE id = 6 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_fr AS nombre FROM lexington_costas WHERE id = |
2025-02-13T02:16:58+01:00 | error | | MySql Error (Err_no: 1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_fr AS nombre FROM lexington_tipos WHERE id = 6 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_costas WHERE id = |
2025-02-13T02:16:58+01:00 | error | | MySql Error (Err_no: 1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_tipos WHERE id = 6 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_de AS nombre FROM lexington_costas WHERE id = |
2025-02-13T02:16:58+01:00 | error | | MySql Error (Err_no: 1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_de AS nombre FROM lexington_tipos WHERE id = 6 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_es AS nombre FROM lexington_costas WHERE id = |
2025-02-13T02:16:58+01:00 | error | | MySql Error (Err_no: 1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_es AS nombre FROM lexington_tipos WHERE id = 6 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_pl AS nombre FROM lexington_costas WHERE id = |
2025-02-13T02:16:58+01:00 | error | | MySql Error (Err_no: 1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_pl AS nombre FROM lexington_tipos WHERE id = 6 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_en AS nombre FROM lexington_costas WHERE id = |
2025-02-13T02:16:58+01:00 | error | | MySql Error (Err_no: 1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_en AS nombre FROM lexington_tipos WHERE id = 6 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_dk AS nombre FROM lexington_costas WHERE id = |
2025-02-13T02:16:58+01:00 | error | | MySql Error (Err_no: 1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 |
2025-02-13T02:16:58+01:00 | sql | 1 ms | SELECT nombre_dk AS nombre FROM lexington_tipos WHERE id = 6 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_se AS nombre FROM lexington_costas WHERE id = |
2025-02-13T02:16:58+01:00 | error | | MySql Error (Err_no: 1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_se AS nombre FROM lexington_tipos WHERE id = 6 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_fr AS nombre FROM lexington_costas WHERE id = |
2025-02-13T02:16:58+01:00 | error | | MySql Error (Err_no: 1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_fr AS nombre FROM lexington_tipos WHERE id = 6 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_costas WHERE id = |
2025-02-13T02:16:58+01:00 | error | | MySql Error (Err_no: 1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_tipos WHERE id = 6 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_de AS nombre FROM lexington_costas WHERE id = |
2025-02-13T02:16:58+01:00 | error | | MySql Error (Err_no: 1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_de AS nombre FROM lexington_tipos WHERE id = 6 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_es AS nombre FROM lexington_costas WHERE id = |
2025-02-13T02:16:58+01:00 | error | | MySql Error (Err_no: 1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_es AS nombre FROM lexington_tipos WHERE id = 6 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_pl AS nombre FROM lexington_costas WHERE id = |
2025-02-13T02:16:58+01:00 | error | | MySql Error (Err_no: 1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_pl AS nombre FROM lexington_tipos WHERE id = 6 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_costas WHERE id = |
2025-02-13T02:16:58+01:00 | error | | MySql Error (Err_no: 1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 |
2025-02-13T02:16:58+01:00 | sql | 0 ms | SELECT nombre_nl AS nombre FROM lexington_tipos WHERE id = 6 |