SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036018 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036018 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595534,1003802,605515,271503,48903,860021,462437,771200,291618,850037,707559,601696,45,697779,327883,385791,534012,498996,715729,513884,750279,921245,781118,709602,142529,976740,142296,14294,150740,321487,959070,390661,735157,123321,293888,412096,333609,425212,27533,26265,257819,926359,285572,52764,333884,998581,978035,869945,153422,115598,94481,899771,38033,865805,705907,775271,28436,711250,969517,681946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]