SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001438s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 841404 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 841404 [ RunTime:0.002038s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (977192,91599,1033965,1027975,231515,175906,575055,128629,863052,925650,928032,387303,62814,215810,1025048,166265,250915,396191,766631,398512,547268,343079,478059,306480,930383,245973,398692,827988,948881,921560,499279,958056,656628,968583,871458,44509,871513,312879,174881,1032190,412882,345589,431789,253342,506646,1019870,718007,715693,677358,846980,163960,323402,433376,621221,734225,687974,924006,539616,930681,734481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002303s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 841404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000660s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 841404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001319s ]