SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319441 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319441 [ RunTime:0.001817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (491990,1033178,193854,162187,48054,312670,316989,881989,446335,734464,853125,524126,1003667,578262,1040092,130195,454382,96932,653944,998273,338737,366709,960490,844523,794803,427220,772262,20752,881246,1024503,201415,222878,799095,813154,1029034,750693,635397,953354,674435,929633,713045,952646,785423,211323,452788,622771,586420,854190,272296,839155,126288,602174,273191,400272,982000,641089,325204,625416,861297,414390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]