SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503883 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503883 [ RunTime:0.001454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (606330,595232,614071,699136,470573,393656,1014572,749362,989415,541575,1010104,779487,151162,603728,530625,250529,373358,936545,855392,932306,274775,290842,955981,133473,321094,12741,656209,610981,990514,584953,347808,851956,930426,53862,452777,720305,576851,854998,337076,518152,664193,1023675,462133,456168,112569,718900,705286,291248,703246,983233,115647,783757,481112,877581,465913,917559,32827,514153,248463,802313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]