SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 878838 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 878838 [ RunTime:0.001831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (379160,425149,758560,99424,106687,835994,1045905,200858,892399,97692,473706,901670,193681,532230,902146,148239,475408,490138,240932,819242,1032952,797532,825901,989649,775578,530834,749375,385522,89647,629860,1041005,684712,299169,356383,322282,592024,433253,456279,735555,352040,1033783,497817,388543,807245,253146,1022366,287199,629243,795225,482398,779890,482160,74933,201540,278830,1033300,949824,881635,807496,595834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 878838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 878838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001270s ]