SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342310 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342310 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (565845,662379,166382,751113,867197,367364,663216,709649,654827,700089,410070,897225,796967,286210,397755,523616,888812,1040811,1038103,394007,450987,949726,933026,92263,264481,443110,475948,1025010,648223,629000,933625,510986,797752,699029,986832,16682,979293,329483,521621,723293,251268,509192,931914,576390,32171,118527,670571,828678,476938,889415,780742,483277,939957,962888,587766,964769,1029146,577857,919132,508432) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]