SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412896 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412896 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (790098,32463,546158,584590,109633,255208,810928,1025555,36246,752959,536769,202205,279123,1015063,28787,398586,146778,356560,120640,294517,978137,694937,286738,217934,470895,326444,505875,354010,1041245,58531,337201,286510,657355,131469,96969,145341,707331,238732,750482,194141,48767,264562,37463,1028054,294995,901615,485895,517352,318460,418165,754654,248202,546635,275739,987049,510161,658588,873928,924169,392062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]