SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562180 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562180 [ RunTime:0.001740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404422,836995,56065,127757,822693,339899,282919,515409,795359,868911,318894,924836,339074,741585,1042616,446530,568890,742034,763569,1045861,412204,831902,518243,284853,726540,540982,337086,34968,90989,719499,1013529,128926,1033188,797264,656474,482351,934962,786721,80913,727573,364262,707002,344979,1032067,226898,418404,541005,523846,491764,259350,684948,267763,655873,553144,5888,221919,524165,895276,381055,153769) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003521s ]