SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292109 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292109 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020826,244791,626566,468010,396119,354688,429157,1837,967153,12960,898334,726784,662299,222472,998664,246109,189065,273988,170718,817549,1030332,976751,208185,385535,550085,515078,260061,854898,154375,130798,245105,782681,101008,48022,439949,639825,47560,548722,166862,24020,616365,300555,338095,57664,388759,150786,291882,911469,665175,307394,732783,707640,47108,425349,422455,875670,241294,322737,915351,145102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]