SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037929 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037929 [ RunTime:0.002237s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280126,46499,14063,88280,245441,751877,1011676,112941,508813,243592,348901,39304,1027170,1000760,67595,929196,771654,1025138,282122,1012263,603167,525513,274960,12126,707647,345878,315123,788847,675100,1033944,251170,127510,484075,746670,70094,478625,437108,791433,459151,916295,351387,556700,240046,436781,603615,886537,980115,915066,421246,536422,622798,159421,206070,480521,344717,877076,856263,969099,315789,845533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001636s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037929 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000612s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037929 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]