SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316988 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316988 [ RunTime:0.001536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320423,544565,778538,348266,868924,502314,886953,907950,640951,687385,1031846,820170,764094,369015,320904,789106,862242,674192,978692,922629,561632,879035,386388,472907,69236,27276,170213,507684,615616,70230,43297,457557,687881,475689,973084,1007639,971179,1009412,893928,596981,576260,479787,750045,161730,354430,366259,213456,254598,624429,629540,836267,54112,219529,434209,909146,262299,642456,801669,489964,752800) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]