SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598016 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598016 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118236,715230,852351,542932,872619,795623,526041,618436,41950,52169,39714,1042969,517447,326503,19240,835198,482233,173962,587329,17445,533250,930703,429266,807165,433243,487988,409196,720012,154519,221444,103683,796570,613284,500508,972367,679121,279956,133700,413834,794784,296646,861291,160420,714751,591973,322475,552002,615807,106944,667623,37878,346896,103007,391888,299700,634695,398623,1027272,325087,659368) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]