SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017044 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017044 [ RunTime:0.001973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (935493,364502,366781,660491,995156,694622,267186,446729,247842,272881,79485,63592,335394,552200,419060,679271,810792,675782,787316,610767,483033,891717,990508,143173,444957,894513,480649,389664,926882,34057,18941,384820,74776,580550,353003,20519,602113,499337,619574,949226,765375,164471,635251,286067,412355,137283,903159,173329,580887,228385,1029839,937793,638549,496487,185504,94405,932561,614745,722138,678839) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017044 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017044 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]