SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509251 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509251 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (672702,195589,461981,243806,555939,6071,101070,830938,226297,1002558,749172,267166,767634,158213,752946,797215,940453,442720,787391,463863,193737,95552,722615,935253,192006,813568,977704,248188,765558,556037,1031011,634546,518671,939428,83761,880256,313611,611895,667854,515131,333769,407908,476786,394987,88850,30980,418969,572541,550416,84864,104974,919427,279032,708122,760795,206517,581261,852444,828668,508409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]