SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34642 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34642 [ RunTime:0.003101s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445331,299837,730658,387245,441204,745864,100165,337985,75246,806477,141944,834132,1002360,695305,48143,820995,611783,219992,57815,471310,1026436,1027062,1037014,337295,635644,233685,601196,652141,439290,148410,837055,313674,198489,1030765,343801,912617,214106,14089,1001048,708028,610863,105293,794684,61117,212379,127252,1040475,158799,994375,879080,496370,753978,277157,1011964,1003532,66219,603142,570008,764387,520748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000935s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34642 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34642 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000390s ]