SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001667s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106488 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106488 [ RunTime:0.004223s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (778542,166328,192289,1017812,11423,98057,1019720,300189,68945,1032752,483942,650977,191296,98114,630040,829049,354720,720531,442539,928437,266859,417513,3550,695405,313200,975999,139321,31154,250437,1032767,739851,1004124,147742,733298,217647,615012,44677,301450,243976,856295,425865,493413,160896,36363,1033445,639231,912640,64096,296864,430966,545998,628904,853131,838991,519925,458048,1009703,160089,11034,411538) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106488 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106488 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000683s ]