SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002025s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 326918 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 326918 [ RunTime:0.002003s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032090,255030,600766,666502,945866,50958,974106,793899,350135,907102,552722,312225,603121,765859,30002,290931,1044389,451746,691428,178975,842666,560548,1025158,924237,365800,320722,105423,747028,124842,1039857,981289,291399,780180,732646,711377,436473,878887,1046130,733039,161211,746042,850688,744891,711581,784359,755529,110131,297609,725972,372983,515884,833451,310452,1032506,672267,892122,155928,484445,626934,303642) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 326918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 326918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000678s ]