SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512881 LIMIT 1 [ RunTime:0.000824s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512881 [ RunTime:0.002141s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (77649,505125,729885,954795,1022164,825843,677591,860232,127306,19050,102326,238263,317950,331077,845400,763186,470019,240549,847738,4546,761596,873191,11776,26087,212807,1022554,788313,867436,641411,1037681,1031144,685463,676573,397290,382406,129156,709020,56222,101867,480661,524307,896816,1044178,339016,177448,686486,372704,993309,645943,463648,483375,4867,778441,186638,466717,903569,373477,770214,411109,392237) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]