SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54635 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54635 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101345,1035575,488573,982730,107917,934155,125092,331932,10297,944562,759227,611631,675610,14790,1010741,217565,860928,50004,586686,879656,813298,772156,598208,145572,220242,317536,1040129,184351,352130,929305,81967,840339,817606,585261,663801,75569,192085,563077,848170,712053,175666,949427,679999,130442,316095,374864,769009,135729,599965,187114,486482,27359,466566,630754,735137,718658,714403,487171,388042,917842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54635 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54635 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]