SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040281 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040281 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (396596,752317,495879,898768,745497,3730,175605,633050,43107,233757,899788,178085,202400,575936,431637,636188,835999,943710,453163,377771,816706,429968,940094,997196,305332,848790,932447,886550,183371,637369,596101,983394,972479,495933,7271,276284,803294,586737,1007264,599684,151131,82125,418433,232992,1028813,1000024,200041,514909,867188,857600,908553,475308,965879,137584,535482,816738,436895,682071,739186,503156) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]