SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 36580 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 36580 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (918235,643993,148412,191270,190465,1011925,489689,158268,719095,29615,202206,381592,677524,704703,262670,905486,397956,937493,314245,604088,379560,777303,582556,926711,342261,628565,180997,942895,845389,186396,783265,602161,788581,830018,119934,991706,709656,571275,995892,16149,1010827,762260,1045092,861195,970765,221222,1038840,884088,291788,545814,791345,662135,213782,970071,319969,738104,132857,284477,117108,317275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 36580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 36580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]