SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004512s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 838190 LIMIT 1 [ RunTime:0.005169s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 838190 [ RunTime:0.003116s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282191,393225,849484,524808,912505,389739,285299,1003337,652948,719678,703359,446194,197422,575207,1007698,674488,796672,76788,455677,560719,102577,113638,861022,21289,781034,807244,505566,601466,488626,254315,692474,348450,514586,179166,888366,555792,415758,490240,889297,4967,149955,627501,469328,199400,903753,622918,442536,703950,645509,647634,10870,895541,1035381,155337,367928,635936,399025,250674,315923,282592) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 838190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 838190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]