SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009163 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009163 [ RunTime:0.001292s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10598,81661,2761,412522,285116,644400,564580,247786,1022137,338236,224512,469946,710802,380617,146922,603652,152860,263024,1005058,79335,819193,396523,709098,377117,89173,519217,317168,650602,571895,49519,692881,1000850,721789,164787,141952,135140,897374,578384,352942,960432,954630,665577,402236,882554,875544,295895,713190,244212,236715,720628,324964,632072,854465,852146,669632,312101,994101,573166,23889,741671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009163 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009163 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]