|
|
|
|
| 2026-03-30T13:31:17+02:00 | info | | Database connected |
| 2026-03-30T13:31:17+02:00 | sql | 2 ms | SELECT *, clave FROM books_traducciones |
| 2026-03-30T13:31:17+02:00 | sql | 0 ms | SELECT clave, valor FROM books_config |
| 2026-03-30T13:31:17+02:00 | sql | 0 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 books_articulos
WHERE clave = 'inicio'
|
| 2026-03-30T13:31:17+02: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 books_images_articulos img
WHERE img.parent_id = main.id
ORDER BY img.orden ASC
LIMIT 1) AS file_name
FROM books_articulos main
WHERE parent_id = 1
ORDER BY orden
|
| 2026-03-30T13:31:17+02:00 | sql | 0 ms | SELECT file_name FROM books_images_articulos WHERE parent_id = 1 ORDER BY orden |
| 2026-03-30T13:31:17+02:00 | sql | 0 ms | SELECT * FROM books_files_articulos WHERE parent_id = 1 ORDER BY orden |
| 2026-03-30T13:31:17+02:00 | sql | 0 ms | SELECT *, id, clave, link_en AS link, titulo_en AS titulo,
slug_en AS slug, header_menu, footer_menu, parent_id, orden
FROM books_articulos
ORDER BY orden
|
| 2026-03-30T13:31:17+02:00 | sql | 0 ms | SELECT slug_en FROM books_articulos WHERE clave = 'inicio' |
| 2026-03-30T13:31:17+02:00 | sql | 0 ms | SELECT slug_en FROM books_articulos WHERE clave = 'inicio' |
| 2026-03-30T13:31:17+02:00 | sql | 0 ms | SELECT slug_en FROM books_articulos WHERE clave = 'inicio' |
| 2026-03-30T13:31:17+02:00 | sql | 0 ms |
SELECT main.id AS main_id, referencia, dormitorios, banos,
sup_vivienda, sup_parcela, piscina_id,
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,
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,
opciones_json,
(SELECT img.file_name as file_name
FROM books_images_viviendas img
WHERE img.parent_id = main.id
ORDER BY img.orden ASC, img.id ASC
LIMIT 1) AS file_name
FROM books_viviendas main
LEFT JOIN books_localidades loc ON main.localidad_id = loc.id
LEFT JOIN books_zonas zon ON main.zona_id = zon.id
LEFT JOIN books_tipos tip ON main.tipo_id = tip.id
LEFT JOIN books_clases cla ON main.clase_id = cla.id
LEFT JOIN books_costas cos ON loc.costa_id = cos.id
WHERE 1 = 1
AND (visible = 1) AND (destacado = 1) ORDER BY main.id DESC LIMIT 6 |
| 2026-03-30T13:31:17+02:00 | error | | MySql Error (Err_no: 1146) Table 'duggers_webdb.books_viviendas' doesn't exist |
| 2026-03-30T13:31:17+02:00 | sql | 0 ms | SELECT *, titulo_en AS titulo, link_en AS link FROM books_panoramicas ORDER BY orden |
| 2026-03-30T13:31:17+02:00 | sql | 0 ms | SELECT file_name, art.id AS aid
FROM books_images_articulos img
JOIN books_articulos art
ON img.parent_id = art.id
WHERE art.clave = 'inicio' |
| 2026-03-30T13:31:17+02:00 | sql | 0 ms | SELECT file_name, art.id AS aid
FROM books_images_articulos img
JOIN books_articulos art
ON img.parent_id = art.id
WHERE art.clave = 'inicio' |
| 2026-03-30T13:31:17+02:00 | sql | 1 ms | UPDATE books_traducciones SET used = 1 WHERE clave = 'slogan' AND used != 2 |
| 2026-03-30T13:31:17+02:00 | sql | 0 ms | SELECT art_en AS field FROM books_articulos WHERE clave = 'newsletter' |
| 2026-03-30T13:31:17+02:00 | sql | 1 ms | UPDATE books_traducciones SET used = 1 WHERE clave = 'acepto_privacidad' AND used != 2 |
| 2026-03-30T13:31:17+02:00 | sql | 1 ms | UPDATE books_traducciones SET used = 1 WHERE clave = 'enviar' AND used != 2 |
| 2026-03-30T13:31:17+02:00 | sql | 1 ms | UPDATE books_traducciones SET used = 1 WHERE clave = 'sitemap' AND used != 2 |
| 2026-03-30T13:31:17+02:00 | sql | 1 ms | UPDATE books_traducciones SET used = 1 WHERE clave = 'siguenos_online' AND used != 2 |
| 2026-03-30T13:31:17+02:00 | sql | 1 ms | UPDATE books_traducciones SET used = 1 WHERE clave = 'todos_derechos' AND used != 2 |