| #1 | debug | SELECT * FROM settings LIMIT 50 OFFSET 0; | ↑+25ms |
| #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 | ↑+3ms |
| #4 | debug | SELECT * FROM empresas ORDER BY nombre ASC | ↑+3ms |
| #5 | debug | SELECT * FROM webpages WHERE `permalink` = '/software' LIMIT 1 OFFSET 0; | ↑ |
| #6 | debug | SELECT * FROM webpages WHERE LOWER(`permalink`) LIKE LOWER('%*%') | ↑ |
| #7 | debug | select * from `wpi_web_data_translations` where `slug` = '/software' LIMIT 1 OFFSET 0; | ↑+1ms |
| #8 | debug | select * from `wpi_web_data_translations` where `parent_slug` = '/software' AND `lang_code` = '' LIMIT 1 OFFSET 0; | ↑ |
| #9 | debug | select * from `wpi_families_webpages` where `slug` = '/software' LIMIT 1 OFFSET 0; | ↑ |
| #10 | debug | SHOW COLUMNS FROM `wpi_families_webpages`; | ↑+2ms |
| #11 | debug | select * from `webpages` where `idpage`="27" | ↑+2ms |
| #12 | debug | select * from `wpi_web_data_translations` where `parent_slug` = '/software' | ↑+1ms |
| #13 | debug | SELECT * FROM webpages WHERE idpage = '1' LIMIT 1 OFFSET 0; | ↑+1ms |
| #14 | debug | SELECT 1 FROM webpages WHERE idpage = '27'; | ↑ |
| #15 | debug | Begin Transaction | ↑ |
| #16 | debug | UPDATE webpages SET `creationdate` = '2019-12-11', `customcontroller` = NULL, `description` = '', `equivalentpage` = '', `icon` = '', `langcode` = 'es', `lastip` = '3.143.116.179', `lastmod` = '2025-04-24', `menu` = '', `noindex` = FALSE, `ordernum` = '100', `permalink` = '/families/*', `shorttitle` = 'Family', `showonfooter` = TRUE, `showonmenu` = FALSE, `title` = 'Software', `visitcount` = '201400', `base_template` = 'Wpi/main' WHERE idpage = '27'; | ↑ |
| #17 | debug | Commit Transaction | ↑+3ms |
| #18 | debug | update `wpi_seo_pages` set `updated_at` = '2025-04-24 06:47:09', `noindex` = FALSE where (LOWER(`url`) LIKE LOWER('/families/%')) | ↑ |
| #19 | debug | SELECT * FROM webblocks WHERE `idpage` = '27' ORDER BY ordernum ASC | ↑+13ms |
| #20 | debug | SELECT * FROM wpi_generic_web_blocks WHERE `name` IN ('global-js') LIMIT 50 OFFSET 0; | ↑+12ms |
| #21 | debug | SELECT * FROM wpi_generic_web_blocks WHERE `name` IN ('global-css') LIMIT 50 OFFSET 0; | ↑ |
| #22 | debug | SELECT * FROM wpi_generic_web_blocks WHERE `name` IN ('header') LIMIT 50 OFFSET 0; | ↑ |
| #23 | debug | SELECT * FROM divisas | ↑+1ms |
| #24 | debug | SELECT * FROM webpages WHERE idpage = '33' LIMIT 1 OFFSET 0; | ↑+16ms |
| #25 | debug | select count(*) as x from `familias` where `codfamilia` = 'Tintas' | ↑+9ms |
| #26 | debug | select * from `wpi_web_data_translations` where `slug` = '/software' AND `lang_code` = '' LIMIT 1 OFFSET 0; | ↑+4ms |
| #27 | 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 |
| #28 | 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; | ↑+12ms |
| #29 | 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 | ↑ |
| #30 | debug | SELECT * FROM wpi_generic_web_blocks WHERE `name` IN ('footer') LIMIT 50 OFFSET 0; | ↑+8ms |
| #31 | debug | SELECT * FROM webblocks WHERE `idpage` IS NULL ORDER BY ordernum ASC | ↑+1ms |
| #32 | debug | SELECT * FROM wpi_generic_web_blocks WHERE `name` IN ('google') LIMIT 50 OFFSET 0; | ↑ |
| #33 | debug | UPDATE webpages SET `creationdate` = '2019-12-11', `customcontroller` = NULL, `description` = '', `equivalentpage` = '', `icon` = '', `langcode` = 'es', `lastip` = '3.143.116.179', `lastmod` = '2025-04-24 06:47:09', `menu` = '', `noindex` = FALSE, `ordernum` = '100', `permalink` = '/families/*', `shorttitle` = 'Family', `showonfooter` = TRUE, `showonmenu` = FALSE, `title` = 'Búsqueda', `visitcount` = '201400', `base_template` = 'Wpi/main' WHERE idpage = '27'; | ↑+1ms |
| #34 | debug | select * from `wpi_seo_pages` where `url` = '/software' LIMIT 1 OFFSET 0; | ↑+15ms |
| #35 | debug | select * from `wpi_meta_tags` where `url` = '' | ↑+1ms |
