SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349917 LIMIT 1 [ RunTime:0.000665s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349917 [ RunTime:0.002913s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (804148,163827,724352,441999,576812,62170,768213,210278,893588,197525,480012,1784,674283,829659,480939,49030,102248,773544,509363,263638,241365,8480,183274,597435,67542,947006,674631,214967,23122,394047,938303,731457,714891,266397,1048346,397799,777653,610285,617343,367435,858997,466437,521136,76562,964278,796086,86979,397663,357576,27725,69949,1029045,580948,435426,558562,38048,392122,673209,822433,407513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001269s ]