SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331008 LIMIT 1 [ RunTime:0.003527s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331008 [ RunTime:0.002614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912801,998462,722081,718260,152835,675155,475960,902439,169388,422421,387398,846055,44451,661659,67103,104954,386110,989956,202675,77888,214102,862183,528939,500463,917148,650437,491846,1010361,815545,4725,774416,245769,673090,762975,734877,542094,123354,553996,465965,961154,447041,591069,273040,257086,748108,387393,589758,395849,494482,557169,993911,53597,122836,901873,363698,470264,708056,941820,969271,532126) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]