SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510958 LIMIT 1 [ RunTime:0.002236s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510958 [ RunTime:0.003291s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (226981,134858,736990,864473,120065,121352,388833,349646,829363,881829,923556,447327,978171,80885,44681,315052,790575,248949,436049,824995,633544,697377,978898,345372,967586,717349,225861,638275,941145,38209,917704,852203,904491,693102,875983,538562,791146,754638,874723,784250,453729,427413,223115,688225,883482,714478,170450,529908,97101,89524,218869,591735,841945,20379,868486,1044983,123858,677885,894265,327247) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510958 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510958 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]