SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 446286 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 446286 [ RunTime:0.001919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104043,750901,858124,1026828,289205,166611,787361,579578,445151,480948,719712,950576,757743,504400,699922,531336,641927,167142,127807,171973,729264,22484,475374,896320,1024383,551943,924445,802021,524251,501329,979835,455224,564372,514887,541306,188784,643699,18361,416429,245653,46907,94169,301488,698653,125223,1022195,940868,949896,481394,970074,442619,881648,558374,1031456,613082,263471,329229,665515,55741,329598) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001875s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 446286 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 446286 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]