SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540911 LIMIT 1 [ RunTime:0.001282s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540911 [ RunTime:0.003020s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621421,213914,573936,432901,128532,465714,864864,463472,1035146,75222,118018,830014,736786,661438,560896,140134,803040,647141,1017057,545582,433563,734698,254647,1045780,64684,777071,694556,215425,983653,119684,52466,153227,504521,816630,1002579,260061,691057,558705,872817,591844,930929,840504,868847,154024,219497,633721,245893,524304,830384,596749,632777,402510,928168,951320,327760,468746,203300,797074,267780,650241) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001024s ]