SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428084 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428084 [ RunTime:0.001549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426037,99403,1020705,576202,844544,176625,161287,300180,424287,772015,626179,560803,228978,635769,209812,832593,257764,894713,777619,397353,869648,1015182,700874,447366,860263,300122,613428,913737,734847,504354,643087,291468,469375,231373,22781,123786,879159,314155,824116,735828,735428,694896,356960,340546,859028,264535,721173,457493,180989,134442,120646,383989,562878,495350,531383,244820,705840,314193,573927,563627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]