SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039876 LIMIT 1 [ RunTime:0.003983s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039876 [ RunTime:0.001875s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (855955,477410,835708,716004,267229,31320,196111,400401,417090,391236,431318,670415,1036179,688482,37748,449845,621556,243621,386587,231139,158068,808002,325955,212636,57397,909716,926919,884076,349233,577033,15139,847563,281565,30910,235274,134691,344794,933413,522315,960013,438374,494196,232172,667691,976475,43153,53202,540464,1025324,657396,234065,824283,529289,385629,905028,552947,84232,904197,314626,441807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]