#1 | debug | SELECT * FROM settings LIMIT 50 OFFSET 0; | ↑+5ms |
#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 | ↑+4ms |
#5 | debug | SELECT * FROM webpages WHERE `permalink` = '/maquinas' LIMIT 1 OFFSET 0; | ↑+1ms |
#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` = '3.146.37.183', `lastmod` = '2025-04-25', `menu` = '', `noindex` = FALSE, `ordernum` = '100', `permalink` = '/families/*', `shorttitle` = 'Family', `showonfooter` = TRUE, `showonmenu` = FALSE, `title` = 'Maquinas', `visitcount` = '201455', `base_template` = 'Wpi/main' WHERE idpage = '27'; | ↑ |
#16 | debug | Commit Transaction | ↑+7ms |
#17 | debug | update `wpi_seo_pages` set `updated_at` = '2025-04-25 02:39:42', `noindex` = FALSE where (LOWER(`url`) LIKE LOWER('/families/%')) | ↑ |
#18 | debug | SELECT * FROM webblocks WHERE `idpage` = '27' ORDER BY ordernum ASC | ↑+15ms |
#19 | debug | SELECT * FROM wpi_generic_web_blocks WHERE `name` IN ('global-js') LIMIT 50 OFFSET 0; | ↑+15ms |
#20 | debug | SELECT * FROM wpi_generic_web_blocks WHERE `name` IN ('global-css') LIMIT 50 OFFSET 0; | ↑+1ms |
#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; | ↑+18ms |
#24 | debug | select count(*) as x from `familias` where `codfamilia` = 'Tintas' | ↑+11ms |
#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 250; | ↑+15ms |
#28 | debug | SELECT * FROM productos WHERE idproducto = '966' LIMIT 1 OFFSET 0; | ↑+12ms |
#29 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=966 | ↑+1ms |
#30 | debug | SELECT * FROM impuestos WHERE codimpuesto = 'AR21' LIMIT 1 OFFSET 0; | ↑+4ms |
#31 | debug | SELECT * FROM productos WHERE idproducto = '967' LIMIT 1 OFFSET 0; | ↑ |
#32 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=967 | ↑ |
#33 | debug | SELECT * FROM productos WHERE idproducto = '970' LIMIT 1 OFFSET 0; | ↑+1ms |
#34 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=970 | ↑ |
#35 | debug | SELECT * FROM productos WHERE idproducto = '971' LIMIT 1 OFFSET 0; | ↑+2ms |
#36 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=971 | ↑ |
#37 | debug | SELECT * FROM productos WHERE idproducto = '972' LIMIT 1 OFFSET 0; | ↑+1ms |
#38 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=972 | ↑ |
#39 | debug | SELECT * FROM productos WHERE idproducto = '973' LIMIT 1 OFFSET 0; | ↑+1ms |
#40 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=973 | ↑ |
#41 | debug | SELECT * FROM productos WHERE idproducto = '974' LIMIT 1 OFFSET 0; | ↑+1ms |
#42 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=974 | ↑ |
#43 | debug | SELECT * FROM productos WHERE idproducto = '988' LIMIT 1 OFFSET 0; | ↑+1ms |
#44 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=988 | ↑ |
#45 | debug | SELECT * FROM impuestos WHERE codimpuesto = 'AR105' LIMIT 1 OFFSET 0; | ↑+1ms |
#46 | debug | SELECT * FROM productos WHERE idproducto = '1008' LIMIT 1 OFFSET 0; | ↑ |
#47 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1008 | ↑ |
#48 | debug | SELECT * FROM productos WHERE idproducto = '1010' LIMIT 1 OFFSET 0; | ↑+1ms |
#49 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1010 | ↑ |
#50 | debug | SELECT * FROM productos WHERE idproducto = '1012' LIMIT 1 OFFSET 0; | ↑+1ms |
#51 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1012 | ↑ |
#52 | debug | SELECT * FROM productos WHERE idproducto = '1025' LIMIT 1 OFFSET 0; | ↑+1ms |
#53 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1025 | ↑ |
#54 | debug | SELECT * FROM productos WHERE idproducto = '1026' LIMIT 1 OFFSET 0; | ↑+1ms |
#55 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1026 | ↑ |
#56 | debug | SELECT * FROM productos WHERE idproducto = '1027' LIMIT 1 OFFSET 0; | ↑+3ms |
#57 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1027 | ↑ |
#58 | debug | SELECT * FROM productos WHERE idproducto = '1028' LIMIT 1 OFFSET 0; | ↑+1ms |
#59 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1028 | ↑ |
#60 | debug | SELECT * FROM productos WHERE idproducto = '1035' LIMIT 1 OFFSET 0; | ↑+1ms |
#61 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1035 | ↑ |
#62 | debug | SELECT * FROM productos WHERE idproducto = '1038' LIMIT 1 OFFSET 0; | ↑+1ms |
#63 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1038 | ↑ |
#64 | debug | SELECT * FROM productos WHERE idproducto = '1039' LIMIT 1 OFFSET 0; | ↑+2ms |
#65 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1039 | ↑ |
#66 | debug | SELECT * FROM productos WHERE idproducto = '1040' LIMIT 1 OFFSET 0; | ↑+1ms |
#67 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1040 | ↑ |
#68 | debug | SELECT * FROM productos WHERE idproducto = '1041' LIMIT 1 OFFSET 0; | ↑+1ms |
#69 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1041 | ↑ |
#70 | debug | SELECT * FROM productos WHERE idproducto = '1042' LIMIT 1 OFFSET 0; | ↑+1ms |
#71 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1042 | ↑ |
#72 | debug | SELECT * FROM productos WHERE idproducto = '1045' LIMIT 1 OFFSET 0; | ↑+1ms |
#73 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1045 | ↑ |
#74 | debug | SELECT * FROM productos WHERE idproducto = '1052' LIMIT 1 OFFSET 0; | ↑+1ms |
#75 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1052 | ↑ |
#76 | debug | SELECT * FROM productos WHERE idproducto = '1053' LIMIT 1 OFFSET 0; | ↑+1ms |
#77 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1053 | ↑ |
#78 | debug | SELECT * FROM productos WHERE idproducto = '1057' LIMIT 1 OFFSET 0; | ↑+1ms |
#79 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1057 | ↑ |
#80 | debug | SELECT * FROM productos WHERE idproducto = '1065' LIMIT 1 OFFSET 0; | ↑+1ms |
#81 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1065 | ↑ |
#82 | debug | SELECT * FROM productos WHERE idproducto = '1066' LIMIT 1 OFFSET 0; | ↑+1ms |
#83 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1066 | ↑ |
#84 | debug | SELECT * FROM productos WHERE idproducto = '1067' LIMIT 1 OFFSET 0; | ↑+1ms |
#85 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1067 | ↑ |
#86 | debug | SELECT * FROM productos WHERE idproducto = '1068' LIMIT 1 OFFSET 0; | ↑+1ms |
#87 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1068 | ↑ |
#88 | debug | SELECT * FROM productos WHERE idproducto = '1079' LIMIT 1 OFFSET 0; | ↑+1ms |
#89 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1079 | ↑ |
#90 | debug | SELECT * FROM productos WHERE idproducto = '1081' LIMIT 1 OFFSET 0; | ↑+1ms |
#91 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1081 | ↑ |
#92 | debug | SELECT * FROM productos WHERE idproducto = '1111' LIMIT 1 OFFSET 0; | ↑+1ms |
#93 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1111 | ↑ |
#94 | debug | SELECT * FROM productos WHERE idproducto = '1125' LIMIT 1 OFFSET 0; | ↑+1ms |
#95 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1125 | ↑ |
#96 | debug | SELECT * FROM productos WHERE idproducto = '1149' LIMIT 1 OFFSET 0; | ↑+1ms |
#97 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1149 | ↑ |
#98 | debug | SELECT * FROM productos WHERE idproducto = '1157' LIMIT 1 OFFSET 0; | ↑+1ms |
#99 | debug | SELECT * FROM productos WHERE idproducto = '1159' LIMIT 1 OFFSET 0; | ↑+1ms |
#100 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1159 | ↑ |
#101 | debug | SELECT * FROM productos WHERE idproducto = '1161' LIMIT 1 OFFSET 0; | ↑+1ms |
#102 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1161 | ↑ |
#103 | debug | SELECT * FROM productos WHERE idproducto = '1189' LIMIT 1 OFFSET 0; | ↑+1ms |
#104 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1189 | ↑ |
#105 | debug | SELECT * FROM productos WHERE idproducto = '1201' LIMIT 1 OFFSET 0; | ↑+2ms |
#106 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1201 | ↑ |
#107 | debug | SELECT * FROM productos WHERE idproducto = '1307' LIMIT 1 OFFSET 0; | ↑+1ms |
#108 | debug | SELECT sum(disponible) as total FROM stocks WHERE idproducto=1307 | ↑ |
#109 | debug | SELECT * FROM wpi_generic_web_blocks WHERE `name` IN ('footer') LIMIT 50 OFFSET 0; | ↑+9ms |
#110 | debug | SELECT * FROM webblocks WHERE `idpage` IS NULL ORDER BY ordernum ASC | ↑+2ms |
#111 | debug | SELECT * FROM wpi_generic_web_blocks WHERE `name` IN ('google') LIMIT 50 OFFSET 0; | ↑+1ms |
#112 | debug | UPDATE webpages SET `creationdate` = '2019-12-11', `customcontroller` = NULL, `description` = '', `equivalentpage` = '', `icon` = '', `langcode` = 'es', `lastip` = '3.146.37.183', `lastmod` = '2025-04-25 02:39:42', `menu` = '', `noindex` = FALSE, `ordernum` = '100', `permalink` = '/families/*', `shorttitle` = 'Family', `showonfooter` = TRUE, `showonmenu` = FALSE, `title` = 'Búsqueda', `visitcount` = '201455', `base_template` = 'Wpi/main' WHERE idpage = '27'; | ↑+2ms |
#113 | debug | select * from `wpi_seo_pages` where `url` = '/maquinas' LIMIT 1 OFFSET 0; | ↑+26ms |
#114 | debug | select * from `wpi_meta_tags` where `url` = '' | ↑+3ms |