SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44394 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44394 [ RunTime:0.002248s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498483,620609,528525,901242,782408,70565,737432,529004,250709,341124,340397,455291,608656,325226,491493,25056,151630,27243,876075,957108,889266,122096,405795,565946,308690,396116,1033264,895226,148623,284972,106737,109859,605084,411599,612120,855468,319528,493813,737719,201606,683564,220598,876661,863984,63579,607742,640475,181839,531246,619377,77965,372253,994507,155155,695406,101167,240636,575139,833752,701430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44394 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44394 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]