SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109704 LIMIT 1 [ RunTime:0.000872s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109704 [ RunTime:0.002700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (192353,615256,470987,943188,1036787,68676,452052,549525,878688,156800,804630,26312,956532,896803,543601,769535,578609,440842,1010235,733991,208627,955502,277975,678874,961422,54815,713813,174480,250933,763938,974901,103468,412699,857207,416089,499211,821799,793838,101671,1026028,499087,933083,36241,752092,190427,758583,83087,421173,708386,104581,536829,464506,221790,430518,362099,452952,71881,151532,492271,744209) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002612s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000689s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001097s ]