SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313133 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313133 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (115559,1010293,352789,295790,752010,1039924,643903,330038,143577,814837,1036329,257360,552375,312339,140390,435422,279954,638759,450114,517230,595625,474759,1032826,166278,10983,883211,645487,993212,898730,684473,626895,103787,303980,762558,494425,392250,296595,1026935,329338,139686,584560,260951,243136,884529,637851,745681,314213,1005980,254249,155622,107063,692934,386387,927641,363275,554374,879350,54126,670949,39014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313133 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313133 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]