SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002049s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454710 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454710 [ RunTime:0.002508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (26162,81941,604153,665339,266365,729238,808105,259475,876366,90487,203708,814971,917781,23645,750100,957654,551582,845000,678661,344498,912572,1044868,1037068,91568,754755,696992,766427,626772,228621,69978,628281,663366,682813,525372,903872,346389,471246,155958,311151,208786,694929,567194,797792,561046,207870,902481,491076,773324,106326,927171,336870,252323,329131,515122,347350,800221,349947,364354,648075,790982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000860s ]