SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002399s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017554 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017554 [ RunTime:0.002215s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (827000,328553,589992,504946,115495,1028211,216883,474930,512013,699435,349712,698886,487521,310650,605228,575614,286485,865056,124581,144903,531778,597012,247931,241283,333069,205714,654134,782383,750368,1041774,365498,270383,137041,947787,408551,820566,383502,593398,671194,375267,443102,986957,395263,801356,575445,708049,724401,889306,574967,221186,497711,758550,992598,612608,406069,862892,556502,916052,586350,166810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001895s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017554 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017554 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002258s ]