SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010342 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010342 [ RunTime:0.002159s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812222,419940,342878,37795,91693,987036,151978,436809,915308,390950,566322,592028,749943,818976,678407,595407,1005709,325723,73417,750484,487739,861820,921711,295408,239526,122191,73949,355486,7013,475046,1002271,1031739,756835,1019736,366681,538949,633807,789242,192962,828249,832962,171008,90200,288120,139594,182015,162179,821989,146704,980627,450607,226353,911000,294901,53013,162556,632044,471312,1012658,456853) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010342 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010342 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]