SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002659s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111110 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111110 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (657874,1003227,465767,49139,456676,155421,675156,512771,62247,454257,809468,764577,443164,923322,271876,1002778,735015,74929,1043973,758529,775550,580535,396110,35515,900755,32604,112681,380233,105797,201458,662029,532457,323531,596464,244792,737090,612884,836735,672490,70675,8618,794487,708850,337386,741305,98418,850903,1030170,463474,711177,537490,801080,612480,551951,150863,1041553,633633,1011678,826664,393617) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]