SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021014 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021014 [ RunTime:0.001620s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939641,622550,934102,525202,169301,168779,649592,168783,573449,948721,842969,818975,777073,742225,661412,547235,368535,340218,907345,1032211,722851,77213,296981,388124,16975,871272,583585,880674,673308,1023890,873598,631676,686804,708965,288536,204593,75912,837181,156737,146033,885170,389067,73672,352950,1005592,1035057,944593,504476,261408,775639,171803,51180,193689,798895,156598,598150,40667,1043589,1003909,942639) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]