SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412515 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412515 [ RunTime:0.002007s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393892,346395,205939,780460,274428,71419,916448,588541,918456,289367,532257,1032099,688000,740417,759099,206314,185535,69553,755360,261803,658943,1003491,494700,284309,554883,919385,865213,475324,516821,983839,206865,350800,903279,715808,337182,656831,637497,746436,847239,246725,819798,575663,49233,677249,439922,186075,426034,182699,804503,944965,473839,1015674,643017,921582,446295,233812,613826,1017357,657546,474570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]