SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001572s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497521 LIMIT 1 [ RunTime:0.001310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497521 [ RunTime:0.002331s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356187,101337,668992,455465,42132,680171,847112,347420,199172,1001532,200105,1009618,76298,854125,954086,662257,813625,310804,537587,618287,355699,497632,777792,1003230,991497,584959,97709,601359,88205,89186,655421,204808,902371,547302,573103,247625,132664,516067,266203,971326,778428,37921,8778,203789,279807,123116,1020719,753370,788423,762243,632696,931373,614444,201085,927480,13804,366648,716082,676880,1025314) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.039508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002239s ]