SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111190 LIMIT 1 [ RunTime:0.000612s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111190 [ RunTime:0.001643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (656861,1006818,901981,11241,168169,769681,334021,720813,884515,11637,622724,902349,306410,573747,311252,390741,827071,935210,254764,430301,65157,62901,170783,415334,299380,100095,511429,194759,735130,483772,922045,651564,455988,933333,100919,84447,371277,50355,313803,3165,265580,697550,129136,594790,742899,23970,148982,708844,229785,994729,445040,161456,531351,750639,1038253,310167,999348,521125,170613,307169) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000752s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]