|
|
|
|
2025-02-14T16:37:46+01:00 | info | | Database connected |
2025-02-14T16:37:46+01:00 | sql | 16 ms | SELECT *, clave FROM lexington_traducciones |
2025-02-14T16:37:46+01:00 | sql | 1 ms | SELECT clave, valor FROM lexington_config |
2025-02-14T16:37:46+01:00 | sql | 1 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 clave = 'inicio'
|
2025-02-14T16:37:46+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 = 1
ORDER BY orden
|
2025-02-14T16:37:46+01:00 | sql | 0 ms | SELECT file_name FROM lexington_images_articulos WHERE parent_id = 1 ORDER BY orden |
2025-02-14T16:37:46+01:00 | sql | 1 ms | SELECT file_name FROM lexington_files_articulos WHERE parent_id = 1 ORDER BY orden |
2025-02-14T16:37:46+01:00 | sql | 4 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-14T16:37:46+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 = 'inicio' |
2025-02-14T16:37:46+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 = 'inicio' |
2025-02-14T16:37:46+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 = 'inicio' |
2025-02-14T16:37:46+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 = 'inicio' |
2025-02-14T16:37:46+01:00 | sql | 4 ms | SELECT *, titulo_en AS titulo, descr_en AS descripcion, link_en AS link
FROM lexington_panoramicas
ORDER BY orden |
2025-02-14T16:37:46+01:00 | sql | 26 ms | SELECT id FROM lexington_viviendas WHERE destacado = 1 AND visible = 1 |
2025-02-14T16:37:46+01:00 | sql | 4 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 ( main.id = 8331 OR main.id = 11940 OR main.id = 11991 OR main.id = 12129 OR main.id = 12304 OR main.id = 12343) ORDER BY main.id DESC |
2025-02-14T16:37:46+01:00 | sql | 5 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 ( main.id = 8331 OR main.id = 11940 OR main.id = 11991 OR main.id = 12129 OR main.id = 12304 OR main.id = 12343) ORDER BY main.id DESC LIMIT 0, 18 |
2025-02-14T16:37:46+01:00 | sql | 8 ms | SELECT COUNT(id) AS num FROM lexington_viviendas WHERE 1 = 1 AND (visible = 1) AND (opciones_json LIKE '%"65"%') |
2025-02-14T16:37:46+01:00 | sql | 9 ms | SELECT COUNT(id) AS num FROM lexington_viviendas WHERE 1 = 1 AND (visible = 1) AND (opciones_json LIKE '%"83"%') |
2025-02-14T16:37:46+01:00 | sql | 5 ms | SELECT COUNT(id) AS num FROM lexington_viviendas WHERE 1 = 1 AND (visible = 1) AND (clase_id = 1) |
2025-02-14T16:37:46+01:00 | sql | 2 ms | SELECT COUNT(id) AS num FROM lexington_viviendas WHERE 1 = 1 AND (visible = 1) AND (localidad_id = 2) |
2025-02-14T16:37:46+01:00 | sql | 1 ms | SELECT COUNT(id) AS num FROM lexington_viviendas WHERE 1 = 1 AND (visible = 1) AND (localidad_id = 5) |
2025-02-14T16:37:46+01:00 | sql | 2 ms | SELECT COUNT(id) AS num FROM lexington_viviendas WHERE 1 = 1 AND (visible = 1) AND (localidad_id = 18) |
2025-02-14T16:37:46+01:00 | sql | 388 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 (visible = 1) ORDER BY main.id DESC LIMIT 8 |
2025-02-14T16:37:46+01:00 | sql | 31 ms | SELECT loc.id AS id, loc.nombre, COUNT(*) AS count
FROM lexington_viviendas viv
LEFT JOIN lexington_localidades loc
ON viv.localidad_id = loc.id
GROUP BY loc.nombre
ORDER BY count DESC
|
2025-02-14T16:37:46+01:00 | sql | 2 ms | SELECT id,
titulo_en AS titulo,
descr_en AS descripcion,
fecha
, (SELECT img.file_name as file_name
FROM lexington_images_noticias img
WHERE img.parent_id = main.id
ORDER BY img.orden ASC
LIMIT 1) AS img
FROM lexington_noticias main
WHERE fecha <= '2025-02-14'
ORDER BY fecha DESC
LIMIT 3 |
2025-02-14T16:37:47+01:00 | sql | 5 ms |
SELECT main.*, mensaje_en AS mensaje,
pais.nombre_en AS pais,
(SELECT img.file_name as file_name
FROM lexington_images_testimonios img
WHERE img.parent_id = main.id
ORDER BY img.orden ASC
LIMIT 1) AS file_name
FROM lexington_testimonios main
LEFT OUTER JOIN lexington_paises pais
ON main.pais_id = pais.id
AND mensaje_en != ''
ORDER BY RAND()
LIMIT 2
|
2025-02-14T16:37:47+01:00 | sql | 1 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 = 'inicio' |
2025-02-14T16:37:47+01:00 | sql | 0 ms | SELECT id, nombre_en AS nombre FROM lexington_costas ORDER BY orden |
2025-02-14T16:37:47+01:00 | sql | 4 ms |
SELECT id, nombre AS nombre
FROM lexington_localidades c
WHERE c.id IN (SELECT DISTINCT localidad_id FROM lexington_viviendas WHERE visible = 1)
ORDER BY nombre |
2025-02-14T16:37:47+01:00 | sql | 5 ms |
SELECT id, nombre_en AS nombre
FROM lexington_tipos c
WHERE c.id IN (SELECT DISTINCT tipo_id FROM lexington_viviendas WHERE visible = 1)
ORDER BY nombre |
2025-02-14T16:37:47+01:00 | sql | 56 ms |
SELECT id, referencia AS nombre
FROM lexington_viviendas c
WHERE visible = 1
ORDER BY nombre |
2025-02-14T16:37:47+01:00 | sql | 1 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 = 'inicio' |