SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001810s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39137 LIMIT 1 [ RunTime:0.000484s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39137 [ RunTime:0.002103s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (326045,293682,801178,110251,267545,20043,650735,505816,262275,464964,56486,119113,592159,207239,823857,441603,132360,1034890,572760,519479,379328,415957,383181,562994,440230,556102,833806,597975,874663,749222,597491,182807,562895,105922,977895,472508,156248,562493,896025,666414,423835,204800,435806,30345,524008,323239,254295,817726,99101,515446,773893,996933,579109,20083,4259,673181,834316,678515,819161,543541) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003890s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39137 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000557s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39137 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]