SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 55890 LIMIT 1 [ RunTime:0.000706s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 55890 [ RunTime:0.002007s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10046,135468,361951,335500,596969,451890,489281,534425,913034,58499,755929,751546,290679,208515,984340,87820,520480,874444,345848,571670,469835,127440,316138,1036664,390045,46065,962554,418675,783160,908363,419226,275343,611017,871204,318614,382545,863711,982420,16924,951893,725826,755842,238590,398233,715848,178247,359869,775597,495613,613652,771024,28437,856796,876739,499754,391200,896182,976763,605286,962308) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 55890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 55890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]