SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539600 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539600 [ RunTime:0.002413s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (360862,573454,668427,501588,436527,703211,730741,716940,250925,400357,989661,962414,812503,83448,168012,587870,112392,833689,578654,770623,414057,956895,614092,375561,504213,509418,278800,811172,19259,756211,560888,838704,462279,489642,446545,1020122,504326,473549,540561,847518,86798,597713,389772,428753,311490,1035626,719501,762390,101189,488856,357438,577538,477945,648127,1033354,233525,854137,476622,1015245,832179) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539600 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539600 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001267s ]