#1 | debug | SELECT * FROM settings LIMIT 50 OFFSET 0; | ↑+15ms |
#2 | debug | SELECT * FROM pages WHERE `showonmenu` = TRUE ORDER BY lower(menu) ASC, lower(submenu) ASC, ordernum ASC, lower(title) ASC | ↑ |
#3 | debug | SELECT * FROM settings | ↑+2ms |
#4 | debug | SELECT * FROM empresas ORDER BY nombre ASC | ↑+3ms |
#5 | debug | SELECT * FROM webpages WHERE `permalink` = '/maquinas' LIMIT 1 OFFSET 0; | ↑ |
#6 | debug | SELECT * FROM webpages WHERE LOWER(`permalink`) LIKE LOWER('%*%') | ↑ |
#7 | debug | select * from `wpi_web_data_translations` where `slug` = '/maquinas' LIMIT 1 OFFSET 0; | ↑+1ms |
#8 | debug | select * from `wpi_web_data_translations` where `parent_slug` = '/maquinas' AND `lang_code` = '' LIMIT 1 OFFSET 0; | ↑ |
#9 | debug | select * from `wpi_families_webpages` where `slug` = '/maquinas' LIMIT 1 OFFSET 0; | ↑ |
#10 | debug | select * from `webpages` where `idpage`="27" | ↑+1ms |
#11 | debug | select * from `wpi_web_data_translations` where `parent_slug` = '/maquinas' | ↑+1ms |
#12 | debug | SELECT * FROM webpages WHERE idpage = '1' LIMIT 1 OFFSET 0; | ↑+1ms |
#13 | debug | SELECT 1 FROM webpages WHERE idpage = '27'; | ↑ |
#14 | debug | Begin Transaction | ↑ |
#15 | debug | UPDATE webpages SET `creationdate` = '2019-12-11', `customcontroller` = NULL, `description` = '', `equivalentpage` = '', `icon` = '', `langcode` = 'es', `lastip` = '18.224.184.62', `lastmod` = '2025-04-24', `menu` = '', `noindex` = FALSE, `ordernum` = '100', `permalink` = '/families/*', `shorttitle` = 'Family', `showonfooter` = TRUE, `showonmenu` = FALSE, `title` = 'Maquinas', `visitcount` = '201405', `base_template` = 'Wpi/main' WHERE idpage = '27'; | ↑ |
#16 | debug | Commit Transaction | ↑+3ms |
#17 | debug | update `wpi_seo_pages` set `updated_at` = '2025-04-24 07:29:47', `noindex` = FALSE where (LOWER(`url`) LIKE LOWER('/families/%')) | ↑ |
#18 | debug | SELECT * FROM webblocks WHERE `idpage` = '27' ORDER BY ordernum ASC | ↑+13ms |
#19 | debug | SELECT * FROM wpi_generic_web_blocks WHERE `name` IN ('global-js') LIMIT 50 OFFSET 0; | ↑+12ms |
#20 | debug | SELECT * FROM wpi_generic_web_blocks WHERE `name` IN ('global-css') LIMIT 50 OFFSET 0; | ↑ |
#21 | debug | SELECT * FROM wpi_generic_web_blocks WHERE `name` IN ('header') LIMIT 50 OFFSET 0; | ↑ |
#22 | debug | SELECT * FROM divisas | ↑+1ms |
#23 | debug | SELECT * FROM webpages WHERE idpage = '33' LIMIT 1 OFFSET 0; | ↑+15ms |
#24 | debug | select count(*) as x from `familias` where `codfamilia` = 'Tintas' | ↑+9ms |
#25 | debug | select * from `wpi_web_data_translations` where `slug` = '/maquinas' AND `lang_code` = '' LIMIT 1 OFFSET 0; | ↑+5ms |
#26 | debug | SELECT COUNT(*) count_total FROM productos as p left join wpi_products_webpages as pw on p.idproducto = pw.product_id left join wpi_products_images as pi on p.idproducto = pi.product_id WHERE `bloqueado` = FALSE AND `precio` > '0' AND `nostock` = FALSE AND `publico` = TRUE | ↑+1ms |
#27 | debug | SELECT pw.slug url,p.precio precio,p.sevende sevende,p.nostock nostock,p.publico publico,p.stockfis stockfis,p.codimpuesto codimpuesto,p.referencia referencia,p.codfamilia codfamilia,p.idproducto idproducto,p.descripcion descripcion,p.actualizado actualizado,p.bloqueado bloqueado,p.fechaalta fechaalta,p.allow_offer_rate allow_offer_rate,pi.primary_image primary_image,pi.primary_image_url primary_image_url FROM productos as p left join wpi_products_webpages as pw on p.idproducto = pw.product_id left join wpi_products_images as pi on p.idproducto = pi.product_id WHERE `bloqueado` = FALSE AND `precio` > '0' AND `nostock` = FALSE AND `publico` = TRUE ORDER BY idproducto ASC LIMIT 50 OFFSET -50; | ↑+13ms |
#28 | error | You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-50' at line 1 | ↑ |
#29 | debug | SELECT * FROM wpi_generic_web_blocks WHERE `name` IN ('footer') LIMIT 50 OFFSET 0; | ↑+8ms |
#30 | debug | SELECT * FROM webblocks WHERE `idpage` IS NULL ORDER BY ordernum ASC | ↑+1ms |
#31 | debug | SELECT * FROM wpi_generic_web_blocks WHERE `name` IN ('google') LIMIT 50 OFFSET 0; | ↑ |
#32 | debug | UPDATE webpages SET `creationdate` = '2019-12-11', `customcontroller` = NULL, `description` = '', `equivalentpage` = '', `icon` = '', `langcode` = 'es', `lastip` = '18.224.184.62', `lastmod` = '2025-04-24 07:29:48', `menu` = '', `noindex` = FALSE, `ordernum` = '100', `permalink` = '/families/*', `shorttitle` = 'Family', `showonfooter` = TRUE, `showonmenu` = FALSE, `title` = 'Búsqueda', `visitcount` = '201405', `base_template` = 'Wpi/main' WHERE idpage = '27'; | ↑+1ms |
#33 | debug | update `wpi_seo_pages` set `updated_at` = '2025-04-24 07:29:48', `noindex` = FALSE where (LOWER(`url`) LIKE LOWER('/families/%')) | ↑+2ms |
#34 | debug | select * from `wpi_seo_pages` where `url` = '/maquinas' LIMIT 1 OFFSET 0; | ↑+14ms |
#35 | debug | select * from `wpi_meta_tags` where `url` = '' | ↑+1ms |