SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404639 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404639 [ RunTime:0.002330s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384291,486071,704227,183078,530312,491260,274451,1018925,573881,458032,839753,589959,242638,179544,459299,535232,772407,959542,621302,509979,742063,243973,516169,680106,464248,141007,599164,634198,807769,971247,701143,1005737,167435,872544,909647,149978,143525,256665,439713,78760,500488,293921,799890,776595,396576,165276,782166,833012,280833,347689,442722,109772,514996,86331,442846,231415,796367,465697,228039,1000563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404639 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404639 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]