SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396618 LIMIT 1 [ RunTime:0.001660s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396618 [ RunTime:0.001641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (211413,294985,441234,572475,1034296,723847,543437,886220,57970,96699,866138,925837,135299,873322,125510,102212,152689,838428,26536,160275,1045298,835784,624981,638884,354667,656955,658099,438557,1040016,300975,681483,28194,340619,657996,456689,244579,374924,767075,573562,543961,193078,856081,466664,766869,322310,531408,445179,470968,90073,635850,41069,743781,87659,375171,637367,678464,874794,216837,609484,215707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002664s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]