SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001714s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491530 LIMIT 1 [ RunTime:0.001997s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491530 [ RunTime:0.003105s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (699321,568467,934983,377513,565474,290235,444174,693318,257423,690836,326335,907118,969651,100663,431029,695575,1003304,137023,695491,969006,424736,686205,297398,647147,177499,107579,1045957,258051,383091,394479,102471,1030781,561568,647516,551594,329243,955599,176112,118002,246849,548287,306589,79333,90946,701680,244765,307682,928010,685141,396609,537260,24840,604535,971053,794070,503681,872835,38612,204126,8727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491530 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000690s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491530 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]