SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311392 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311392 [ RunTime:0.001476s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013624,561414,226287,290813,685334,614115,203358,129588,563641,386153,961070,372070,997863,1005583,82177,788194,374550,442107,846324,792707,747052,515160,893899,465090,189060,160480,681606,223635,701226,254304,770389,1012959,14626,345546,68679,843598,416407,604434,325203,894160,81940,759905,538425,884832,197265,736098,282566,742750,600433,80337,631644,938748,854462,416671,782053,557005,830238,353161,606590,630802) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005850s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311392 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311392 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]