SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001502s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412263 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412263 [ RunTime:0.002626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005488,896265,377830,742949,104214,848499,620865,124535,483869,168589,269647,586507,340147,612751,56874,444916,824282,154014,425950,435925,635823,449886,271116,742664,158327,312088,916823,102284,994211,464521,205000,1026507,843355,397476,644162,990054,898027,801701,354568,746363,674718,445150,682107,277279,448023,495030,580103,108952,657741,101672,694893,568520,505952,508320,255121,414012,81131,500145,1001563,213743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412263 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000718s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412263 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]