SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406084 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406084 [ RunTime:0.001832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (83239,874637,35206,429364,694939,133259,748835,719964,942792,953837,324412,200683,556489,937373,1045770,570167,789296,968658,1036512,346079,350347,646903,922708,201774,399000,1026887,862583,519410,185877,60747,820035,309300,831154,853052,147528,8994,620748,237694,949838,311309,119230,699649,442969,113149,70991,881282,252442,604592,285742,31324,830000,265622,881581,1019283,692570,411820,680671,869896,1008409,732922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]