SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001467s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422611 LIMIT 1 [ RunTime:0.000477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422611 [ RunTime:0.002222s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (147980,297124,854245,1038207,661134,733585,546691,153681,964532,893056,24840,280119,705381,720650,427396,334475,1003146,168004,951338,60954,296124,518026,548847,764631,706872,480597,213044,511124,607346,887386,316811,103444,543080,471021,860822,405531,27748,632865,252180,877250,314158,942807,928449,246402,607355,548440,848637,884444,221664,152721,53362,537033,732630,231965,855615,784860,833061,814560,495858,814612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001758s ]