SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 47369 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47369 [ RunTime:0.001774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (494700,1041352,201073,964460,895049,799984,675566,36078,1048656,72259,92927,685922,576227,495946,279825,963744,907972,237779,610566,639976,55880,383654,670935,52530,901160,93751,289755,72858,818498,243388,547319,641763,823514,842042,570598,87135,939202,969947,450701,156392,13961,459207,219527,762397,634499,378123,750195,555811,4139,810389,331050,908558,293222,413409,504333,236115,409757,159711,729898,99197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47369 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47369 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]