SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019539 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019539 [ RunTime:0.002289s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444022,766919,799025,636616,193862,872471,1022863,739506,551285,721109,884210,207301,742938,262153,876065,118948,526917,573008,93867,751561,740912,564201,391376,922451,509580,302904,401779,901665,222358,623398,596215,8776,565814,841136,272227,978997,373071,1005328,668465,368693,667582,686186,888308,321173,264517,398408,843177,660410,636015,74851,530076,791224,288031,24374,713538,784856,233113,845232,35277,576786) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019539 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019539 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]