SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341990 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341990 [ RunTime:0.002002s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (160500,561405,318200,1035405,431229,309585,787531,355390,278514,718593,870029,86566,451330,308670,440383,746949,613774,281777,302259,710714,258515,703370,575072,967919,22865,374103,946790,1011121,162555,380781,38530,168967,525308,202129,769061,348970,282019,69113,947913,742030,980471,563402,327333,150117,435806,267932,164806,91492,438478,526957,105927,414632,1005687,1026553,233063,599277,338760,261416,670302,277640) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001771s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341990 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341990 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]