SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001733s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 831493 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 831493 [ RunTime:0.002267s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292639,348711,125378,425627,987800,32721,1039494,115183,182236,783047,703720,149466,779133,654401,192770,116080,879939,257037,877771,665555,618618,895227,524019,269226,715315,476593,1037642,675397,115365,397144,144219,485152,715881,1000176,575856,330589,15745,926602,355602,775930,836480,706861,541223,825111,38630,827323,892362,869071,399581,127022,256689,234461,608729,398182,901030,679364,236375,764456,611337,963554) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 831493 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 831493 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]